Skip to main content
10-Marble
May 9, 2022
Solved

Not Equal filter of info table query is not working.

  • May 9, 2022
  • 1 reply
  • 5471 views

var query2 = {
"filters":
{
"type": "OR",
"filters": [{
"type": "NE",
fieldName: "name",
value:"ConsolidatedInfoFiles"
},
{
"type": "NE",
fieldName: "name",
value:"Health Summary"
},
{
"type": "NE",
fieldName: "name",
value:"Shiftwise Melt Consumption"
},{
"type": "NE",
fieldName: "name",
value:"Shiftwise Energy Consumption"
}
]}
};
var params1 = {
t: infoIT /* INFOTABLE */,
query: query2 /* QUERY */
};
var result = Resources["InfoTableFunctions"].Query(params1);

Best answer by dev_1827

I found the solution. NE filter will work with AND filter thats the reason NE filter didn't work with OR (Demorgans law-¬(PQ)¬(PQ)

1 reply

15-Moonstone
May 9, 2022

Can you provide more information? I.e. how your data looks like? What is the expected and what is the actual result?

dev_182710-MarbleAuthor
10-Marble
May 9, 2022

input is info table. we are query the infotable based on name .the result is also a info table

15-Moonstone
May 9, 2022

I mean the content of the infotable. You try to query data with the above mentioned filter. What is the result? Do you get to many rows or none? Can you provide a specific example? Then it would be possible to reproduce the scenario.