Inbox Query Expression

405
3
Jump to solution
01-30-2024 10:13 AM
clt_cabq
Occasional Contributor III

I have a survey where I don't want forms available in the Inbox when a property has had its last inspection result in a 'Cleared' status. My query expression for the inbox is shown in the included screen shot, but this doesn't seem to work, any thoughts as to why this doesn't?

clt_cabq_0-1706638369439.png

 

0 Kudos
1 Solution

Accepted Solutions
abureaux
MVP Regular Contributor

I'd remove the spaces from the query: lastDet<>'Cleared'

And is it Cleared or cleared?

View solution in original post

0 Kudos
3 Replies
abureaux
MVP Regular Contributor

I'd remove the spaces from the query: lastDet<>'Cleared'

And is it Cleared or cleared?

0 Kudos
clt_cabq
Occasional Contributor III

Ok, thank you for reminding me of one of the basic rules for troubleshooting - check all the values in their source. In this case I discovered that the field I am querying against had taken on a value of a java script error message that had been spawned in earlier testing. Correcting that value makes the query work as expected. Some days.... 

0 Kudos
abureaux
MVP Regular Contributor

Glad to hear it's working!

Oh, I get it. Sometimes it's just nice to bounce ideas off of people.

0 Kudos