Qdabra Database Accelerator

Re: Using a SQL data connection to find a user's email in Active Directory

Parrrott — Wed, 20 Feb 2013 20:59:31 GMT

Thanks for the quick response Ernesto. I actually found that some of the fields in the SQL table had extra spaces at the end of the names for some reason, which is why the FindUsersByName query wasn't working. I used the translate() function to delete those unnecessary spaces and everything now works as intended. Thanks again for the response.

Re: Using a SQL data connection to find a user's email in Active Directory

ErnestoM — Wed, 20 Feb 2013 18:52:25 GMT

Hi,

What you're describing should work. Since you have a scenario set up and a form, perhaps it would be best to send us email via support at qdabra dot com and include the form so that we can take a look at your implementation and identify any potential issues.

Thanks.

Using a SQL data connection to find a user's email in Active Directory

Parrrott — Wed, 20 Feb 2013 16:50:17 GMT

Here is my scenario: I have created a Timesheet form in Infopath 2010 that has a receive data connection to a SQL database, which I set up through DBXL. The SQL table my form is connected to contains a hierarchy for my company. In the form, I have a dropdown box that lists all of the Employee ID Numbers in the SQL table and when a user selects their ID Number, their supervisor's name is automatically assigned to a hidden "Supervisor" field in the form. All of this works perfectly thanks to DBXL. My plan was to use the "Supervisor" field to query Active Directory in order to receive that supervisor's email address, so that an email would be sent to the appropriate supervisor when a user submits a Timesheet form. I was trying to use the FindUsersByName operation to accomplish this, but this will not return a result when I use the supervisor's name I received from SQL to query Active Directory. I'm assuming this is because the name is in a SQL data type instead of plain text, as the FindUsersByName query does work if I type a name into the search instead of using the "Supervisor" field. Does anyone know of a way to make this work? Thanks in advance for any assistance.