Stored Queries more than 200 chrs in length.

[msimonis]

There appears to be a limit of about 200 chrs in the Query field of 'Stored Query Maintenance'. Also one cannot use '..and Field1 in ('val1', 'Val2', ..)' as one might in standard SQL.

Together, these restrictions means that I cannot enter a complex query that I required.

Is there any way around this ???

[tommy]

Did You try escaping the ' ?

\'

[msimonis]

Thanks for response.

Not sure what ' symbol you are suggesting I escape.

The query I want to store is:

flag=true and category#"Fault" and ((flag.noc="NOC LHR" or flag.noc="NOC" or flag.noc#"NOC Shift")
or assignment="NOC LHR" or assignment="NOC" or assignment#"NOC Shift") or (secondary.assignment="NOC LHR" or secondary.assignment="NOC" or secondary.assignment#"NOC Shift"))

[tommy]

Sorry misread. Try "isin" and then the list.

[msimonis]

Sorry, still won't parse:

(flag=true and category#"Fault" and flag.noc isin ("NOC LHR", "NOC Shift Leader"))

(apm.list.problems,select)
Invalid syntax for query. Failed parsing (apm.list.problems,select)
Unrecoverable error in application: apm.list.problems on panel site.test

[tommy]

Sorry, still won't parse:

(flag=true and category#"Fault" and flag.noc isin ("NOC LHR", "NOC Shift Leader"))

(apm.list.problems,select)
Invalid syntax for query. Failed parsing (apm.list.problems,select)
Unrecoverable error in application: apm.list.problems on panel site.test

try

(flag=true and category#"Fault" and flag.noc isin {"NOC LHR", "NOC Shift Leader"} )