PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 02/26/2013 9:49 AM by  Matthew Nye
Query Syntax
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
B. Smith
Systems Analyst
EDMC
Basic Member
(20 points)
Basic Member
Posts:8


Send Message:

--
02/26/2013 7:56 AM
    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
    Systems Analyst
    EDMC
    Basic Member
    (20 points)
    Basic Member
    Posts:8


    Send Message:

    --
    02/26/2013 9:49 AM
    FYI - I found the answer. For an LDAP query you need to use LDAP syntax (which is similar, yet different from SQL)
    Matthew Nye
    Private
    Private
    Veteran Member
    (1532 points)
    Veteran Member
    Posts:514


    Send Message:

    --
    02/26/2013 9:49 AM
    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.