DOES NOT CONTAIN operator not working with glide record

[janindiadoc_1]

I need to exclude some records with with short description that contains "XXX_PRO - ". I added the query condition in the glide record as below. There are so many other conditions where i am not able to add that as an encoded query. I added the below condition to the query, but still its fetching the records with the below text.

gr.addQuery('short_description', 'DOES NOT CONTAIN', 'XXX_PRO -');

[Ankur Bawiskar]

Hi,

yes it will

Regards
Ankur

[Hitoshi Ozawa]

Hi Anjana_ps,

As is contained in others' replies, there's not "DOES NOT CONTAIN" operator. It's "NOT LIKE" operator in .addEncodedQuery().

To get the query, setup and run the filter on the table. Right click on the filter breadcrumb and select "Copy query" to copy the query string.

[James Fricker]

really?