• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

IPA v11 - Updating field with a value containing an ampersand

 7 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
dcasper70
Basic Member Send Private Message
Posts: 14
Basic Member
9/30/2020 5:32 PM

Our requirement is to update JobRequisitions if certain fields change on the Position.  One of the fields to be updated is Description.

In this example, the Position.Description is Post Graduate  Year 3&4

When attempting to update via a landmark node, the resulting JobRequisition.Description value is "Post Graduate  Year 3

According to the Landmark node documentation, special characters need to be preceeded by a backslash.  We've attempted every variation we can think of and none seem to work:  Below is the condensed transaction string:

_dataArea="lmghr" & _module="Recruiting" & _objectName="JobRequisition" & _actionName="UpdateOpen" & _actionOperator="NONE" & _actionType="CreateUpdateDelete" & _runAsUser="" & _authenticatedUser="" & _pageSize="30" & _filterString="" & _relationName="" & _setName="" & _asOfDate="" & _effectiveDate="" 
& HROrganization="YNHS" & JobRequisition="13952" & Description="Post Graduate  Year 3\&4"

 

And this is how the result string is appearing in the log file:

results string:YNHS,21000,"Post Graduate  Year 3

 

So it seems to be cutting off at the ampersand no matter what we do.  Any suggestions are appreciated.

Already tried using the "Automatically escape & in variables" option.  

Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
9/30/2020 6:22 PM
I have no reason to believe this will work, but you could try converting the / to it's hex equivalent %2F and try that.. if that doesn't work, an earlier post said that you may have to escape the % with another % so try %%2F
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
9/30/2020 6:25 PM
Oops... I meant \ -- so %5C&4 or %%5C&4
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
9/30/2020 6:32 PM
Or you could just try converting the & to hex %25
dcasper70
Basic Member Send Private Message
Posts: 14
Basic Member
9/30/2020 6:54 PM
Not sure if this is interesting or frustrating, but adding a second \ does change the result. not what I want to see, but something...

& Description="Post Graduate Year 3\\&4"
Result = Post Graduate Year 3\&4
dcasper70
Basic Member Send Private Message
Posts: 14
Basic Member
9/30/2020 7:00 PM
Xtreme incident 14921673 case they have a solution first...
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
10/2/2020 6:30 PM
So, just a thought... since adding 2 \'s produced a different result, how about adding 2 &'s instead?
Orlando Gray
Advanced Member Send Private Message
Posts: 35
Advanced Member
10/21/2020 9:44 PM
Hi, can you please post the solution in the Xtreme incident 14921673 that you reference. I do not believe we have the ability to view your cases.