Hi team,
I am trying to return a hardcoded json value from an expression rule but I am not able to do so. I have tried even with escape sequences i.e, /" but still I am not getting the proper output. Could u pls help ?
original JSON:
{ "uuid" : "6722c859-76b4-4aa8-ac82-3b3f93d903ba", "name" : "ContainerisedApp", "description" : "", "jiraId" : "REP-4783", "mappedCases" : [ { "caseUuid" : "8fcfc7a7-d989-4592-b321-d456460c7f0d", "casePath" : "ContainerisedApp", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 1, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "ValidateAppRej" } }, { "caseUuid" : "2e010c2e-6b4e-42c5-bea7-5cfe03f242e6", "casePath" : "ContainerisedApp", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 2, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "ValidateAppRej_GE" } }, { "caseUuid" : "0c604570-a5cb-4af1-afc4-65b6a65a951c", "casePath" : "ContainerisedApp", "runMode" : true, "reportable" : true, "caseExecutionSequence" : 3, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "ValidateSearchUI_658" } }, { "caseUuid" : "3d2a6d90-99d7-4b29-a76b-540a62e4a18e", "casePath" : "ContainerisedApp", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 4, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "ValidateAmountError" } }, { "caseUuid" : "1e9d2603-7dcd-459e-93cf-cdc43a6a5480", "casePath" : "saveBtnValidate_367", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 5, "datasheetType" : "NoDatasheet", "dataStore" : { "type" : "" } }, { "caseUuid" : "a25092c2-d22e-48e0-a2e2-1c8ce5da98b6", "casePath" : "ContainerisedApp", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 6, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "ValidateDDOptions_1147" } }, { "caseUuid" : "5d4151e8-6c3c-49d7-a17f-7b5945d86dba", "casePath" : "ContainerisedApp", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 7, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "ValidateErrorMsg" } }, { "caseUuid" : "c8a2bdba-4215-46c5-b21b-af516ce9ed25", "casePath" : "ContainerisedApp", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 8, "datasheetType" : "NoDatasheet", "dataStore" : { "type" : "" } }, { "caseUuid" : "ace5e793-7df1-457b-b765-506229d34f40", "casePath" : "ContainerisedApp", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 9, "datasheetType" : "NoDatasheet", "dataStore" : { "type" : "" } }, { "caseUuid" : "31e62811-d849-4bb6-8492-cf19b8b4de1e", "casePath" : "validateREPInfraPermissions", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 10, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "validateREPInfraPermissions" } }, { "caseUuid" : "61169fbb-8181-42e5-8d45-052b58fc7c6c", "casePath" : "ValidateAmountHighlighted", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 11, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "ValidateAmountHighlighted" } }, { "caseUuid" : "b4b3c482-6e97-4330-b576-53d21b21f62a", "casePath" : "AmountFunctionality_1148", "runMode" : false, "reportable" : true, "caseExecutionSequence" : 12, "datasheetType" : "Default", "dataStore" : { "type" : "Excel", "path" : "ScriptsContainerisedApp.xlsx", "sheetName" : "AmountFunctionality_1148" } } ], "userI" : "abc@bc.cc" }
JSON with escape sequences:
{ /"uuid/" : /"6722c859-76b4-4aa8-ac82-3b3f93d903ba/", /"name/" : /"ContainerisedApp/", /"description/" : /"/", /"jiraId/" : /"REP-4783/", /"mappedCases/" : [ { /"caseUuid/" : /"8fcfc7a7-d989-4592-b321-d456460c7f0d/", /"casePath/" : /"\\\\ContainerisedApp/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 1, /"datasheetType/" : /"Default/", /"dataStore/" : { /"type/" : /"Excel/", /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/", /"sheetName/" : /"ValidateAppRej/" } }, { /"caseUuid/" : /"2e010c2e-6b4e-42c5-bea7-5cfe03f242e6/", /"casePath/" : /"\\\\ContainerisedApp/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 2, /"datasheetType/" : /"Default/", /"dataStore/" : { /"type/" : /"Excel/", /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/", /"sheetName/" : /"ValidateAppRej_GE/" } }, { /"caseUuid/" : /"0c604570-a5cb-4af1-afc4-65b6a65a951c/", /"casePath/" : /"\\\\ContainerisedApp/", /"runMode/" : true, /"reportable/" : true, /"caseExecutionSequence/" : 3, /"datasheetType/" : /"Default/", /"dataStore/" : { /"type/" : /"Excel/", /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/", /"sheetName/" : /"ValidateSearchUI_658/" } }, { /"caseUuid/" : /"3d2a6d90-99d7-4b29-a76b-540a62e4a18e/", /"casePath/" : /"\\\\ContainerisedApp/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 4, /"datasheetType/" : /"Default/", /"dataStore/" : { /"type/" : /"Excel/", /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/", /"sheetName/" : /"ValidateAmountError/" } }, { /"caseUuid/" : /"1e9d2603-7dcd-459e-93cf-cdc43a6a5480/", /"casePath/" : /"\\\\saveBtnValidate_367/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 5, /"datasheetType/" : /"NoDatasheet/", /"dataStore/" : { /"type/" : /"/" } }, { /"caseUuid/" : /"a25092c2-d22e-48e0-a2e2-1c8ce5da98b6/", /"casePath/" : /"\\\\ContainerisedApp/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 6, /"datasheetType/" : /"Default/", /"dataStore/" : { /"type/" : /"Excel/", /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/", /"sheetName/" : /"ValidateDDOptions_1147/" } }, { /"caseUuid/" : /"5d4151e8-6c3c-49d7-a17f-7b5945d86dba/", /"casePath/" : /"\\\\ContainerisedApp/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 7, /"datasheetType/" : /"Default/", /"dataStore/" : { /"type/" : /"Excel/", /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/", /"sheetName/" : /"ValidateErrorMsg/" } }, { /"caseUuid/" : /"c8a2bdba-4215-46c5-b21b-af516ce9ed25/", /"casePath/" : /"\\\\ContainerisedApp/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 8, /"datasheetType/" : /"NoDatasheet/", /"dataStore/" : { /"type/" : /"/" } }, { /"caseUuid/" : /"ace5e793-7df1-457b-b765-506229d34f40/", /"casePath/" : /"\\\\ContainerisedApp/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 9, /"datasheetType/" : /"NoDatasheet/", /"dataStore/" : { /"type/" : /"/" } }, { /"caseUuid/" : /"31e62811-d849-4bb6-8492-cf19b8b4de1e/", /"casePath/" : /"\\\\validateREPInfraPermissions/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 10, /"datasheetType/" : /"Default/", /"dataStore/" : { /"type/" : /"Excel/", /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/", /"sheetName/" : /"validateREPInfraPermissions/" } }, { /"caseUuid/" : /"61169fbb-8181-42e5-8d45-052b58fc7c6c/", /"casePath/" : /"\\\\ValidateAmountHighlighted/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 11, /"datasheetType/" : /"Default/", /"dataStore/" : { /"type/" : /"Excel/", /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/", /"sheetName/" : /"ValidateAmountHighlighted/" } }, { /"caseUuid/" : /"b4b3c482-6e97-4330-b576-53d21b21f62a/", /"casePath/" : /"\\\\AmountFunctionality_1148/", /"runMode/" : false, /"reportable/" : true, /"caseExecutionSequence/" : 12, /"datasheetType/" : /"Default/", /"dataStore/" : { /"type/" : /"Excel/", /"path/" : /"\\\\Scripts\\\\ContainerisedApp.xlsx/", /"sheetName/" : /"AmountFunctionality_1148/" } } ], /"userI/" : /"abc@bc.cc/" }
Discussion posts and replies are publicly visible
a!toJson( { uuid : "6722c859-76b4-4aa8-ac82-3b3f93d903ba", name : "ContainerisedApp", description : "", jiraId : "REP-4783", mappedCases : { { caseUuid : "61169fbb-8181-42e5-8d45-052b58fc7c6c", casePath : "ValidateAmountHighlighted", runMode : false, reportable : true, caseExecutionSequence : 11, datasheetType : "Default", dataStore : { type : "Excel", path : "ScriptsContainerisedApp.xlsx", sheetName : "ValidateAmountHighlighted" } }, { caseUuid : "b4b3c482-6e97-4330-b576-53d21b21f62a", casePath : "AmountFunctionality_1148", runMode : false, reportable : true, caseExecutionSequence : 12, datasheetType : "Default", dataStore : { type: "Excel", path : "ScriptsContainerisedApp.xlsx", sheetName : "AmountFunctionality_1148" } } }, userI : "abc@bc.cc" } )
Thanks Deepak. It worked for me.
YW