{"id":82149,"date":"2019-11-21T12:22:43","date_gmt":"2019-11-21T03:22:43","guid":{"rendered":"https:\/\/support.questetra.com\/?p=82149"},"modified":"2022-06-01T15:22:24","modified_gmt":"2022-06-01T06:22:24","slug":"questetra-bpms-process-batch-extract-as-tsv","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","title":{"rendered":"Questetra BPMS: Process, Batch Extract as TSV"},"content":{"rendered":"<div class=\"su-note\"  style=\"border-color:#e5e54c;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:#FFFF66;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-batch-extract-as-tsv-2021\/_\">https:\/\/support.questetra.com\/addons\/questetra-bpms-process-batch-extract-as-tsv-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-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">Questetra BPMS: Process, Batch Extract as TSV<\/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\">Extracts process data as a multi-line TSV string from date-filtered processes. Items are specified in CSV format such as &#8220;string:0,date:2,select:3&#8221;. Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported.<\/p>\n\n\n<\/div><\/div>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\">2019-11-20 (C) Questetra, Inc. (MIT License)<br>\n<a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv\/\">https:\/\/support.questetra.com\/addons\/questetra-bpms-process-batch-extract-as-tsv\/<\/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><span class=\"fa-li\"><i class=\"fal fa-badge-check fa-lg\"><\/i><\/span> A: Select OAuth2 Config Name (at [OAuth 2.0 Setting])<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-pen-square fa-lg\"><\/i><\/span> 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><span class=\"fa-li\"><i class=\"fal fa-pen-square fa-lg\"><\/i><\/span> C: Set Workflow-App 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><span class=\"fa-li\"><i class=\"fal fa-pen-square fa-lg\"><\/i><\/span> C-target: Set Date-Type DataItem ID ( e.g., &#8220;5&#8221; )<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-pen-square fa-lg\"><\/i><\/span> C-from: Set Filter Range FROM ( e.g., &#8220;2019-12-01&#8221; )<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-pen-square fa-lg\"><\/i><\/span> C-to: Set Filter Range TO ( e.g., &#8220;2019-12-31&#8221; )<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-pen-square fa-lg\"><\/i><\/span> C-sort: Set DESC or ASC ( default &#8220;DESC&#8221; )<span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-pen-square fa-lg\"><\/i><\/span> D: Set DataItem IDs to Extract ( eg &#8220;string:0,date:2,select:3&#8221; )<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"> <sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> E: Select STRING DATA for Extracted TSV (update)<\/li>\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> F: Select STRING DATA for Extracted TSV (append)<\/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\/\/ Notes:\n\/\/ Weekly and monthly reporting works can be automated with \"Timer Start Event\".\n\/\/ Tab code and line feed code in Workflow data will be deleted.\n\/\/ Extraction data is specified by \"{type}:{itemid}\" in CSV notation (eg \"string:0,date:2,select:3\")\n\/\/ Data Type Notations: string decimal date datetime select file quser qgroup\n\/\/ Specify \"Title\" to extract Title and \"Id\" to extract ID. ( e.g. \"Title,Id,string:0,date:2,select:3\" )\n\/\/ If an undefined dataitem ID or Guide Panel ID is specified, \"#N\/A\" is output.\n\/\/ If an unsupported type is specified, \"#TYPE!\" is output.\n\/\/ The file names are extracted for the File type. (Multiple: Space-separated)\n\/\/ The display strings of the selected options are extracted for the Select type. (Multiple: Space-separated)\n\/\/ If \"C-target: Date-Type DataItem\" is not specified, \"processInstanceStartDatetime\" will be the Filter target instead.\n\/\/ Notes (ja):\n\/\/ \"\u30bf\u30a4\u30de\u30fc\u958b\u59cb\u30a4\u30d9\u30f3\u30c8\" \u3068\u4f75\u7528\u3059\u308c\u3070\u3001\u9031\u6b21\u3084\u6708\u6b21\u306e\u96c6\u8a08\u696d\u52d9\u30fb\u30ec\u30dd\u30fc\u30c8\u696d\u52d9\u3092\u81ea\u52d5\u5316\u3067\u304d\u307e\u3059\n\/\/ Workflow\u30c7\u30fc\u30bf\u5185\u306e\u30bf\u30d6\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u62bd\u51fa\u6642\u306b\u524a\u9664\u3055\u308c\u307e\u3059\n\/\/ \u62bd\u51fa\u30c7\u30fc\u30bf\u306e\u6307\u5b9a\u306f \"{type}:{itemid}\" \u3092CSV\u8868\u8a18\u3067\u884c\u3044\u307e\u3059 ( \u4f8b \"string:0,date:2,select:3\" )\n\/\/ \u30c7\u30fc\u30bf\u578b\u306e\u8868\u8a18\u65b9\u6cd5\uff1a string decimal date datetime select file quser qgroup\n\/\/ \u6848\u4ef6\u30bf\u30a4\u30c8\u30eb\u306e\u62bd\u51fa\u306b\u306f \"Title\" \u3092\u3001ID\u306e\u62bd\u51fa\u306b\u306f \"Id\" \u3092\u6307\u5b9a\u3057\u307e\u3059 ( \u4f8b \"Title,Id,string:0,date:2,select:3\" )\n\/\/ \u672a\u5b9a\u7fa9\u306e\u30c7\u30fc\u30bf\u9805\u76eeID\u3084\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u306eID\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f\u3001\"#N\/A\" \u304c\u51fa\u529b\u3055\u308c\u307e\u3059\n\/\/ \u30b5\u30dd\u30fc\u30c8\u5916\u306e\u30c7\u30fc\u30bf\u578b\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u306f\u3001\"#TYPE!\" \u304c\u51fa\u529b\u3055\u308c\u307e\u3059\n\/\/ \u30d5\u30a1\u30a4\u30eb\u578b\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08\u8907\u6570\uff1a\u30b9\u30da\u30fc\u30b9\u533a\u5207\u308a\uff09\n\/\/ \u9078\u629e\u578b\u3092\u6307\u5b9a\u3057\u305f\u5834\u5408\u3001\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08\u8907\u6570\uff1a\u30b9\u30da\u30fc\u30b9\u533a\u5207\u308a\uff09\n\/\/ \"C-target: \u65e5\u4ed8\u578b\u30c7\u30fc\u30bf\u9805\u76ee\" \u304c\u672a\u6307\u5b9a\u306e\u5834\u5408\u3001\"\u30d7\u30ed\u30bb\u30b9\u958b\u59cb\u65e5\u6642\" \u304cFilter\u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u306a\u308a\u307e\u3059\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 processModelId  = configs.get( \"conf_ProcessModelId\" ) + \"\";  \/\/ required\nconst targetDateId    = configs.get( \"conf_TargetDateId\" ) + \"\";    \/\/ not required\nconst targetFrom      = configs.get( \"conf_TargetFrom\" ) + \"\";      \/\/ not required\nconst targetTo        = configs.get( \"conf_TargetTo\" ) + \"\";        \/\/ not required\nconst targetSort      = configs.get( \"conf_TargetSort\" ) + \"\";      \/\/ not required\nconst dataitemIds     = configs.get( \"conf_DataitemIds\" ) + \"\";     \/\/ required\nconst dataIdE         = configs.get( \"conf_DataIdE\" )   + \"\";       \/\/ not required\nconst dataIdF         = configs.get( \"conf_DataIdF\" )   + \"\";       \/\/ not required\n\/\/ 'java.lang.String' (String Obj) to javascript primitive 'string'\n\nengine.log( \" AutomatedTask Config: Application Root: \" + applicationRoot );\nengine.log( \" AutomatedTask Config: Workflow App ID: \" + processModelId );\nengine.log( \" AutomatedTask Config: Target Dataitem ID: \" + targetDateId );\nengine.log( \" AutomatedTask Config: Filter Range From: \" + targetFrom );\nengine.log( \" AutomatedTask Config: Filter Range To: \" + targetTo );\nengine.log( \" AutomatedTask Config: Sort Order: \" + targetSort );\nengine.log( \" AutomatedTask Config: Dataitem IDs: \" + dataitemIds );\n\nconst yyyyMMddReg = \/^\\d{4}-\\d{2}-\\d{2}$\/;\nif( targetFrom !== \"\" ){\n  if( ! yyyyMMddReg.test( targetFrom ) ){\n    throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                     \" Config {Target From} is not YYYY-MM-DD \\n\" );\n  }\n}\nif( targetTo !== \"\" ){\n  if( ! yyyyMMddReg.test( targetTo ) ){\n    throw new Error( \"\\n AutomatedTask ConfigError:\" +\n                     \" Config {Target To} is not YYYY-MM-DD \\n\" );\n  }\n}\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet strBeforeAppend = engine.findDataByNumber( dataIdF );\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/ obtain Access Token\nconst token  = httpClient.getOAuth2Token( oauth2 );\n\n\/\/ define Filter Criteria (for Questetra ProcessInstance Search)\nlet criteria = \"&lt;process-instance-criteria&gt;\";\ncriteria    += \"&lt;process-model-info-id&gt;\" + processModelId +\"&lt;\/process-model-info-id&gt;\";\nif( targetDateId === \"\" ){\n  if( targetFrom === \"\" ){\n    criteria  += \"&lt;start-date-from&gt;#today.addDays(-7)&lt;\/start-date-from&gt;\";\n  }else{\n    criteria  += \"&lt;start-date-from&gt;\" + targetFrom + \"&lt;\/start-date-from&gt;\";\n  }\n  if( targetTo === \"\" ){\n    criteria  += \"&lt;start-date-to&gt;#today&lt;\/start-date-to&gt;\";\n  }else{\n    criteria  += \"&lt;start-date-to&gt;\" + targetTo + \"&lt;\/start-date-to&gt;\";\n  }\n}\ncriteria  += \"&lt;data&gt;\";\nif( targetDateId !== \"\" ){\n  criteria  += \"&lt;date&gt;\";\n  criteria  += \"&lt;data-definition-number&gt;\" + targetDateId + \"&lt;\/data-definition-number&gt;\";\n  if( targetFrom === \"\" ){\n    criteria  += \"&lt;after-equals \/&gt;&lt;value&gt;#today.addDays(-7)&lt;\/value&gt;\";\n  }else{\n    criteria  += \"&lt;after-equals \/&gt;&lt;value&gt;\" + targetFrom + \"&lt;\/value&gt;\";\n  }\n  criteria  += \"&lt;\/date&gt;&lt;date&gt;\";\n  criteria  += \"&lt;data-definition-number&gt;\" + targetDateId + \"&lt;\/data-definition-number&gt;\";\n  if( targetTo === \"\" ){\n    criteria  += \"&lt;before-equals \/&gt;&lt;value&gt;#today&lt;\/value&gt;\";\n  }else{\n    criteria  += \"&lt;before-equals \/&gt;&lt;value&gt;\" + targetTo + \"&lt;\/value&gt;\";\n  }\n  criteria  += \"&lt;\/date&gt;\";\n}\nconst arrDataitemIds = dataitemIds.split(\",\"); \/\/ e.g. \"Title,Id,string:0,date:2,select:3\"\nfor( let i = 0; i &lt; arrDataitemIds.length; i++ ){\n  if( arrDataitemIds&#091;i] === \"Title\" ){\n  }else if( arrDataitemIds&#091;i] === \"Id\" ){\n  }else{\n    const arrViewTypeId = arrDataitemIds&#091;i].split(\":\");\n    criteria  += \"&lt;\" + arrViewTypeId&#091;0] + \"&gt;\";  \/\/ e.g. \"&lt;string&gt;\"\n    criteria  += \"&lt;data-definition-number&gt;\" + arrViewTypeId&#091;1] + \"&lt;\/data-definition-number&gt;\";\n    criteria  += \"&lt;view \/&gt;\";\n    criteria  += \"&lt;\/\" + arrViewTypeId&#091;0] + \"&gt;\";  \/\/ e.g. \"&lt;\/string&gt;\"\n  }\n}\ncriteria  += \"&lt;\/data&gt;\";\nif( targetSort === \"ASC\" ){\n  criteria  += \"&lt;sort-direction&gt;ASC&lt;\/sort-direction&gt;\"; \n}\ncriteria    += \"&lt;\/process-instance-criteria&gt;\";\nengine.log( \" AutomatedTask Criteria: \\n\" + criteria );\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( \"limit\", 1000 );\n    apiRequest = apiRequest.queryParam( \"criteria\", criteria );\nconst apiUri = applicationRoot + \"API\/OR\/ProcessInstance\/list\";\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 ); \/\/test\n\n\/\/ retrieve JSON\nengine.log( \" AutomatedTask Parsed: Number of Process Instances: \" + responseObj.count );\nlet strNewline = \"\";\nfor( let h = 0; h &lt; responseObj.processInstances.length; h++ ){\n  for( let i = 0; i &lt; arrDataitemIds.length; i++ ){\n    if( arrDataitemIds&#091;i] === \"Id\" ){\n      strNewline += responseObj.processInstances&#091;h].processInstanceId;\n    }else if( arrDataitemIds&#091;i] === \"Title\" ){\n      if( responseObj.processInstances&#091;h].processInstanceTitle !== null ){\n        strNewline += responseObj.processInstances&#091;h].processInstanceTitle;\n      }\n    }else{\n      const dataId = arrDataitemIds&#091;i].replace( \/(\\w+):(\\w+)\/, '$2' );\n      if( responseObj.processInstances&#091;h].data&#091; dataId ] == undefined ){\n        strNewline += \"#N\/A\";\n      }else if( responseObj.processInstances&#091;h].data&#091; dataId ].dataType === \"STRING\" || \n                responseObj.processInstances&#091;h].data&#091; dataId ].dataType === \"DECIMAL\" || \n                responseObj.processInstances&#091;h].data&#091; dataId ].dataType === \"DATE\" || \n                responseObj.processInstances&#091;h].data&#091; dataId ].dataType === \"DATETIME\" || \n                responseObj.processInstances&#091;h].data&#091; dataId ].dataType === \"QUSER\" || \n                responseObj.processInstances&#091;h].data&#091; dataId ].dataType === \"QGROUP\" ){\n        if( responseObj.processInstances&#091;h].data&#091; dataId ].value !== null ){\n          strNewline += responseObj.processInstances&#091;h].data&#091; dataId ].value\n                        .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n        }\n      }else if( responseObj.processInstances&#091;h].data&#091; dataId ].dataType === \"SELECT\" ){\n        if( responseObj.processInstances&#091;h].data&#091; dataId ].value !== null ){\n          for( let j = 0; j &lt; responseObj.processInstances&#091;h].data&#091; dataId ].value.length; j++ ){\n            strNewline += responseObj.processInstances&#091;h].data&#091; dataId ].value&#091;j].display\n                          .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n            if( j !== responseObj.processInstances&#091;h].data&#091; dataId ].value.length - 1 ){\n              strNewline += \" \"; \/\/ (Multiple: Space-separated)\n            }\n          }\n        }\n      }else if( responseObj.processInstances&#091;h].data&#091; dataId ].dataType === \"FILE2\" ){\n        if( responseObj.processInstances&#091;h].data&#091; dataId ].value !== null ){\n          for( let j = 0; j &lt; responseObj.processInstances&#091;h].data&#091; dataId ].value.length; j++ ){\n            strNewline += responseObj.processInstances&#091;h].data&#091; dataId ].value&#091;j].name\n                          .replace( \/\\n\/g, '' ).replace( \/\\t\/g, '' );\n            if( j !== responseObj.processInstances&#091;h].data&#091; dataId ].value.length - 1 ){\n              strNewline += \" \"; \/\/ (Multiple: Space-separated)\n            }\n          }\n        }\n      }else{\n        strNewline += \"#TYPE!\";\n      }\n    }\n    if( i !== arrDataitemIds.length - 1 ){\n      strNewline += \"\\t\";\n    }\n  }\n  if( h !== responseObj.processInstances.length - 1 ){\n    strNewline += \"\\n\";\n  }\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strNewline === \"\" ){\n  engine.log( \" AutomatedTask DataUpdating: Extracted Text empty\" );\n}\nif( dataIdE !== \"\" ){\n  engine.setDataByNumber( dataIdE, strNewline );\n}\nif( dataIdF !== \"\" ){\n  if( strBeforeAppend !== null ){\n    engine.setDataByNumber( dataIdF, strBeforeAppend + \"\\n\" + strNewline );\n  }else{\n    engine.setDataByNumber( dataIdF, strNewline );\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\/1wAfi0wsMa9oTijXVeBWgd0d_b1NvaPpy\/view?usp=sharing\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Questetra-BPMS-Process-Batch-Extract-as-TSV.xml (opens in a new tab)\">Questetra-BPMS-Process-Batch-Extract-as-TSV.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\/batch-extract-as-tsv-1.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 size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-capture-en.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"82153\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv\/attachment\/questetra-bpms-process-batch-extract-as-tsv-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Extracts process data as a multi-line TSV string from date-filtered processes. Items are specified in CSV format such as &quot;string:0,date:2,select:3&quot;. Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported.\" class=\"wp-image-82153\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"83387\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv\/attachment\/qmascot-bpmn-timer-start-event\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/qmascot-bpmn-timer-start-event.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=\"qmascot-bpmn-timer-start-event\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/qmascot-bpmn-timer-start-event.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i1.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/qmascot-bpmn-timer-start-event.png?fit=1024%2C576&amp;ssl=1\" alt=\"BPMN Timer Start Event: A specific time-date or a specific cycle (e.g., every Monday at 9am) can be set that will trigger the start of the Process.\" class=\"wp-image-83387\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/qmascot-bpmn-timer-start-event.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/qmascot-bpmn-timer-start-event.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/qmascot-bpmn-timer-start-event.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/qmascot-bpmn-timer-start-event.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/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>Weekly and monthly reporting works can be automated with &#8220;Timer Start Event&#8221;.<\/li><li>Tab code and line feed code in Workflow data will be deleted.<\/li><li>Extraction data is specified by &#8220;{type}:{itemid}&#8221; in CSV notation (eg &#8220;string:0,date:2,select:3&#8221;)<\/li><li>Data Type Notations: string decimal date datetime select file quser qgroup<\/li><li>Specify &#8220;Title&#8221; to extract Title and &#8220;Id&#8221; to extract ID. ( e.g. &#8220;Title,Id,string:0,date:2,select:3&#8221; )<\/li><li>If an undefined dataitem ID or Guide Panel ID is specified, &#8220;#N\/A&#8221; is output.<\/li><li>If an unsupported type is specified, &#8220;#TYPE!&#8221; is output.<\/li><li>The file names are extracted for the File type. (Multiple: Space-separated)<\/li><li>The display strings of the selected options are extracted for the Select type. (Multiple: Space-separated)<\/li><li>If &#8220;C-target: Date-Type DataItem&#8221; is not specified, &#8220;processInstanceStartDatetime&#8221; will be the Filter target instead.<\/li><\/ol>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Spec Details<\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">Criteria Example<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;process-instance-criteria&gt;\n  &lt;process-model-info-id&gt;1439&lt;\/process-model-info-id&gt;\n  &lt;data&gt;\n    &lt;date&gt;\n      &lt;data-definition-number&gt;3&lt;\/data-definition-number&gt;\n      &lt;after-equals \/&gt;&lt;value&gt;2019-11-01&lt;\/value&gt;\n    &lt;\/date&gt;\n    &lt;date&gt;\n      &lt;data-definition-number&gt;3&lt;\/data-definition-number&gt;\n      &lt;before-equals \/&gt;&lt;value&gt;2019-11-02&lt;\/value&gt;\n    &lt;\/date&gt;\n    &lt;quser&gt;\n      &lt;data-definition-number&gt;2&lt;\/data-definition-number&gt;\n      &lt;view \/&gt;\n    &lt;\/quser&gt;\n    &lt;select&gt;\n      &lt;data-definition-number&gt;4&lt;\/data-definition-number&gt;\n      &lt;view \/&gt;\n    &lt;\/select&gt;\n    &lt;datetime&gt;\n      &lt;data-definition-number&gt;6&lt;\/data-definition-number&gt;\n      &lt;view \/&gt;\n    &lt;\/datetime&gt;\n  &lt;\/data&gt;\n&lt;\/process-instance-criteria&gt;<\/code><\/pre>\n\n\n\n<p class=\"has-text-align-right wp-block-paragraph\"><a href=\"https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360002481031-XML-Criteria-for-Process-Instance-Search\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\"Reference: Search Criteria XML (opens in a new tab)\"><i class=\"fal fa-external-link\"><\/i> Reference: Search Criteria XML for Process Instances<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Response Example<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"count\":8,\n  \"processInstances\":&#091;{\n    \"activeTokenNodeName\":null,\n    \"data\":{\n      \"2\":{\n        \"dataType\":\"QUSER\",\n        \"id\":33591338,\n        \"processDataDefinitionNumber\":2,\n        \"subType\":null,\n        \"value\":\"SUZUKI Ichiro &lt;suzuki@questetra.com&gt;\",\n        \"viewOrder\":3\n      },\n      \"3\":{\n        \"dataType\":\"DATE\",\n        \"id\":33591339,\n        \"processDataDefinitionNumber\":3,\n        \"subType\":\"DATE_YMD\",\n        \"value\":\"2019-11-01\",\n        \"viewOrder\":4\n      },\n      \"4\":{\n        \"dataType\":\"SELECT\",\n        \"id\":33591340,\n        \"processDataDefinitionNumber\":4,\n        \"subType\":null,\n        \"value\":&#091;{\"display\":\"\u52e4\u52d9\u6642\u9593\u78ba\u8a8d\u6e08\",\"value\":\"\u52e4\u52d9\u6642\u9593\u78ba\u8a8d\u6e08\"}],\n        \"viewOrder\":5\n      },\n      \"6\":{\n        \"dataType\":\"DATETIME\",\n        \"id\":33591342,\n        \"processDataDefinitionNumber\":6,\n        \"subType\":null,\n        \"value\":\"2019-11-01 08:39\",\n        \"viewOrder\":7\n      }\n    },\n    \"processInstanceDebug\":false,\n    \"processInstanceEndDatetime\":\"2019-11-02T14:09:02\",\n    \"processInstanceId\":998525,\n    \"processInstanceIdForView\":\"p998525\",\n    \"processInstanceInitQgroupId\":1,\n    \"processInstanceInitQgroupName\":\"\u5168\u793e\",\n    \"processInstanceInitQuserId\":14,\n    \"processInstanceInitQuserName\":\"SUZUKI Ichiro\",\n    \"processInstanceSequenceNumber\":8990,\n    \"processInstanceStartDatetime\":\"2019-11-01T07:00:00+0900\",\n    \"processInstanceState\":\"ENDED\",\n    \"processInstanceTitle\":\"2019-11-01(\u91d1): SUZUKI Ichiro\",\n    \"processModelInfoCategory\":\"2-\u7ba1\u7406\u90e8\",\n    \"processModelInfoId\":1439,\n    \"processModelInfoName\":\"242-\u51fa\u9000\u52e4\u5831\u544a\u30d5\u30ed\u30fc\",\n    \"processModelVersion\":19\n  },\n  {\n    \"activeTokenNodeName\":null,\n    \"data\":{\n      \"2\":{\n        \"dataType\":\"QUSER\",\n        \"id\":33591323,\n        \"processDataDefinitionNumber\":2,\n        .....\n      }\n    }\n    .....\n    \"processInstanceId\":998524,\n    .....\n  }]\n}<\/code><\/pre>\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=\"tsieYFi87I\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-extract-as-tsv\/\">Questetra BPMS: Process, Extract as TSV<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Questetra BPMS: Process, Extract as TSV&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/questetra-bpms-process-extract-as-tsv\/embed\/#?secret=RKZpnaonob#?secret=tsieYFi87I\" data-secret=\"tsieYFi87I\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Extracts process data as a multi-line TSV string from date-filtered processes. Items are specified in CSV format such as &#8220;string:0,date:2,select:3&#8221;. Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported.<\/p>\n","protected":false},"author":2,"featured_media":82150,"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":"","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":[],"class_list":["post-82149","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-en.png?fit=1200%2C675&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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":7,"uagb_excerpt":"Extracts process data as a multi-line TSV string from date-filtered processes. Items are specified in CSV format such as \"string:0,date:2,select:3\". Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-lmZ","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":82133,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-extract-as-tsv\/","url_meta":{"origin":82149,"position":0},"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":108912,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-extract-as-tsv-2021\/","url_meta":{"origin":82149,"position":1},"title":"Questetra BPMS #Process: Extract as TSV","author":"IMAMURA, Genichi","date":"2021-07-06","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 Extracts process data as a single-line TSV string. Items are specified in a CSV format such as \"0,2,3\". Tab code and line\u2026","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":82159,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-batch-extract-as-tsv\/","url_meta":{"origin":82149,"position":2},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u65e5\u4ed8\u30d5\u30a3\u30eb\u30bf\u3055\u308c\u305f\u8907\u6570\u306e\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u8907\u6570\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"string:0,date:2,select:3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","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":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u4e00\u62ec\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-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-Batch-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":109183,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-as-tsv-2021\/","url_meta":{"origin":82149,"position":3},"title":"Questetra BPMS: Process, Batch Extract as TSV","author":"IMAMURA, Genichi","date":"2021-07-12","format":false,"excerpt":"Extracts process data as a multi-line TSV string from date-filtered processes. Items are specified in CSV format such as \"string:0,date:2,select:3\". Tab code and line feed code are deleted. Discussion, Table, Guide-Panel type not supported.","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, Batch Extract as TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Batch-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-Batch-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-Batch-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-Batch-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-Batch-Extract-as-TSV-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":113093,"url":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021\/","url_meta":{"origin":82149,"position":4},"title":"Questetra BPMS #Process: Batch Extract by Filter as TSV","author":"IMAMURA, Genichi","date":"2021-09-15","format":false,"excerpt":"Extracts process data that match the specified saved filter. Stores the extracted data list as a TSV string. The filter is specified by ReportID which must be saved in the target platform in advance.","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, Batch Extract by Filter as TSV","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-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\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/09\/questetra-bpms-process-batch-extract-by-filter-as-tsv-2021-nocode-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82245,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-text\/","url_meta":{"origin":82149,"position":5},"title":"TSV String, Filter by Text","author":"IMAMURA, Genichi","date":"2019-11-25","format":false,"excerpt":"Filters TSV string with any search text. Only lines that contain the search text in the specified column are output. If you want an OR search with multiple texts, specify them as a comma-separated list such as \"USA,U.S.,United States\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Filter by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-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\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/TSV-String-Filter-by-Text-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82149","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=82149"}],"version-history":[{"count":10,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82149\/revisions"}],"predecessor-version":[{"id":109204,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/82149\/revisions\/109204"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/82150"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=82149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=82149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=82149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}