Questetra BPMS: Process, Concat All Strings<\/div>
Concatenates all String-type data. Searches and joins string data and title strings stored as workflow data in Questetra BPM Suite. A line break is added between each data which is used for checking the existence of keywords.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> A: Select HTTP_Authz Setting *<\/span><\/li>\n
- <\/i><\/span> B: Set WF Platform URL (${var[applicationRoot]} or https: \/\/..\/) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> C: Set Process ID ( e.g., “123” ) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> D: Select STRING DATA for Concatenated String (update)<\/li>\n
- <\/i><\/span> E: Select STRING DATA for Concatenated String (new lines added)<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\n\/\/ about Questetra Workflow API\n\/\/ See https:\/\/online-demo-ja.questetra.net\/s\/swagger\/index.html?urls.primaryName=Workflow%20API\n\/\/ or "https:\/\/{YOUR}.questetra.net\/s\/swagger\/index.html"\n\n\/\/ about Questetra OAuth2 (for System Admin)\n\/\/ Get ID&Secret: System Settings > API Clients > OAuth2 Clients > Add OAuthw Client\n\/\/ (config "Redirect URL" = "https:\/\/s.questetra.net\/oauth2callback" )\n\/\/ (Scope: "read" or "any" )\n\/\/ Set ID&Secret: Workflow App > Detail > OAuth2 Setting > (Get Refresh Token)\n\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strAuthzSetting = configs.get( "AuthzConfA" ); \/\/ required\n engine.log( " AutomatedTask Config: Authz Setting: " + strAuthzSetting );\nconst applicationRoot = configs.get( "conf_ApplicationRoot" ) + ""; \/\/ required\nconst processId = configs.get( "conf_ProcessId" ) + ""; \/\/ required\nconst dataIdD = configs.get( "conf_DataIdD" ) + ""; \/\/ not required\nconst dataIdE = configs.get( "conf_DataIdE" ) + ""; \/\/ not required\n\/\/ 'java.lang.String' (String Obj) to javascript primitive 'string'\n\nengine.log( " AutomatedTask Config: Application Root: " + applicationRoot );\nengine.log( " AutomatedTask Config: Process ID: " + processId );\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet concatenatedTextSource = engine.findDataByNumber( dataIdE );\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/ get ProcessInstance via Questetra Workflow API\n\/\/ com.questetra.bpms.core.event.scripttask.HttpClientWrapper\nlet apiRequest = httpClient.begin(); \/\/ HttpRequestWrapper\n apiRequest = apiRequest.authSetting( strAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n \/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574471-R2300#HttpRequestWrapper\n apiRequest = apiRequest.queryParam( "processInstanceId", processId );\nconst apiUri = applicationRoot + "API\/OR\/ProcessInstance\/view";\n\n\/\/ request to API\nengine.log( " AutomatedTask Trying: GET " + apiUri );\nconst response = apiRequest.get( apiUri );\nconst responseCode = response.getStatusCode() + "";\nengine.log( " AutomatedTask ApiResponse: Status " + responseCode );\nif( responseCode !== "200"){\n throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n responseCode + "\\n" + response.getResponseAsString() + "\\n" );\n}\nconst responseStr = response.getResponseAsString() + "";\nconst responseObj = JSON.parse( responseStr );\n\/\/engine.log( responseStr );\n\n\/\/ retrieve JSON\nlet concatenatedText = "";\n concatenatedText += responseObj.processInstance.processInstanceTitle + "\\n";\nfor( const key in responseObj.processInstance.data ){\n if( responseObj.processInstance.data.hasOwnProperty(key) ) {\n engine.log( key + ": " + responseObj.processInstance.data[key].dataType );\n if( responseObj.processInstance.data[key].dataType === "STRING" ){\n if( responseObj.processInstance.data[key].value == null ){\n engine.log( " AutomatedTask Json: null string" );\n }else{\n concatenatedText += responseObj.processInstance.data[key].value + "\\n";\n }\n }\n }\n}\nconcatenatedText = concatenatedText.replace(\/[\\n]*$\/, "");\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( concatenatedText === "" ){\n engine.log( " AutomatedTask DataUpdating: Concatenated Text empty" );\n}\nif( dataIdD !== "" ){ \n engine.setDataByNumber( dataIdD, concatenatedText );\n}\nif( dataIdE !== "" ){ \n if( concatenatedTextSource !== null ){\n engine.setDataByNumber( dataIdE, concatenatedTextSource + "\\n" + concatenatedText );\n }else{\n engine.setDataByNumber( dataIdE, concatenatedText );\n }\n}\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- Questetra-BPMS-Process-Concat-All-Strings.xml<\/a><\/li>\n\n\n\n
- Questetra-BPMS-Process-Concat-All-Strings-2023.xml<\/a>\n
- \n
- 2023-08-21 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
2021-07-05 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/questetra-bpms-process-concat-all-strings-2021\/<\/a>
<\/i> The Add-on import feature is available with Professional<\/strong><\/span> edition.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- It can also be used as a Data Item for full text search<\/li>\n\n\n\n
- It supports loop processing<\/li>\n\n\n\n
- It does not support Discussion type or Table type data<\/li>\n<\/ol>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/07\/concat-all-strings.png?ssl=1\")
<\/figure>\n\n\n\n![\"Concatenates](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-capture-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> See also<\/h3>\n\n\n\n
- Questetra-BPMS-Process-Concat-All-Strings-2023.xml<\/a>\n
- <\/i><\/span> B: Set WF Platform URL (${var[applicationRoot]} or https: \/\/..\/) *<\/span>#{EL}<\/sup><\/span><\/li>\n