Forums
Smart Notification
Query Syntax
Author
Messages
B. Smith
Basic Member
Posts: 8
2/26/2013 12:56 PM
We found blank entries for users in our CheckLS field. I've pulled the LDAP into SN to build a report to check for this in the future.
I need to figure out the syntax for;
CheckLS=NULL, or CheckLS <> YES or NO
The query language for SN appears to be SQL, but I'm not getting the correct syntax for this. Does anyone have a cheat sheet for query syntax? *I checked the SNUG install/admin guide, but there is no guidance*
Thanks
B. Smith
Basic Member
Posts: 8
2/26/2013 2:49 PM
FYI - I found the answer. For an LDAP query you need to use LDAP syntax (which is similar, yet different from SQL)
Matthew Nye
Veteran Member
Posts: 514
2/26/2013 2:49 PM
when you say youve "pulled in LDAP" does that mean your Data Source for the infoset is LDAP and then you are creating a Notification and want to check for NULLS in a condition? Not sure I follow when you say "The query language for SN appears to be SQL". can you elaborate a bit more?