Prev
Next
Forums Smart Notification

Query Syntax

Sort:
You are not authorized to post a reply.
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/
        You are not authorized to post a reply.