question about creating Orchestration.

I created an Orchestration by following the SBM 300 training exercise, and got the following error of "BuildWhereClause" step:

Can someone help with the issue? Thank you

Parents
  • Verified Answer

    +1  

    Composer is giving you clues with the red underlines. Those are showing the parts that it does not like.

    I believe the path (starting with the "return") should be more like:

    \return\item\extendedData\data[1]\value

    You are missing "item", extendedData should not have square brackets, and "value" should not have square brackets. Instead, the square brackets go on the data element.

    See if that helps.

Reply
  • Verified Answer

    +1  

    Composer is giving you clues with the red underlines. Those are showing the parts that it does not like.

    I believe the path (starting with the "return") should be more like:

    \return\item\extendedData\data[1]\value

    You are missing "item", extendedData should not have square brackets, and "value" should not have square brackets. Instead, the square brackets go on the data element.

    See if that helps.

Children
  • 0 in reply to   

    Thank you Vickie,

    Just like your advice. I added item to the string. like:

    This is deployed without issues. I realized extendeField need be used like: \extendedField[id\dbName="LEAVE_REQUESTS"]\value[1]\...

    What is the different between extendedData\data[1] and extendedField[...]\value[1]

    Thank you