{"id":185946,"date":"2026-06-02T16:26:07","date_gmt":"2026-06-02T07:26:07","guid":{"rendered":"https:\/\/support.questetra.com\/?p=185946"},"modified":"2026-06-19T11:44:11","modified_gmt":"2026-06-19T02:44:11","slug":"questetra-bpms-tasks-extract-by-report-id-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/questetra-bpms-tasks-extract-by-report-id-2026\/","title":{"rendered":"Questetra BPMS #Tasks: Extract by Report ID"},"content":{"rendered":"\n

Questetra BPMS #Tasks: Extract by Report ID<\/strong><\/h4>\n\n\n\n

translate<\/span> Questetra BPMS #\u30bf\u30b9\u30af\u51e6\u7406: \u30ec\u30dd\u30fc\u30c8ID\u3067\u30c7\u30fc\u30bf\u62bd\u51fa<\/a><\/p>\n\n\n\n

Extracts task (workitem) data via API in TSV format. The data is extracted using the ReportID of the filtered list configured in the Web UI and stored in TSV format. The order of the data columns is configured using a CSV file of data item IDs.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
AuthzConfU<\/dt>
U: Select HTTP_Authz Setting *<\/span><\/dd>\n
StrConfA1<\/dt>
A1: Set Workflow-platform URL (eg. “${var[applicationRoot]}” ) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfA2<\/dt>
A2: Set ReportID (eg. “1234” ) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfA3<\/dt>
A3: Set Max Num of Records (eg. “100” )#{EL}<\/sup><\/span><\/dd>\n
StrConfB0<\/dt>
B0: Set TSV Column Order using DataItemID (eg “0,1,3,0” ) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfB1<\/dt>
B1: Select STRING for Extracted TSV (update) *<\/span><\/dd>\n<\/div>\n
SelectConfB2<\/dt>
B2: Select NUMERIC for Extracted Count (update)<\/dd>\n
SelectConfB3<\/dt>
B3: Select NUMERIC for Total Count of List (update)<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ Script for 'engine type: 3' ("GraalJS standard mode")\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst objAuthzSetting     = configs.getObject( "AuthzConfU" );   \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  engine.log( " AutomatedTask Config: Authz Setting: " + objAuthzSetting.getName() );\nconst strTargetUrl        = configs.get      ( "StrConfA1" );    \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  if( strTargetUrl      === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A1: TargetPlatformURL} is empty \\n" );\n  }\n  if( ! strTargetUrl.endsWith( "\/" ) ){\n    strTargetUrl += "\/";\n  }\nconst strReportId         = configs.get      ( "StrConfA2" );    \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n  if( strReportId       === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A2: ReportID} is empty \\n" );\n  }\nlet   strLimit            = configs.get      ( "StrConfA3" );    \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n  if( strLimit          === "" ){\n      strLimit = "1000";\n  }else if( isNaN( parseInt(strLimit, 10) ) || parseInt(strLimit, 10) < 0 ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A3: Max Num of Extraction} must be a positive integer \\n" );\n  }else if( parseInt(strLimit, 10) > 1000 ){\n    engine.log( " AutomatedTask ConfigWarning: " +\n                " {A3: Max Num of Extraction} is limited to 1000" );\n    strLimit = "1000";\n  }\nconst strColIds           = configs.get      ( "StrConfB0" );    \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\nconst strPocketTsv        = configs.getObject( "SelectConfB1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\nconst numPocketExtracted  = configs.getObject( "SelectConfB2" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\nconst numPocketFiltered   = configs.getObject( "SelectConfB3" ); \/\/ NotRequired \/\/\/\/\/\/\/\/\/\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\/\/\/ Get Workitems\n\/\/ request1, prepare\nlet request1Uri = strTargetUrl + "API\/OR\/Workitem\/list";\nlet request1    = httpClient.begin(); \/\/ HttpRequestWrapper\n    request1    = request1.authSetting( objAuthzSetting ); \/\/ with "Authorization: Bearer XX"\n    request1    = request1.queryParam( "reportId", strReportId );\n    request1    = request1.queryParam( "limit", strLimit );\n\n\/\/ request1, try\nconst response1     = request1.get( request1Uri ); \/\/ HttpResponseWrapper\nengine.log( " AutomatedTask ApiRequest1 Start: " + request1Uri );\nconst response1Code = response1.getStatusCode() + "";\nconst response1Body = response1.getResponseAsString() + "";\nengine.log( " AutomatedTask ApiResponse Status: " + response1Code );\nif( response1Code !== "200"){\n  throw new Error( "\\n AutomatedTask UnexpectedResponseError: " +\n                    response1Code + "\\n" + response1Body + "\\n" );\n}\n\n\/\/ response1, parse\nconst response1Obj = JSON.parse( response1Body );\nconst arrWorkitems = response1Obj.workitems || [];\n\nengine.log( " AutomatedTask Parsed: Number of Received Workitems: " + arrWorkitems.length );\nengine.log( " AutomatedTask Parsed: Number of Total Workitems: "    + response1Obj.count );\n\nconst arrColIds = parseColumnIds( strColIds );\nconst strTsv    = buildTsv( arrWorkitems, arrColIds );\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData(   strPocketTsv,       strTsv );\nif(               numPocketExtracted  !== null ){\n  engine.setData( numPocketExtracted,  new java.math.BigDecimal( arrWorkitems.length ) );\n}\nif(               numPocketFiltered   !== null ){\n  engine.setData( numPocketFiltered,   new java.math.BigDecimal( response1Obj.count ) );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/\/\/ == Sample Response \/ \u30ec\u30b9\u30dd\u30f3\u30b9\u30b5\u30f3\u30d7\u30eb ================================================\n\/* \n{\n  "count": 55,\n  "workitems": [\n    {\n      "allocateDatetime": "2026-05-29T10:00:17+0900",\n      "allocatedQgroupId": 3,\n      "allocatedQgroupName": "Sales",\n      "allocatedQuserId": 473,\n      "allocatedQuserName": "\u7530\u4e2d \u82b1\u5b50",\n      "data": {\n        "26": {\n          "dataType": "DATETIME",\n          "id": 143855494,\n          "processDataDefinitionNumber": 26,\n          "subType": null,\n          "value": "2026-05-29 11:00",\n          "viewOrder": 28\n        },\n        "30": {\n          "dataType": "STRING",\n          "formType": "TEXTFIELD",\n          "id": 143855497,\n          "processDataDefinitionNumber": 30,\n          "subType": null,\n          "value": "samplechem202605",\n          "viewOrder": 22\n        },\n        "31": {\n          "dataType": "QUSER",\n          "formType": "SELECT",\n          "id": 143855498,\n          "processDataDefinitionNumber": 31,\n          "subType": null,\n          "value": "\u7530\u4e2d \u82b1\u5b50 \\u003Ctanaka.hanako@example.com\\u003E",\n          "viewOrder": 33\n        }\n      },\n      "directAllocated": true,\n      "endDatetime": null,\n      "failType": null,\n      "id": 144978825,\n      "nodeName": "3.\u5b9f\u65bd\u5831\u544a\u3000 (\u898b\u8fbc\u6848\u4ef6\u767b\u9332)",\n      "nodeNumber": 7,\n      "offerDatetime": "2026-05-29T10:00:17+0900",\n      "parentProcessInstanceId": 2965305,\n      "processInstanceDebug": false,\n      "processInstanceEndDatetime": null,\n      "processInstanceId": 2965365,\n      "processInstanceIdForView": "p2965365",\n      "processInstanceInitQgroupId": null,\n      "processInstanceInitQgroupName": null,\n      "processInstanceInitQuserId": null,\n      "processInstanceInitQuserName": null,\n      "processInstanceSequenceNumber": 1023,\n      "processInstanceStartDatetime": "2026-05-21T16:26:51+0900",\n      "processInstanceState": "STARTED",\n      "processInstanceTitle": "DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e 2026-05-29 11:00",\n      "processModelId": 143449093,\n      "processModelInfoCategory": "5-\u55b6\u696d\u90e8",\n      "processModelInfoId": 3713,\n      "processModelInfoName": "552-NEW-Lead-Followup&Demo-fur",\n      "processModelVersion": 104,\n      "read": false,\n      "starred": false,\n      "startDatetime": null,\n      "state": "ALLOCATED",\n      "swimlaneType": "NORMAL",\n      "timeLimitDatetime": null\n    },\n    {\n      "allocateDatetime": "2026-05-29T10:00:16+0900",\n      "allocatedQgroupId": null,\n      "allocatedQgroupName": null,\n      "allocatedQuserId": 16,\n      "allocatedQuserName": "\u4f50\u85e4 \u592a\u90ce",\n      "data": {\n        "26": {\n          "dataType": "DATETIME",\n          "id": 143855494,\n          "processDataDefinitionNumber": 26,\n          "subType": null,\n          "value": "2026-05-29 11:00",\n          "viewOrder": 28\n        },\n        "30": {\n          "dataType": "STRING",\n          "formType": "TEXTFIELD",\n          "id": 143855497,\n          "processDataDefinitionNumber": 30,\n          "subType": null,\n          "value": "samplechem202605",\n          "viewOrder": 22\n        },\n        "31": {\n          "dataType": "QUSER",\n          "formType": "SELECT",\n          "id": 143855498,\n          "processDataDefinitionNumber": 31,\n          "subType": null,\n          "value": "\u7530\u4e2d \u82b1\u5b50 \\u003Ctanaka.hanako@example.com\\u003E",\n          "viewOrder": 33\n        }\n      },\n      "directAllocated": true,\n      "endDatetime": null,\n      "failType": null,\n      "id": 144978807,\n      "nodeName": "3b.\u540c\u5e2d\u30d5\u30a3\u30fc\u30c9\u30d0\u30c3\u30af",\n      "nodeNumber": 37,\n      "offerDatetime": "2026-05-29T10:00:16+0900",\n      "parentProcessInstanceId": 2965305,\n      "processInstanceDebug": false,\n      "processInstanceEndDatetime": null,\n      "processInstanceId": 2965365,\n      "processInstanceIdForView": "p2965365",\n      "processInstanceInitQgroupId": null,\n      "processInstanceInitQgroupName": null,\n      "processInstanceInitQuserId": null,\n      "processInstanceInitQuserName": null,\n      "processInstanceSequenceNumber": 1023,\n      "processInstanceStartDatetime": "2026-05-21T16:26:51+0900",\n      "processInstanceState": "STARTED",\n      "processInstanceTitle": "DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e 2026-05-29 11:00",\n      "processModelId": 143449093,\n      "processModelInfoCategory": "5-\u55b6\u696d\u90e8",\n      "processModelInfoId": 3713,\n      "processModelInfoName": "552-NEW-Lead-Followup&Demo-fur",\n      "processModelVersion": 104,\n      "read": false,\n      "starred": false,\n      "startDatetime": null,\n      "state": "ALLOCATED",\n      "swimlaneType": "NORMAL",\n      "timeLimitDatetime": "2026-06-01T11:00:00+0900"\n    },\n    {\n      "allocateDatetime": "2026-05-29T07:56:27+0900",\n      "allocatedQgroupId": 3,\n      "allocatedQgroupName": "Sales",\n      "allocatedQuserId": 16,\n      "allocatedQuserName": "\u4f50\u85e4 \u592a\u90ce",\n      "data": {\n        "26": {\n          "dataType": "DATETIME",\n          "id": 144974395,\n          "processDataDefinitionNumber": 26,\n          "subType": null,\n          "value": null,\n          "viewOrder": 28\n        },\n        "30": {\n          "dataType": "STRING",\n          "formType": "TEXTFIELD",\n          "id": 144974398,\n          "processDataDefinitionNumber": 30,\n          "subType": null,\n          "value": "sample-lead-001",\n          "viewOrder": 22\n        },\n        "31": {\n          "dataType": "QUSER",\n          "formType": "SELECT",\n          "id": 144974399,\n          "processDataDefinitionNumber": 31,\n          "subType": null,\n          "value": null,\n          "viewOrder": 33\n        }\n      },\n      "directAllocated": true,\n      "endDatetime": null,\n      "failType": null,\n      "id": 144974447,\n      "nodeName": "0. FollowUp (FirstTouch)",\n      "nodeNumber": 63,\n      "offerDatetime": "2026-05-29T07:56:27+0900",\n      "parentProcessInstanceId": 2976616,\n      "processInstanceDebug": false,\n      "processInstanceEndDatetime": null,\n      "processInstanceId": 2976911,\n      "processInstanceIdForView": "p2976911",\n      "processInstanceInitQgroupId": null,\n      "processInstanceInitQgroupName": null,\n      "processInstanceInitQuserId": null,\n      "processInstanceInitQuserName": null,\n      "processInstanceSequenceNumber": 1047,\n      "processInstanceStartDatetime": "2026-05-29T07:56:25+0900",\n      "processInstanceState": "STARTED",\n      "processInstanceTitle": "LEAD \u5c71\u7530 \u4e00\u90ce 2026-05-29 sample-lead-001",\n      "processModelId": 144422810,\n      "processModelInfoCategory": "5-\u55b6\u696d\u90e8",\n      "processModelInfoId": 3713,\n      "processModelInfoName": "552-NEW-Lead-Followup&Demo-fur",\n      "processModelVersion": 106,\n      "read": false,\n      "starred": false,\n      "startDatetime": "2026-05-29T08:12:37+0900",\n      "state": "STARTED",\n      "swimlaneType": "NORMAL",\n      "timeLimitDatetime": null\n    }\n  ]\n}\n*\/\n\n\n\n\/\/\/\/ == Function Definitions \/ \u95a2\u6570\u5b9a\u7fa9 ================================================\n\nfunction parseColumnIds( strColIds ){\n  if( strColIds === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {B0: TSV Column Order} is empty \\n" );\n  }\n\n  const arrColIds = strColIds.split( "," ).map(function( strColId ){\n    return strColId.trim();\n  });\n\n  for( let i = 0; i < arrColIds.length; i++ ){\n    if( arrColIds[i] === "" ){\n      throw new Error( "\\n AutomatedTask ConfigError:" +\n                       " Config {B0: TSV Column Order} contains an empty column ID \\n" );\n    }\n  }\n  return arrColIds;\n}\n\nfunction buildTsv( arrWorkitems, arrColIds ){\n  const arrLines = [];\n  for( let i = 0; i < arrWorkitems.length; i++ ){\n    const objWorkitem = arrWorkitems[i];\n    const arrCells    = [];\n    for( let j = 0; j < arrColIds.length; j++ ){\n      arrCells.push( stringifyColumn( objWorkitem, arrColIds[j] ) );\n    }\n    arrLines.push( arrCells.join( "\\t" ) );\n  }\n  return arrLines.join( "\\n" );\n}\n\nfunction stringifyColumn( objWorkitem, strColId ){\n  if( isWorkitemPropertyName( strColId ) ){\n    return sanitizeTsvCell( objWorkitem[strColId] );\n  }\n\n  const objDataItems = objWorkitem.data || {};\n  if( objDataItems[strColId] === undefined ){\n    return "";\n  }\n  return stringifyDataItem( objDataItems[strColId] );\n}\n\nfunction stringifyDataItem( objDataItem ){\n  if( objDataItem === null || objDataItem === undefined ){\n    return "";\n  }\n  if( objDataItem.value === null || objDataItem.value === undefined ){\n    return "";\n  }\n\n  const strDataType = objDataItem.dataType + "";\n  const value       = objDataItem.value;\n\n  if( strDataType === "SELECT" ){\n    return sanitizeTsvCell( joinValuesByProperty( value, "display" ) );\n  }\n  if( strDataType === "FILE" || strDataType === "FILE2" ){\n    return sanitizeTsvCell( joinValuesByProperty( value, "name" ) );\n  }\n  if( strDataType === "QUSER" || strDataType === "QGROUP" ){\n    return sanitizeTsvCell( stringifyQuserOrQgroupValue( value ) );\n  }\n  if( strDataType === "STRING" ||\n      strDataType === "DECIMAL" ||\n      strDataType === "DATE" ||\n      strDataType === "DATETIME" ||\n      strDataType === "DISCUSSION" ){\n    return sanitizeTsvCell( value );\n  }\n\n  return "N\/A";\n}\n\nfunction joinValuesByProperty( value, strPropertyName ){\n  if( ! Array.isArray( value ) ){\n    if( typeof value === "object" && value !== null ){\n      return value[strPropertyName] || "";\n    }\n    return value;\n  }\n\n  const arrValues = [];\n  for( let i = 0; i < value.length; i++ ){\n    if( value[i] !== null && value[i] !== undefined ){\n      if( typeof value[i] === "object" ){\n        arrValues.push( value[i][strPropertyName] || "" );\n      }else{\n        arrValues.push( value[i] );\n      }\n    }\n  }\n  return arrValues.join( " " );\n}\n\nfunction stringifyQuserOrQgroupValue( value ){\n  if( Array.isArray( value ) ){\n    const arrValues = [];\n    for( let i = 0; i < value.length; i++ ){\n      arrValues.push( stringifyQuserOrQgroupValue( value[i] ) );\n    }\n    return arrValues.join( " " );\n  }\n  if( typeof value !== "object" || value === null ){\n    return value;\n  }\n\n  if( value.name    !== undefined && value.name    !== null ){ return value.name;    }\n  if( value.display !== undefined && value.display !== null ){ return value.display; }\n  if( value.qname   !== undefined && value.qname   !== null ){ return value.qname;   }\n  if( value.email   !== undefined && value.email   !== null ){ return value.email;   }\n\n  return JSON.stringify( value );\n}\n\nfunction sanitizeTsvCell( value ){\n  if( value === null || value === undefined ){\n    return "";\n  }\n  return ( value + "" ).replace( \/\\r?\\n\/g, " " ).replace( \/\\t\/g, " " );\n}\n\nfunction isWorkitemPropertyName( strColId ){\n  const objProperties = {\n    "allocateDatetime": true,\n    "allocatedQgroupId": true,\n    "allocatedQgroupName": true,\n    "allocatedQuserId": true,\n    "allocatedQuserName": true,\n    "directAllocated": true,\n    "endDatetime": true,\n    "failType": true,\n    "id": true,\n    "nodeName": true,\n    "nodeNumber": true,\n    "offerDatetime": true,\n    "read": true,\n    "startDatetime": true,\n    "state": true,\n    "swimlaneType": true,\n    "timeLimitDatetime": true,\n    "parentProcessInstanceId": true,\n    "processInstanceDebug": true,\n    "processInstanceEndDatetime": true,\n    "processInstanceId": true,\n    "processInstanceIdForView": true,\n    "processInstanceInitQgroupId": true,\n    "processInstanceInitQgroupName": true,\n    "processInstanceInitQuserId": true,\n    "processInstanceInitQuserName": true,\n    "processInstanceSequenceNumber": true,\n    "processInstanceStartDatetime": true,\n    "processInstanceState": true,\n    "processInstanceTitle": true,\n    "processModelId": true,\n    "processModelInfoCategory": true,\n    "processModelInfoId": true,\n    "processModelInfoName": true,\n    "processModelVersion": true,\n    "starred": true\n  };\n  return objProperties[strColId] === true;\n}\n\n\/*\n### Notes-en:\n- When a Workitem arrives at this Automated Step, an extraction request is sent.\n- Target URL requires a trailing `\/`.\n- The extracted TSV is saved as the "simplest tab-separated string".\n- Only the data displayed in the list specified by the `ReportID` will be stored.\n- Configure the TSV column order in B0 using Data Item IDs (CSV).\n    - Example: `0,47,2,8`\n- To store property data of the Task (Workitem) or Case (Process Instance) in a TSV column, set the following variable names instead of the Data Item ID. (Example: `id,state,processInstanceId,0,47`)\n    - Workitem ID: `id` (eg: "144978825")\n    - Workitem Node\/Step Name: `nodeName` (eg: "3.\u5b9f\u65bd\u5831\u544a")\n    - Workitem Node\/Step Number: `nodeNumber` (eg: "7")\n    - Workitem State: `state` (eg: "ALLOCATED")\n    - Workitem Allocated User ID: `allocatedQuserId`\n    - Workitem Allocated User Name: `allocatedQuserName`\n    - Issue ID: `processInstanceId` (eg: "2965365")\n    - Title: `processInstanceTitle` (eg: "DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e...")\n    - ...and other Process Instance properties.\n\n#### Task (Workitem) Properties\n- `allocateDatetime`: Task allocation datetime (eg: "2026-05-29T10:00:17+0900")\n- `allocatedQgroupId`: Allocated Qgroup ID (eg: "3")\n- `allocatedQgroupName`: Allocated Qgroup Name (eg: "Sales")\n- `allocatedQuserId`: Allocated Quser ID (eg: "473")\n- `allocatedQuserName`: Allocated Quser Name (eg: "SUZUKI, Ichiro")\n- `directAllocated`: Direct allocation flag ("true" or "false")\n- `endDatetime`: Task end datetime (Processing completed time)\n- `failType`: Failure type (null if success)\n- `id`: Workitem (Task) ID (eg: "144978825")\n- `nodeName`: Step \/ Node Name (eg: "3.\u5b9f\u65bd\u5831\u544a")\n- `nodeNumber`: Step \/ Node Number (eg: "7")\n- `offerDatetime`: Task offered datetime (eg: "2026-05-29T10:00:17+0900")\n- `read`: Read flag ("true" or "false")\n- `startDatetime`: Task start datetime (Processing started time)\n- `state`: Task State (eg: "OFFERED", "ALLOCATED", "STARTED", "ENDED")\n- `swimlaneType`: Swimlane Type (eg: "NORMAL")\n- `timeLimitDatetime`: Task time limit datetime\n\n#### Case (Process Instance) Properties\n- `parentProcessInstanceId`: Parent App Process Instance ID\n- `processInstanceDebug`: Debug Mode ("false" or "true")\n- `processInstanceEndDatetime`: Case End Datetime\n- `processInstanceId`: Case ID (eg: "2965365")\n- `processInstanceIdForView`: Case ID with 'p' (eg: "p2965365")\n- `processInstanceInitQgroupId`: Starting User's Organization ID\n- `processInstanceInitQgroupName`: Starting User's Organization Name\n- `processInstanceInitQuserId`: Starting User's User ID\n- `processInstanceInitQuserName`: Starting User's User Name\n- `processInstanceSequenceNumber`: Sequence Number managed at App level (eg: "1023")\n- `processInstanceStartDatetime`: Case Start Datetime (eg: "2026-05-21T16:26:51+0900")\n- `processInstanceState`: Case State (eg: "STARTED")\n- `processInstanceTitle`: Case Title (eg: "DEMO Sample Chemical...")\n- `processModelId`: App ID \/ Process Model ID\n- `processModelInfoCategory`: App Category Name (eg: "5-\u55b6\u696d\u90e8")\n- `processModelInfoId`: App Category ID (eg: "3713")\n- `processModelInfoName`: App Name \/ Process Model Name\n- `processModelVersion`: App Version (eg: "104")\n- `starred`: App Starred ("false" or "true")\n\n### Notes-ja:\n- \u3053\u306e\u30a2\u30c9\u30aa\u30f3\u81ea\u52d5\u5de5\u7a0b\u306b\u30bf\u30b9\u30af\uff08\u30ef\u30fc\u30af\u30a2\u30a4\u30c6\u30e0\uff09\u304c\u5230\u9054\u3057\u305f\u969b\u3001\u62bd\u51fa\u30ea\u30af\u30a8\u30b9\u30c8\u304c\u6295\u3052\u3089\u308c\u307e\u3059\u3002\n    - \u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u306a\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u306f URL \u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002\uff08REST API \u63a5\u7d9a\u5148\uff09\n        - `https:\/\/karasuma-oike-000.questetra.net\/`\n        - \u672b\u5c3e\u306e `\/` \u304c\u5fc5\u8981\u3067\u3042\u308b\u70b9\u306b\u6ce8\u610f\n    - \u30bf\u30fc\u30b2\u30c3\u30c8\u3068\u306a\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u57fa\u76e4\u304c\u540c\u4e00\u57fa\u76e4\u306e\u5834\u5408\u3001\uff3b\u30b7\u30b9\u30c6\u30e0\u5909\u6570\uff3d\u306b\u3088\u308b\u8a2d\u5b9a\u3067\u4ee3\u7528\u53ef\u80fd\u5229\u3067\u3059\u3002\n        - `${var[applicationRoot]}`\n- \u62bd\u51faTSV\u306f\u300c\u3082\u3063\u3068\u3082\u30b7\u30f3\u30d7\u30eb\u306a\u30bf\u30d6\u533a\u5207\u308a\u6587\u5b57\u5217\u300d\u3068\u3057\u3066\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\n    - \u5404\u30c7\u30fc\u30bf\u5185\u306eTAB\u30b3\u30fc\u30c9\u3084\u6539\u884c\u30b3\u30fc\u30c9\u306f " " \uff08\u534a\u89d2\u30b9\u30da\u30fc\u30b9\uff09\u306b\u5909\u63db\u3055\u308c\u307e\u3059\u3002\n    - \u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u3082\u3001\u30a8\u30b9\u30b1\u30fc\u30d7\u3055\u308c\u3066\u3044\u306a\u3044\u72b6\u614b\u3067\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002\n- ReportID \u306f\u3001\u30bf\u30b9\u30af\u30ea\u30b9\u30c8\u8868\u793a\u6642\u306eURI\u672b\u5c3e\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - `https:\/\/example.questetra.net\/OR\/Workitem\/listView?reportId=123456789`\n- ReportID \u3067\u6307\u5b9a\u3057\u305f\u30ea\u30b9\u30c8\u306b\u8868\u793a\u3055\u308c\u3066\u3044\u308b\u30c7\u30fc\u30bf\u3060\u3051\u304c\u683c\u7d0d\u3055\u308c\u307e\u3059\u3002\uff08\u305f\u3060\u3057\u5217\u9806\u4e0d\u540c\uff09\n    - TSV\u5217\u9806\u306f\u30c7\u30fc\u30bf\u9805\u76eeID\u3092\u7528\u3044\u305fCSV\u3067\u8a2d\u5b9a\u3057\u307e\u3059\u3002\uff08\u4f8b: `0,47,2,8`\uff09\n    - TSV\u5217\u306b\u30bf\u30b9\u30af\u51e6\u7406\u306e\u30d7\u30ed\u30d1\u30c6\u30a3\u30c7\u30fc\u30bf\u3092\u683c\u7d0d\u3055\u305b\u305f\u3044\u5834\u5408\u3001\u30c7\u30fc\u30bf\u9805\u76eeID\u306e\u4ee3\u308f\u308a\u306b\u6b21\u306e\u5909\u6570\u540d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002 \uff08\u4f8b: `id,state,processInstanceId,0,47`\uff09\n        - \u30bf\u30b9\u30afID: `id` (eg: "144978825")\n        - \u5de5\u7a0b\u540d: `nodeName` (eg: "3.\u5b9f\u65bd\u5831\u544a")\n        - \u5de5\u7a0b\u30ca\u30f3\u30d0\u30fc: `nodeNumber` (eg: "7")\n        - \u30bf\u30b9\u30af\u72b6\u614b: `state` (eg: "ALLOCATED" \u307e\u305f\u306f "OFFERED" \u306a\u3069)\n        - \u5272\u5f53\u30e6\u30fc\u30b6\u30fcID: `allocatedQuserId`\n        - \u5272\u5f53\u30e6\u30fc\u30b6\u30fc\u540d: `allocatedQuserName`\n        - \u30b1\u30fc\u30b9ID: `processInstanceId` (eg:"2965365")\n        - \u4ef6\u540d: `processInstanceTitle` (eg:"DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e...")\n        - ...\u305d\u306e\u4ed6\u30d7\u30ed\u30bb\u30b9\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30d7\u30ed\u30d1\u30c6\u30a3\u3082\u5229\u7528\u53ef\u80fd\u3067\u3059\u3002\n\n#### \u30bf\u30b9\u30af\u51e6\u7406\uff08\u30ef\u30fc\u30af\u30a2\u30a4\u30c6\u30e0\uff09\u30d7\u30ed\u30d1\u30c6\u30a3\u3011\n- \u30bf\u30b9\u30af\u5272\u5f53\u65e5\u6642: `allocateDatetime` (\u4f8b: "2026-05-29T10:00:17+0900")\n- \u5272\u5f53\u7d44\u7e54ID: `allocatedQgroupId` (\u4f8b: "3")\n- \u5272\u5f53\u7d44\u7e54\u540d: `allocatedQgroupName` (\u4f8b: "Sales")\n- \u5272\u5f53\u30e6\u30fc\u30b6ID: `allocatedQuserId` (\u4f8b: "473")\n- \u5272\u5f53\u30e6\u30fc\u30b6\u540d: `allocatedQuserName` (\u4f8b: "\u9234\u6728 \u30a4\u30c1\u30ed\u30fc")\n- \u76f4\u63a5\u5272\u5f53\u30d5\u30e9\u30b0: `directAllocated` ("true" \u307e\u305f\u306f "false")\n- \u30bf\u30b9\u30af\u7d42\u4e86\u65e5\u6642(\u51e6\u7406\u65e5\u6642): `endDatetime`\n- \u5931\u6557\u30bf\u30a4\u30d7: `failType`\n- \u30bf\u30b9\u30afID: `id` (\u4f8b: "144978825")\n- \u5de5\u7a0b\u540d: `nodeName` (\u4f8b: "3.\u5b9f\u65bd\u5831\u544a")\n- \u5de5\u7a0b\u30ca\u30f3\u30d0\u30fc: `nodeNumber` (\u4f8b: "7")\n- \u53d7\u4ed8\u958b\u59cb\u65e5\u6642(\u30aa\u30d5\u30a1\u30fc\u65e5\u6642): `offerDatetime` (\u4f8b: "2026-05-29T10:00:17+0900")\n- \u65e2\u8aad\u30d5\u30e9\u30b0: `read` ("true" \u307e\u305f\u306f "false")\n- \u30bf\u30b9\u30af\u51e6\u7406\u958b\u59cb\u65e5\u6642: `startDatetime`\n- \u30bf\u30b9\u30af\u72b6\u614b: `state` (\u4f8b: "OFFERED", "ALLOCATED", "STARTED", "ENDED", "FAILED")\n- \u30b9\u30a4\u30e0\u30ec\u30fc\u30f3\u30bf\u30a4\u30d7: `swimlaneType` (\u4f8b: "NORMAL")\n- \u30bf\u30b9\u30af\u51e6\u7406\u671f\u9650\u65e5\u6642: `timeLimitDatetime`\n\n#### \u30b1\u30fc\u30b9\uff08\u6848\u4ef6\u30fb\u30d7\u30ed\u30bb\u30b9\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\uff09\u30d7\u30ed\u30d1\u30c6\u30a3\n- \u89aa\u30a2\u30d7\u30ea\u306e\u30b1\u30fc\u30b9ID: `parentProcessInstanceId`\n- \u30c7\u30d0\u30c3\u30b0\u30e2\u30fc\u30c9: `processInstanceDebug` ("false" \u307e\u305f\u306f "true")\n- \u30b1\u30fc\u30b9\u7d42\u4e86\u6642\u523b: `processInstanceEndDatetime`\n- \u30b1\u30fc\u30b9ID: `processInstanceId` (\u4f8b: "2965365")\n- \u30b1\u30fc\u30b9ID(p\u4ed8): `processInstanceIdForView` (\u4f8b: "p2965365")\n- \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u6240\u5c5e\u7d44\u7e54ID: `processInstanceInitQgroupId`\n- \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u6240\u5c5e\u7d44\u7e54\u540d: `processInstanceInitQgroupName`\n- \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6ID: `processInstanceInitQuserId`\n- \u958b\u59cb\u30e6\u30fc\u30b6\u306e\u30e6\u30fc\u30b6\u540d: `processInstanceInitQuserName`\n- \u30b1\u30fc\u30b9\u9023\u756a(\u30a2\u30d7\u30ea\u30ec\u30d9\u30eb\u3067\u7ba1\u7406\u3055\u308c\u308b\u5909\u6570): `processInstanceSequenceNumber` (\u4f8b: "1023")\n- \u30b1\u30fc\u30b9\u958b\u59cb\u65e5\u6642: `processInstanceStartDatetime` (\u4f8b: "2026-05-21T16:26:51+0900")\n- \u72b6\u614b: `processInstanceState` (\u4f8b: "STARTED", "ENDED", "FAILED" )\n- \u4ef6\u540d: `processInstanceTitle` (\u4f8b: "DEMO \u30b5\u30f3\u30d7\u30eb\u5316\u5b66\u682a\u5f0f\u4f1a\u793e...")\n- \u30a2\u30d7\u30eaID: `processModelId` (\u4f8b: "143449093")\n- \u30a2\u30d7\u30ea\u306e\u30ab\u30c6\u30b4\u30ea\u540d: `processModelInfoCategory` (\u4f8b: "5-\u55b6\u696d\u90e8")\n- \u30a2\u30d7\u30ea\u306e\u30ab\u30c6\u30b4\u30eaID: `processModelInfoId` (\u4f8b: "3713")\n- \u30a2\u30d7\u30ea\u540d: `processModelInfoName` (\u4f8b: "552-NEW-Lead-Followup...")\n- \u30a2\u30d7\u30ea\u30d0\u30fc\u30b8\u30e7\u30f3: `processModelVersion` (\u4f8b: "104")\n- \u30a2\u30d7\u30ea\u306e\u2605\u6709\u7121: `starred` ("false" \u307e\u305f\u306f "true")\n\n\n### APPENDIX-en\n- If the number of tasks of the filter extraction result is 1000 or more, the data after 1001 will not be stored.\n    - Even if 1000 or less, there is a possibility of timeout when there are many data items.\n    - To control the number of extraction results\n        - Extract only the processes whose status status is `Running`\n        - Extract only the date data of the previous month\n            - After: `#today.addMonths(-1).getFirstTimeInMonth()`\n            - Before: `#today.addMonths(-1).getLastTimeInMonth()`\n- "HTTP Authorization Setting" is required for automatic communication (OAuth2 API connection).\n    - Register [API Client] (OAuth2) in advance as the connection destination. (Requires System Admin privileges)\n        - Scope\n            - Read-only API Access\n        - Redirect URL\n            - `https:\/\/s.questetra.net\/oauth2callback`\n        - Make a __note__ of your registration details.\n            - Client ID\n            - Client Secret (Consumer Secret)\n            - Authorization Endpoint URL\n            - Token Endpoint URL\n    - Set "HTTP Authorization Setting" in the App as client. (Select this setting name in Addon config)\n        - Authorization Endpoint URL:\n            - _(See your note above)_\n            - Example: `https:\/\/example.questetra.net\/oauth2\/authorize`\n        - Token Endpoint URL:\n            - _(See your note above)_\n            - Example: `https:\/\/example.questetra.net\/oauth2\/token`\n        - Scope:\n            - `read`\n        - Client ID\n            - _(See your note above)_\n        - Client Secret:\n            - _(See your note above)_\n- Table type data is not supported for extraction.\n    - If an unsupported type, "`N\/A`" 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\n\n### APPENDIX-ja:\n- \u30d5\u30a3\u30eb\u30bf\u62bd\u51fa\u7d50\u679c\u306e\u30bf\u30b9\u30af\u51e6\u7406\u6570\uff08\u30ef\u30fc\u30af\u30a2\u30a4\u30c6\u30e0\u6570\uff09\u304c1000\u4ef6\u4ee5\u4e0a\u3042\u308b\u5834\u5408\u30011001\u4ef6\u4ee5\u964d\u306e\u30c7\u30fc\u30bf\u306f\u683c\u7d0d\u3055\u308c\u307e\u305b\u3093\u3002\n    - \u62bd\u51fa\u7d50\u679c\u304c1000\u4ef6\u4ee5\u4e0b\u3068\u306a\u308b\u5834\u5408\u3067\u3082\u3001\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u6570\u304c\u591a\u3044\u5834\u5408\u306a\u3069\u3001\u30bf\u30a4\u30e0\u30a2\u30a6\u30c8\u3059\u308b\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u3002\n    - \u62bd\u51fa\u7d50\u679c\u306e\u6570\u3092\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3059\u308b\u5de5\u592b\n        - \u72b6\u614b\u30b9\u30c6\u30fc\u30bf\u30b9\u304c `\u672a\u7d42\u4e86` \u306e\u6848\u4ef6\uff08\u30d7\u30ed\u30bb\u30b9\uff09\u306b\u7d5e\u3063\u3066\u62bd\u51fa\u3059\u308b\n        - \u6848\u4ef6\u5185\u306e\u65e5\u4ed8\u30c7\u30fc\u30bf\u304c\u524d\u6708\u306e\u3082\u306e\u306b\u7d5e\u3063\u3066\u62bd\u51fa\u3059\u308b\n            - \u4ee5\u964d\/After: `#today.addMonths(-1).getFirstTimeInMonth()`\n            - \u4ee5\u524d\/Before: `#today.addMonths(-1).getLastTimeInMonth()`\n- \u81ea\u52d5\u901a\u4fe1\uff08OAuth2 API\u63a5\u7d9a\uff09\u306e\u305f\u3081\u306b "HTTP\u8a8d\u8a3c\u8a2d\u5b9a" \u304c\u5fc5\u8981\u3067\u3059\u3002\n    - \u3042\u3089\u304b\u3058\u3081\u63a5\u7d9a\u5148\u306b\u3001\uff3bAPI\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\uff3d\uff08OAuth2\uff09\u3092\u767b\u9332\u3057\u307e\u3059\u3002\uff08\u30b7\u30b9\u30c6\u30e0\u7ba1\u7406\u8005\u6a29\u9650\u304c\u5fc5\u8981\u3067\u3059\uff09\n        - \u30b9\u30b3\u30fc\u30d7\uff08Scope\uff09\n            - \u30c7\u30fc\u30bf\u3092\u53d6\u5f97\u3059\u308b API \u3078\u306e\u30a2\u30af\u30bb\u30b9 \/ Read-only API Access\n        - \u30ea\u30c0\u30a4\u30ec\u30af\u30c8URL\uff08Redirect URL\uff09\n            - `https:\/\/s.questetra.net\/oauth2callback`\n        - \u767b\u9332\u5185\u5bb9\u3092 __\u30e1\u30e2__ \u3057\u307e\u3059\u3002\n            - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\uff08Client ID\uff09\n            - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8\uff08Consumer Secret\uff09\n            - \u8a8d\u53ef\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8URL\uff08Authorization Endpoint URL\uff09\n            - \u30c8\u30fc\u30af\u30f3\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8URL\uff08Token Endpoint URL\uff09\n    - \u901a\u4fe1\u5143\u3067\u3042\u308b\u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30a2\u30d7\u30ea\u306b\u3066\uff3bHTTP\u8a8d\u8a3c\u8a2d\u5b9a\uff3d\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002\uff08\u3053\u306e\u8a2d\u5b9a\u540d\u3092Addon\u30b3\u30f3\u30d5\u30a3\u30b0\u3067\u9078\u629e\uff09\n        - \u8a8d\u53ef\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8 URL:\n            - (\u30e1\u30e2\u3092\u53c2\u7167)\n            - \u4f8b\uff1a `https:\/\/example.questetra.net\/oauth2\/authorize`\n        - \u30c8\u30fc\u30af\u30f3\u30a8\u30f3\u30c9\u30dd\u30a4\u30f3\u30c8 URL:\n            - (\u30e1\u30e2\u3092\u53c2\u7167)\n            - \u4f8b\uff1a `https:\/\/example.questetra.net\/oauth2\/token`\n        - \u30b9\u30b3\u30fc\u30d7:\n            - `read`\n        - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8ID\n            - (\u30e1\u30e2\u3092\u53c2\u7167)\n        - \u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u30b7\u30fc\u30af\u30ec\u30c3\u30c8:\n            - (\u30e1\u30e2\u3092\u53c2\u7167)\n- \u30c6\u30fc\u30d6\u30eb\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u5185\u306e\u30c7\u30fc\u30bf\u306f\u62bd\u51fa\u30b5\u30dd\u30fc\u30c8\u5916\u3067\u3059\u3002\n    - \u30b5\u30dd\u30fc\u30c8\u5916\u306e\u30c7\u30fc\u30bf\u578b\u306f "`N\/A`" \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\n\n*\/\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n