Document Scan Query
Hi Andy, I want to make sure I'm doing the following correctly. For our Orientation Forms we have three different kinds "Facility+Bouldering", "Facility+Bouldering+TR", and "Facility+Bouldering+TR+Lead". To audit these forms I "Customer Queries" for "Scanned Document Exists" and choose all three and then click the box "Not this constraint".
Then I can write a warning note for any customer who doesn't have AT LEAST one of these forms correct? Or have I just queried for all customers who don't have ALL THREE forms?
Comments
It's an "AND" statement I believe, so yes - "NOTing" it will return customers that don't have all three. Not what you want.
Run each document query individually and add the note.
But, run a test before adding a million notes... :)
Based on the results I get I think it's an "or" query. How can we confirm this?
You are right (just looked at the code)... it is if a customer has ANY of the documents selected, not ALL of the documents selected.
Awesome, that solves that problem (whew!).
Please sign in to leave a comment.