1-Visitor

Solved

How to query form infotable using query function?

Forum|Forum|8 years ago
June 8, 2017
1 reply
15211 views

Hi,

Could anyone help us to query from info table based on condition?

We found query info table function but need to know query syntax please send us sample syntax

Example:

var params = {

t: result1 /* INFOTABLE */,

query: what to write here and how /* QUERY */

};

// result: INFOTABLE

var result = Resources["InfoTableFunctions"].Query(params);

We want to check where condition like where name ='anil' and id=1

Thanks,

Anil Kesana

Design

Best answer by Michail

var query =

{

"filters": {

"type": "OR",

"filters": [

{

"type": "EQ",

"fieldName": "Duration",

"value": "12"

},

{

"type": "EQ",

"fieldName": "Duration",

"value": "20"

}

]

}

};

M

Michail

1-Visitor

look for "query parameter" in the documentation.

var query =

{

"filters": {

"type": "GT, LT, GE, LE, NE, EQ, LIKE, NOTLIKE",

"fieldName": "Duration",

"value": "12"

}

};

var params = {

t: result1 /* INFOTABLE */,

query: query /* QUERY */

};

A

akesana

Author

1-Visitor

Hi Mnudel,

Thanks for your quick response , but I want to check multiple conditions not single value.

Could you explain that ?

var query =

{

"filters": {

"type": "EQ",

"fieldName": "Duration",

"value": "12" and/or "20" //like this I want to check will it possible please send syntax for the same

}

};

var params = {

t: result1 /* INFOTABLE */,