Using LIKE in my query

App Building
1

  • Goal: Use the LIKE operator in my Query

  • Steps: I tried using '% {{ searchInvItemCollection.value }} %' but it does not work

Here's what is happening when I use the '%%' (Everything after the ' goes green...)

image
image725×47 3.35 KB

Without it (the LIKE does not work)

image
image721×32 2.91 KB

2

I have a similar construction in a number of my queries. Try using CONCAT after LIKE:

WHERE {{ !searchInvItemCollection.value }} OR "Inventory"."Barcode" LIKE CONCAT( '%', {{ searchInvItemCollection.value }}, '%' ) AND "Inventory"."DeliveryDate" IS null ORDER BY "ID" DESC

3

it trows an error :frowning:
image

4

I needed to use this instead ~

WHERE ( {{ !searchInvItemCollection.value }} OR "Inventory"."BarCode" ~ {{ searchInvItemCollection.value }} )