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:

SELECT

'${LAST_NAME}'||, '||'${FIRST_NAME' AS AFXCUSTOM_CUSTOM_DISPLAYNAME

 

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.

${access_request_LAST_NAME}

${user.LAST_NAME}

${access_request_cri_meu_LAST_NAME}

 

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

Outcomes