multipel criteria in inbox

Question

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

JonasOstberg · Answer

Thank you

JamesTedrick · Answer

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)