multipel criteria in inbox

341
2
03-29-2019 02:03 AM
JonasOstberg
New Contributor

Hi

how should i write the inbox query so that the inbox retrives based on two questions

choice1=FAULTS

choise2=blank (no choise marked as in "null")

this due to my non existing knowledge of SQL writing

thankyou

0 Kudos
2 Replies
JamesTedrick
Esri Esteemed Contributor

Hi Jonas,

In this case, the statement should be

choice1 = 'FAULTS' and choice2 IS NULL

One way to check this is to go to the Service URL of the feature layer - you can try out this in the 'query' action (this is the 'where' statement)

JonasOstberg
New Contributor

Thank you

0 Kudos