• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Smart Notification

Query Syntax

 2 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
B. Smith
Basic Member
Posts: 8
Basic Member
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
Basic Member
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
Veteran Member
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?
If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/