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
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
    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
      Posts: 1498
      Veteran Member
      9/30/2020 6:25 PM
        Oops... I meant \ -- so %5C&4 or %%5C&4
        Greg Moeller
        Veteran Member
        Posts: 1498
        Veteran Member
        9/30/2020 6:32 PM
          Or you could just try converting the & to hex %25
          dcasper70
          Basic Member
          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
            Posts: 14
            Basic Member
            9/30/2020 7:00 PM
              Xtreme incident 14921673 case they have a solution first...
              Greg Moeller
              Veteran Member
              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
                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.