Using Directory Service data elements

[SusanGorman]

I'm trying to create a data element where a user can pick from a list of user names from Active Directory. For example - who is the project manager for this request? User picks the name from a list, then ideally I could have another field that would automatically lookup the selected project manager's extension and email address and display them.

So far, everything I've read seems to indicate that the Directory Service data element is only going to show data about the currently logged on user and there is no way to make a pick list.

Am I missing something?

Thanks,
Susan:confused:

[Cary_R]

Hi Susan,

You're correct in that the data type is only going to poll data for the logged on user. You're not missing anything here; there's nothing specific currently in WFM/AES for this.

However, there may be a way to get this to work using SQL Server via the Database Driven data type. It's my understanding that there's a way to query AD via SQL Script, and parse the results which come back just as standard rowsets. Some quick searching on this brings up:

http://articles.techrepublic.com.com/5100-22_11-5259887.html
http://blogs.msdn.com/euanga/archive/2007/03/22/faq-how-do-i-query-active-directory-from-sql-server.aspx

I haven't tried this myself, so I'm not sure if there's any hiccups with this, but it should point you in the right direction at least.

Hope this helps!

Regards,

Cary