ServiceDesk

 View Only
  • 1.  Search for Users Who Are VIP

    Posted Oct 07, 2013 04:59 PM

    Is there a built-in workflow component that can search for and return an array of userinfo objects based on the VIP property?  For example - all users who are VIP or all users who are not?



  • 2.  RE: Search for Users Who Are VIP
    Best Answer

    Posted Oct 08, 2013 07:19 AM

    I'm not seeing one immediately. However, you could generate one pretty easily with a generated SQL script component.

    The script would be

    SELECT * FROM [User] WHERE VIP = 1

    You can amend the script above to also look for VIPs with last names starting with supplied parameters, like this:

    SELECT * FROM [User] WHERE VIP = 1 AND LastName LIKE @MYLASTNAME + '%'

    Ideally, you'd just want to bring back only the columns you need (like UserID or PrimaryEmail). That way you can use the other "canned" comps that can fetch the user by ID or email.

    Hope this helps.



  • 3.  RE: Search for Users Who Are VIP

    Posted Oct 08, 2013 05:11 PM

    Thanks reecardo I couldn't find anything built in either.  I was hoping there was a component with an unusual name or something that could do it.

    So back to the good olde component generator!

    I ended up creating a component that just returned an array of UserIDs as once I have these I can do pretty much anything else I needed with the other user management components.

    Thanks for taking the time to reply.