How to query form infotable using query function?

[akesana]

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

[Michail]

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 */

};

[akesana]

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 */,

  query: query  /* QUERY */

};

Thanks

Anil Kesana

Re: How to query form infotable using query function?

[Michail · Accepted solution]

var query =

{

  "filters": {

  "type": "OR",

  "filters": [

  {

  "type": "EQ",

  "fieldName": "Duration",

  "value": "12"

  },

  {

  "type": "EQ",

  "fieldName": "Duration",

  "value": "20"

  }

  ]

  }

};

[akesana]

Thank you so much Mundel got it

Thanks,

Anil Kesana