Search String in button

[rido1421]

Hi There

I have created a Button with an action that does a "Select in field"

My search string is as follows :  (Car|Boat|Plane)

This works correctly to select those values in the "Categories" field.

How would I do a not function in this as to select all possible values except those 3 values.   NOT (Car|Boat|Plane)

Your help is appreciated.

[Anonymous]

Hi

Please post sample data.

[Gysbert_Wassenaar · Accepted solution]

I think this should work: ( * ^ (Car|Boat|Plane))

Perhaps this document helps: Compound Search - demystified

[Anonymous]

I am not sure if this is possible directly

a Workaround would be:

1) define select in field Categories:  (Car|Boat|Plane)

2) define Select excluded in field Categories

[sunny_talwar]

How about this:

='(' & Concat(DISTINCT {<Categories = {'*'} - {'Car', 'Boat', 'Plane'}>}Chr(34) & Categories & Chr(34), '|') & ')'

[agomes1971]

Hi,

please see this

Expression in Search String via Action button

HTH

André Gomes

[rido1421]

Thank You, This worked great