question how to use LIKE in query in Developer forum

how to use LIKE in query

Alon Grod — Mon, 19 Sep 2022 11:25:42 GMT

Hi,

I have this query and instead of using LIKE and sysid i need to use LIKE and the var product.

What is the right way to replacing the sys ID with the variable product?

u_allowed_duplication is of a type list and its a reference to a table, so i need to filter using contains which is LIKE.

bs.addEncodedQuery('name=' + user + ^u_allowed_duplication_swLIKEda1d2ffc1b3db05073542f02604bcbcb')

Re: how to use LIKE in query

Beata I_owiecka — Mon, 19 Sep 2022 11:48:17 GMT

Hi Alon,

try this:

bs.addQuery('name=' + user);
bs.addQuery('u_allowed_duplication', 'CONTAINS', 'be3db45f0f0a0200883347bce1050e41');

Re: how to use LIKE in query

Brad Bowman — Mon, 19 Sep 2022 12:10:46 GMT

Hi Aon,

To replace the hard-coded sys_id with a variable depends on where you are running this script, but generally the syntax is current.variables.variable_name, so you can do this with an encoded query:

bs.addEncodedQuery('name=' + user + '^u_allowed_duplication_swLIKE' + current.variables.product);

or 2 addQuery lines:

bs.addQuery('name', user);
bs.addQuery('u_allowed_duplication', 'CONTAINS', current.variables.product);

both of these examples assume 'user' is defined elsewhere in the script.

Re: how to use LIKE in query

PavanK960672992 — Mon, 19 Sep 2022 12:16:27 GMT

Hi,

if it possible with addQuery go with it because easy to understand.

for your requirement try this.

bs.addQuery('name', user); //if Operator is blank it will take it as =
bs.addQuery('u_allowed_duplication', 'CONTAINS', product); //you get product sysid on it pass it or use current.product

Hope you it helps you.

Please Mark ✅ Correct/helpful if applicable, Thanks!!

Regards

Pavankumar

Re: how to use LIKE in query

Ankur Bawiskar — Mon, 19 Sep 2022 13:47:40 GMT

Hi,

Brad has already mentioned the approach.

Did you try to check that?

Regards
Ankur

Re: how to use LIKE in query

PavanK960672992 — Tue, 20 Sep 2022 05:25:04 GMT

Hi @Alon Grod,

It is strange to me without checking the responses you or someone are marking the question as correct/helpful.

Please make sure validate the responses and mark only which you tried or which are helpful otherwise how this thread will help others and you as well.

There is no use if anyone marks the helpful as comments and try to hit helpful or accept the solution.

Regards

Pavankumar