Filter Spec / Body in REST api of Query Definition with Filtered Data

[nikhil.mehta]

Hello,

I am trying to get data using Query Definition and for that I have created query definition using following rest api.

Type : POST

URL :   /server/queries/definitions/{queryName}

Params :

queryName  : getAllTaskInputInstancesWithVariables

body : 

{

  "query-source" : "java:jboss/datasources/jbpmDS",

  "query-expression" : "select ti.*, tv.name tvname, tv.value tvvalue from AuditTaskImpl ti inner join (select tv.taskId, tv.name, tv.value from TaskVariableImpl tv where tv.type = 0 ) tv on (tv.taskId = ti.taskId)",

  "query-target" : "CUSTOM"

}

Query Definition is successfully created with following response.

{

  "query-name" : "getAllTaskInputInstancesWithVariables",

  "query-source" : "java:jboss/datasources/jbpmDS",

  "query-expression" : "select ti.*, tv.name tvname, tv.value tvvalue from AuditTaskImpl ti inner join (select tv.taskId, tv.name, tv.value from TaskVariableImpl tv where tv.type = 0 ) tv on (tv.taskId = ti.taskId)",

  "query-target" : "CUSTOM",

  "query-columns" : {

    "PROCESSSESSIONID" : "NUMBER",

    "CREATEDON" : "DATE",

    "WORKITEMID" : "NUMBER",

    "TVVALUE" : "LABEL",

    "PRIORITY" : "NUMBER",

    "ACTUALOWNER" : "LABEL",

    "NAME" : "LABEL",

    "ACTIVATIONTIME" : "DATE",

    "TASKID" : "NUMBER",

    "PROCESSINSTANCEID" : "NUMBER",

    "STATUS" : "LABEL",

    "PARENTID" : "NUMBER",

    "DESCRIPTION" : "LABEL",

    "DEPLOYMENTID" : "LABEL",

    "LASTMODIFICATIONDATE" : "DATE",

    "TVNAME" : "LABEL",

    "ID" : "NUMBER",

    "CREATEDBY" : "LABEL",

    "DUEDATE" : "DATE",

    "PROCESSID" : "LABEL"

  }

}

I am trying to get data with filtered query. for that I am using following query and data.

Type : POST

URL :  /server/queries/definitions/{queryName}/filtered-data

Params :

queryName : getAllTaskInputInstancesWithVariables

mapper : UserTasksWithVariables

builder : [blank]

page : 0

pageSize : 10

body/QueryFilterSpec: ?

Here I am not sure which content required as a body to get response based on specific parameter names and value. I also have tried some parameters like java API but unfortunately I didn't get output.

It is optional field but to get specific data we must pass that information.

Can anyone help me out what I need to put in body/QueryFilterSpec to get specific data based on that parameter name and value?

Your efforts are appreciated. Thanks in advance.

[pnairatl]

This is a sample request body

{

"order-by" : "saleDate, country",

"order-asc" : false,

"query-params" : [ {

"cond-column" : "processInstanceId",

"cond-operator" : "BETWEEN",

"cond-values" : [ 1000, 2000 ]

}, {

"cond-column" : "price",

"cond-operator" : "GREATER_THAN",

"cond-values" : [ 800 ]

}, {

"cond-column" : "saleDate",

"cond-operator" : "BETWEEN",

"cond-values" : [ {"java.util.Date":1454281200000}, {"java.util.Date":1456786800000} ]

}, {

"cond-column" : "productCode",

"cond-operator" : "IN",

"cond-values" : [ "EAP", "WILDFLY" ]

} ],

"result-column-mapping" : {

"PRICE" : "double",

"PRODUCTCODE" : "string",

"COUNTRY" : "string",

"SALEDATE" : "date",

"QUANTITY" : "integer"

}

}

[nikhil.mehta]

Hello Prasanth,

I have received the response. It worked perfectly. Thank you so much and I really appreciate the quick response.