{"id":81701,"date":"2019-11-06T17:56:51","date_gmt":"2019-11-06T08:56:51","guid":{"rendered":"https:\/\/support.questetra.com\/?p=81701"},"modified":"2022-06-01T15:22:51","modified_gmt":"2022-06-01T06:22:51","slug":"questetra-bpms-process-concat-all-strings","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-concat-all-strings\/","title":{"rendered":"Questetra BPMS: Process, Concat All Strings"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5dab2;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#FFF4CC;border-color:#ffffff;color:#333333;border-radius:3px;-moz-border-radius:3px;-webkit-border-radius:3px;\">\n<h3><i class=\"fal fa-exclamation-circle\"><\/i> PAGE UPDATED<\/h3>\n<div style=\"text-align: center;\"><i class=\"fal fa-truck fa-lg\"><\/i> <a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-concat-all-strings-2021\/_\">https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-concat-all-strings-2021\/<\/a><\/div>\n<\/div><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"68\" data-attachment-id=\"89186\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/professional-banner-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1200%2C68&amp;ssl=1\" data-orig-size=\"1200,68\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"professional-banner-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?fit=1024%2C58&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1200%2C68&#038;ssl=1\" alt=\"\" class=\"wp-image-89186\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=600%2C34&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=1024%2C58&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/professional-banner-en.png?resize=768%2C44&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n<div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">Questetra BPMS: Process, Concat All Strings<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\">\n\n\n\n<p class=\"wp-block-paragraph\">Concatenates all string type data. Searches and joins string data and title strings stored as workflow data of Questetra BPM Suite. A line break is added between each data. It is used for checking the existence of keywords.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2019-11-05 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-concat-all-strings\/\">https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-concat-all-strings\/<\/a><\/p>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<ul class=\"fa-ul\">\n<li>A: Select OAuth2 Config Name (at [OAuth 2.0 Setting])<span style=\"color:#990000;\"> *<\/span><\/li>\n<li> B: Set WF Platform URL (${var[applicationRoot]} or <a href=\"https:\/\/\">https:\/\/<\/a>..\/)<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> C: Set Process ID ( e.g., &#8220;123&#8221; )<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> D: Select STRING DATA for Concatenated String (update)<\/li>\n<li> E: Select STRING DATA for Concatenated String (new lines added)<\/li>\n<\/ul>\n\n\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/ 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&amp;Secret: System Settings &gt; API Clients &gt; OAuth2 Clients &gt; Add OAuthw Client\n\/\/ (config \"Redirect URL\" = \"https:\/\/s.questetra.net\/oauth2callback\" )\n\/\/ (Scope: \"read\" or \"any\" )\n\/\/ Set ID&amp;Secret: Workflow App &gt; Detail &gt; OAuth2 Setting &gt; (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 oauth2          = configs.get( \"conf_OAuth2\"  )   + \"\";  \/\/ required\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\/\/ obtain Access Token\nconst token  = httpClient.getOAuth2Token( oauth2 );\n\n\/\/ get ProcessInstance via Questetra Workflow API\n\/\/ com.questetra.bpms.core.event.scripttask.HttpClientWrapper\nlet apiRequest = httpClient.begin(); \/\/ HttpRequestWrapper\n    apiRequest = apiRequest.bearer( token );\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&#091;key].dataType );\n    if( responseObj.processInstance.data&#091;key].dataType === \"STRING\" ){\n      if( responseObj.processInstance.data&#091;key].value == null ){\n        engine.log( \" AutomatedTask Json: null string\" );\n      }else{\n        concatenatedText += responseObj.processInstance.data&#091;key].value + \"\\n\";\n      }\n    }\n  }\n}\nconcatenatedText = concatenatedText.replace(\/&#091;\\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()\" \/\/\/\/\/\/\/\/<\/code><\/pre>\n\n\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" src=\"data:image;base64,iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAEa0lEQVRYR8WXf0iVZxTHP6+av\/PH\nXM6Vm0uzlUKUmk0nMsVoIRbsj1Cb0NwfXsU\/NhhIBCb9UVojFfpxRbZhygYFIqHMxcRFCC3N3FwK\nKrqJbmazi+ltatN3PK97r\/e+9329d1vD888LzznPOd\/nPOd8z\/NKbLBIbsevwx+Z95DIQGYfEm8A\noX\/vtyDzMxIPkOlEopkinrnj2zWAL4hgiTLABPi64xRYAMx4U8UHTK23Z30AZkxIfAoEuBlYa2ZF\n5hNMmI32GwOo4wpQ\/C8Da7ddpYgSPV\/6AMx8iUTeCwq+6kbmK0zka306A3Dj5Pu37GdXyC7F17K8\nTN9MHwOWAXfwOmXCEcDqnV\/V8xQZEMm55HNkv55NiE8IEmtbZWQePXvEjdEbnP\/hPBPWCWMwMsX2\nNbHmZbXaR\/QKrjiumPKEciL8I1yecvTpKKfvn6ZpuMnI1oo3O9TuWANQRzXwkXbX5k2bqU+vZ3fo\nbkU1\/cc0UYFRxAbHGoKZWZih9qdaavprmHs+p2dXQxEfC8UqAEEyMKPX5w3vNHA89jiekqdiOmmd\nZHF5keigaEMAIuigZZDux92UdpXq2QmeCBNktQrAzPtINGotS+JKqDpQReCmQJtKABifH2dmcQbL\nogVRGwkvJxDsHWyzEQCGZ4cJ8w0j99tc7k7fdQYhU4CJJjUDnwGFWqvWd1uVorMXUWD5Hfncmbpj\nW44LjePS25dI2pKkrM0\/n1cytSdsD1V9VZT3lOtl4XOK+FDNQC8S++ytMrdmci3jGtsCttmWF5YX\nuPjjRU51n9JNv6iVY9HHkCQJbw9vfDx9uPnLTY5+c1QvAw8wkaBm4IndYFGMC98spDa11iH9Dy0P\nSWlJMSosSuNLqTxQSYDXGnP3\/t5LYnOiHmALRbykApC1FmeSzlC2t0w5iSodkx1ktWUZFl9BbAGX\n0y4jOkcVQVDxN+L19xQhvVAAJ\/eepDyxHF\/PtaHZ+Wsnma2ZLgG4dQUjT0fI\/jqbodkhJ4fi1C2H\nWhC1Yy8NQw2c+O6Eiysw41SEgu+vZ11XWkk4EW3mIXkwuzRL41CjU2tVJFYoV2Z\/etENZd+XcWVA\nDFaNyDgUoWEbpr+arvS06HVVBBs2jzXTPtGOl+RFWkQaMUEx5ETlOETpf9KvBDcP6D4HHNpQl4hy\nY3I5m3xWIRx7ANrDLK0s0fO4h9RXUm0q659WZU0QVV5HnsKKDqIhIkMqrkyuJGNrBsnhyYbVLwB0\nTXXZiGhFXuHe9D1lz+3fbuvxgIaKhWuDYSRUh187THVKNTtDdjqMYRWRCDg2N4Y4tRAPPNgetF35\nVtyvUEa0RjTDSGjXGcdCLVJ54a0LHIk6gr+XSJiziBlwa+KWcvr8Hfn4efmR056j7RqDcSz8rfMg\nUcMJIML5wciDhPuFK8tiOIl+rx+st7GkaEtRwG3jbdq7N3iQqGZuPMkMi8G1wsWTTHWwoY\/S\/ycT\n\/\/BZvpaJDfwxUUFs6K+ZfVFt2M+p68r+TxZ\/AT9GsTBfXnf\/AAAAAElFTkSuQmCC\" alt=\"\"\/><\/figure><\/div>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/a\/questetra.com\/file\/d\/1usqa7CsWWjLJ-9SL9lEUfz_ec96ppTyF\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Questetra-BPMS-Process-Concat-All-Strings.xml (opens in a new tab)\">Questetra-BPMS-Process-Concat-All-Strings.xml<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/concat-all-strings.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:10px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-capture-en.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"81707\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-concat-all-strings\/attachment\/questetra-bpms-process-concat-all-strings-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Questetra-BPMS-Process-Concat-All-Strings-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Concatenates all string type data. Searches and joins string data and title strings stored as workflow data of Questetra BPM Suite. A line break is added between each data. It is used for checking the existence of keywords.\" class=\"wp-image-81707\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-capture-en.png?resize=768%2C432&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>It can also be used for data items for full text search<\/li><li>It supports loop processing<\/li><li>It does not support Discussion type or Table type<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-wordpress wp-block-embed-wordpress is-provider-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"IUpkLuGoLA\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-list-all-file-urls\/\">Questetra BPMS: Process, List All File URLs<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cQuestetra BPMS: Process, List All File URLs\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-list-all-file-urls\/embed\/#?secret=9k4eO2TOpD#?secret=IUpkLuGoLA\" data-secret=\"IUpkLuGoLA\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Concatenates all string type data. Searches and joins string data and title strings stored as workflow data of Questetra BPM Suite. A line break is added between each data. It is used for checking the existence of keywords.<\/p>\n","protected":false},"author":2,"featured_media":81704,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[],"faq_section":[],"class_list":["post-81701","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":0,"uagb_excerpt":"Concatenates all string type data. Searches and joins string data and title strings stored as workflow data of Questetra BPM Suite. A line break is added between each data. It is used for checking the existence of keywords.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-lfL","jetpack-related-posts":[{"id":109079,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-concat-all-strings-2021\/","url_meta":{"origin":81701,"position":0},"title":"Questetra BPMS #Process: Concat All Strings","author":"IMAMURA, Genichi","date":"2021-07-12","format":false,"excerpt":"Concatenates all string type data. Searches and joins string data and title strings stored as workflow data of Questetra BPM Suite. A line break is added between each data. It is used for checking the existence of keywords","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":81712,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-concat-all-strings\/","url_meta":{"origin":81701,"position":1},"title":"Questetra BPMS: \u6848\u4ef6, \u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u5168\u9023\u7d50","author":"IMAMURA, Genichi","date":"2019-11-06","format":false,"excerpt":"\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u3092\u3059\u3079\u3066\u9023\u7d50\u3057\u307e\u3059\u3002Questetra BPM Suite \u306e\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3068\u3057\u3066\u683c\u7d0d\u3055\u308c\u3066\u3044\u308b\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u304a\u3088\u3073\u30bf\u30a4\u30c8\u30eb\u6587\u5b57\u5217\u3092\u63a2\u7d22\u3057\u7d50\u5408\u3057\u307e\u3059\u3002\u5404\u30c7\u30fc\u30bf\u306e\u9593\u306b\u306f\u6539\u884c\u304c\u52a0\u3048\u3089\u308c\u307e\u3059\u3002\u30ad\u30fc\u30ef\u30fc\u30c9\u306e\u5b58\u5728\u78ba\u8a8d\u306a\u3069\u3067\u5229\u7528\u3057\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82133,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-extract-as-tsv\/","url_meta":{"origin":81701,"position":2},"title":"Questetra BPMS: Process, Extract as TSV","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"Extracts process data as single-line TSV string. Items are specified in CSV format such as \"0,2,3\". Tab code and line feed code are automatically deleted. Discussion type, Table type, Guide-Panel type cannot be extracted (Warning Log).","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Questetra BPMS: Process, Extract as TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":88954,"url":"https:\/\/support.questetra.com\/en\/addons\/master-table-list-all-options-as-tsv-string\/","url_meta":{"origin":81701,"position":3},"title":"Master Table, List All Options as TSV String","author":"IMAMURA, Genichi","date":"2021-02-17","format":false,"excerpt":"Includes the master table on Workflow Platform as a string property of the process. The IDs and Labels are concatenated into TSV (Tab-Separated Values) and stored into Multiline-String type.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Master Table: List All Options as TSV String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-List-All-Options-as-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-List-All-Options-as-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-List-All-Options-as-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-List-All-Options-as-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/06\/Master-Table-List-All-Options-as-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":81650,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-list-all-file-urls\/","url_meta":{"origin":81701,"position":4},"title":"Questetra BPMS: Process, List All File URLs","author":"IMAMURA, Genichi","date":"2019-11-06","format":false,"excerpt":"Lists the download URLs for the files stored as workflow data of Questetra BPM Suite. If two files are attached, output two lines of text. This is useful for browser extensions and email text attachment.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-List-All-File-URLs-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-List-All-File-URLs-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-List-All-File-URLs-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-List-All-File-URLs-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-List-All-File-URLs-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84887,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-table-to-tsv-string\/","url_meta":{"origin":81701,"position":5},"title":"Converter: Table to TSV-String","author":"IMAMURA, Genichi","date":"2020-03-02","format":false,"excerpt":"Converts Table-type data to TSV String. The string value of all cells in the Table-type data is copied over TSV string B. Cells with no input are regarded as empty strings.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter: Table to TSV-String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/03\/Converter-Table-to-TSV-String-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Concat-All-Strings-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/81701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=81701"}],"version-history":[{"count":6,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/81701\/revisions"}],"predecessor-version":[{"id":109262,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/81701\/revisions\/109262"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/81704"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=81701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=81701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=81701"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=81701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}