How do you do a search with contains and multiple fields?

[Christine Ritchie]

This works

 project = APT AND FreeForm ~ NIRCAM AND FreeForm ~ "IMS=True" ORDER BY issue DESC

   This didn't work

   project = APT AND FreeForm ~ (NIRCAM AND "IMS=True") ORDER BY issue DESC

[Christine Ritchie · Accepted solution]

Looks like this does it!

project = APT AND FreeForm  ~ "NIRCAM IMS=True"

[Tyler Brown]

Hey Christine,

Instead of AND in your brackets have you tried using a "," to separate your values?

Tyler

[Christine Ritchie]

I hadn't but none of these work

project = APT AND FreeForm ~ (NIRCAM,"IMS=True") ORDER BY issue DESC

Operator '~' does not support the list value '("NIRCAM", "IMS=True")' for field 'FreeForm'.

project = APT AND FreeForm ~ NIRCAM,"IMS=True" ORDER BY issue DESC

didn't complain but didn't find anything whereas the more klunky search finds issues.

[Tyler Brown]

Can you try FreeFrom in (NIRCAM, "IMS=True")

[Christine Ritchie]

Got back

The operator 'in' is not supported by the 'FreeForm' field.

[Christine Ritchie]

is doesn't seem to work either

project = APT AND FreeForm is ("NIRCAM", "IMS=True")

Got back

• Operator 'is' does not support searching for non-empty values for field 'FreeForm'.
• Operator 'is' does not support the list value '("NIRCAM", "IMS=True")' for field 'FreeForm'.

[Christine Ritchie]

I just thought it could be neatened up ... but perhaps not.

[Christine Ritchie]

I can get multiple fields with

project = APT AND FreeForm  ~ "NIRCAM IMS True"

but unfortunately this isn't IMS=True and there are other True options in the Freeform Field.