Hello,
I'm using "Active directory" connector to update one of the attribute in AD.I'm taking the values from the internal database and placing it in AD attribute.When I execute the query in database results are coming in line-by-line.
But through the connector I'm unable to include the line breaker between sentences even though I'm using "CHR(10)" in query.
Actual output= Location Code = 10
Location Desc. = US
Rank Code = 13
Job Code = 23
Current output to the query:Location Code = 10Location Desc. = USRank Code = 13Job Code = 23
Can we places the values line by line in "Active directory" connector template?
I was able to reproduce this. I can confirm it is some sort of limitation/defect in the Workflow processing and how it stores values.
I used a very basic WF which selects values into workflow variables then passes them to a provisioning command node calling the AFX Update Account capability. I used this SQL statement as a test:
The attribute on AD was not populated with the new line. I did a packet capture and found that apparently AFX isn't sending CR LF. It only sends the LF character (which does get stored in AD but does not constitute to a new line in Windows).
Further digging I check the workflow variables table WP_USER_DATA and found that the workflow only stores the LF character and ignores the CR character for some reason.
I think this should go to RSA Support to confirm if this is a defect or a limitation by design.