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
Cybersecurity
DevOps Cloud
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more
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
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.
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.
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