Video Screencast Help

Search for Users Who Are VIP

Created: 07 Oct 2013 • Updated: 08 Oct 2013 | 2 comments
Lark's picture
This issue has been solved. See solution.

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?

Operating Systems:

Comments 2 CommentsJump to latest comment

reecardo's picture

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.

SOLUTION
Lark's picture

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.