Add Connection from Data Query not working

[MichaelB]

I have a Progressive Capture form which allows a value to be chosen via a Data Query to basic users. I believe this is querying the h_sys_accounts table, where I expect the Name from the form as it is displayed e.g.

See form field setting below.

I have setup the Business Process to get this value and add a connection to the request automatically, however, this is failing on adding Connection as a Contact (from variable). It seems to be trying to get h_firstname, but since I have selected "field_11" I would have thought this should be grabbing the Display Name or h_name. Can you help?

 

[Victor]

3 minutes ago, MichaelB said:

I have a Progressive Capture form which allows a value to be chosen via a Data Query to basic users

@MichaelB so we are talking about basic users, right? If so the configuration is incorrect as you populate the "Contact" parameter, when it should be the "Co-Worker" parameter. And you need the user ID in there, so the variable you are using there needs to have that basic user ID. And make sure that params that are not in use are set to "Ignore".

[MichaelB]

Thanks @Victor this has worked. I misunderstood the definition of "Co-Worker" as I thought this may be only for Full users who manage the service desk.

[Victor]

@MichaelB no worries. For future reference, this might come handy: https://wiki.hornbill.com/index.php?title=Contacts and https://wiki.hornbill.com/index.php?title=Co-Workers