Question

What is the logical function for ‘does not contain’, when searching records??

+5

Hello Community,

I have a question regarding the ‘does not contain’ function (!~)in the search field.

For example, apply search on the “Note” field in the ‘Change Orders’ window and search !~any text (!~YYY).

Is this give records that do not contain the relevant text (YYY) and records that have empty notes? Or only records do not have relevant text (YYY).

What is the exact logical function in search to get records that do not have the word and records which have empty notes? (!~YYY or !~YYY;<>).

Thank You!

+18

Hi @talwlk,

If you want to search change orders having empty note then search by using !%
If you want to search the change orders which don't have a specific word in the note then search by <>% word %

Regards,

Mithun K V

+5

Hi @talwlk,

If you want to search change orders having empty note then search by using !%
If you want to search the change orders which don't have a specific word in the note then search by <>% word %

Regards,

Mithun K V

Thank You!

Sign up