AnsweredAssumed Answered

Workflow SQL select statement to join colleted variables

Question asked by Danny Bissett on Jul 24, 2017
Latest reply on Jul 25, 2017 by Boris Lekumovich

I have a SQL select statement where I would like create a custom variable using two collected attributes but don't know what the correct format should be. This is required as part of the on-boarding process for a new start where I need to pass the display name to AFX for the AD account creation.


What I wanting to achieve is to create a custom variable of "Forename, Surname" which I will then define as AFXCUSTOM_CUSTOM_DISPLAYNAME.


My SQL statement within the select node is:




All that gets passed to AFX is ", " and no last or first name.


I have tried naming the variables as below but I have had no luck what so ever.





Can someone advise how I work out the correct formatting to pass collected HR data in a SQL select statement?