Record is not being created in Decision table with concatenated query

santoshsuta — Mon, 10 Mar 2025 12:29:42 GMT

I am creating a record in Decision Table using catalog item.
I cannot use Record producer on this sys_decision_question table due to the security constrains. So, I am using catalog item and creating a record using the flow script.
Somehow the script is working with the hardcoded values (Please refer below script action)

-------------------Script Starts from here----------------------------

(function execute(inputs, outputs) {

try {

gs.info("Santosh inside");

var state = inputs.state;

gs.info("Santosh state: " + state);

var board = inputs.board;

gs.info("Santosh Board: " + board);

var decisionTable = inputs.decisionTable;

gs.info("Santosh decisionTable: " + decisionTable);

var taskType = (inputs.taskType || "").trim().toLowerCase();

gs.info("Santosh taskType: " + taskType);

var lane = inputs.lane;

gs.info("Santosh lane: " + lane);

var finalTasktype = "";

var finalCondition = "";

if (taskType === "private task") {

finalTasktype = "vtb_task";

finalCondition = 'u_rm_story_state=3^u_vtb_kanban_board=02b2d2e6db6fd01041899b3c8a96194e^EQ';

}

else if (taskType === "incident") {

gs.info("Santosh taskType matched 'incident'");

finalTasktype = "incident";

finalCondition = 'u_incident_state=' + state + '^u_vtb_kanban_board=02b2d2e6db6fd01041899b3c8a96194e^EQ';

}

else {

gs.warn("Santosh Warning: taskType '" + taskType + "' does not match any condition.");

}

if (!finalCondition) {

gs.warn("Santosh Warning: finalCondition is empty for taskType '" + taskType + "'");

}

if (!decisionTable) {

gs.error("Santosh Error: decisionTable sys_id is empty or null!");

return;

}

gs.info("Santosh finalCondition: " + finalCondition);

var questions = [

{

condition: "u_incident_state=6^u_vtb_kanban_board=02b2d2e6db6fd01041899b3c8a96194e^EQ",

answer: [

{ value: lane }

active: true,

defaultAnswer: false,

}

];

gs.info("Santosh DEBUG: Questions array prepared - " + JSON.stringify(questions));

var dt = new sn_dt.DecisionTableAPI();

var response = dt.createQuestions(decisionTable, questions);

gs.info("Santosh DEBUG: DecisionTableAPI Response - " + JSON.stringify(response));

if (response && response.results && response.results.length > 0 && response.results[0].record) {

gs.info('Santosh Status: ' + response.status);

gs.info('Santosh First decision sys_id: ' + response.results[0].record.getValue('sys_id'));

} else {

gs.warn('Santosh No valid results found in the API response.');

}

} catch (error) {

gs.error("Santosh Exception occurred: " + error);

}

})(inputs, outputs);

-----------------------The script ends here-------------------------------------

The record is being created with the correct Filter conditions and correct Answer value.

BUT
When I replace the condition hardcoded value with the below mentioned concatenated query. It doesn't works.
for example:
finalCondition = 'u_incident_state=' + state + '^u_vtb_kanban_board=02b2d2e6db6fd01041899b3c8a96194e^EQ';

var questions = [

{

condition: finalCondition ,

answer: [

{ value: lane }

active: true,

defaultAnswer: false,

}

];

I am getting correct logs mentioned below.

Santosh finalCondition: u_incident_state=6^u_vtb_kanban_board=02b2d2e6db6fd01041899b3c8a96194e^EQ

Santosh DEBUG: Questions array prepared - [{"condition":"u_incident_state=6^u_vtb_kanban_board=02b2d2e6db6fd01041899b3c8a96194e^EQ","answer":[{"value":"43a6ae521b0c661092b275de034bcb32"}],"active":true,"defaultAnswer":false}]

This is an additional log says that it's failed to created a record in decision table.
Santosh DEBUG: DecisionTableAPI Response - {"results":[{"errors":[{"message":"Type mismatch occurred in the field condition when expecting value of type String","type":"INVALID_REQUEST"}],"status":"Failure"}],"errors":[{"message":"1 requests failed","type":"INVALID_REQUEST"}],"status":"Failure"}

Please let me know if anyone have any idea on this.

Re: Record is not being created in Decision table with concatenated query

RajC59005800307 — Mon, 10 Mar 2025 12:47:47 GMT

Hi @santoshsuta

The issue likely arises because the condition field is not being interpreted correctly when dynamically assigned. Here’s what you can try:

- Since hardcoded values work, check if dynamically assigned values have any unintended spaces or special characters.

- You can explicitly trim the state variable before concatenation:

finalCondition = 'u_incident_state=' + state.trim() + '^u_vtb_kanban_board=02b2d2e6db6fd01041899b3c8a96194e^EQ';

- Print finalCondition before using it in the questions array to ensure it is correctly formatted:

gs.info("Santosh DEBUG: finalCondition string - " + JSON.stringify(finalCondition));

- If the API expects an escaped condition string, try encoding special characters:

finalCondition = encodeURIComponent('u_incident_state=' + state + '^u_vtb_kanban_board=02b2d2e6db6fd01041899b3c8a96194e^EQ');

- Sometimes, JavaScript treats variables differently when assigned dynamically. You can try:

var conditionString = String(finalCondition); questions = [{ condition: conditionString, answer: [{ value: lane }], active: true, defaultAnswer: false }];

If none of these work, test by hardcoding finalCondition inside questions instead of assigning it dynamically to see if the issue is with data type handling.

Re: Record is not being created in Decision table with concatenated query

santoshsuta — Mon, 10 Mar 2025 12:56:15 GMT

Thank you so much Raj, That worked. 🙂

Re: Record is not being created in Decision table with concatenated query

RajC59005800307 — Mon, 10 Mar 2025 12:57:56 GMT

@santoshsuta If my response helped you in any way consider making it as helpful
thank you !

Re: Record is not being created in Decision table with concatenated query

santoshsuta — Mon, 10 Mar 2025 12:59:17 GMT

Already accepted a solution and marked as accepted.

question Re: Record is not being created in Decision table with concatenated query in Community Central forum

Record is not being created in Decision table with concatenated query

Re: Record is not being created in Decision table with concatenated query

Re: Record is not being created in Decision table with concatenated query

Re: Record is not being created in Decision table with concatenated query

Re: Record is not being created in Decision table with concatenated query