Skip to main content
May 9, 2022 10:45 AM UTC
Solved

Not Equal filter of info table query is not working.

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);

dev_1827Answer
Dec 20, 2022 10:28 AM UTC

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

11 replies

May 9, 2022 10:53 AM UTC

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

dev_1827Author
May 9, 2022 10:57 AM UTC

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

May 9, 2022 11:03 AM UTC

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.