Skip to main content
1-Visitor
September 9, 2019
Solved

Query "IN" filter

  • September 9, 2019
  • 2 replies
  • 1420 views

Trying to do exactly the same thing and I'm getting an issue.

 

I'm querying a datatable, and passing this query (below). If I run the QueryDataTable entries with this query, it returns no results. If I just change the Station parameter to be "EQ" and just add the machine name as a string, the query works as expected (returning 40+ results). 

 

What gives? What am I doing wrong?

 

 

 

 

 

var machineArray = ['my_machine_name'];

 

var query = {
"filters": {
"type": "And",
"filters": [
{
"type": "IN",
"fieldName": "Station",
"value": machineArray
},
{
"type": "EQ",
"fieldName": "Program",
"value": Transmission
},
{
"type": "EQ",
"fieldName": "Operation",
"value": Operation
}]}};

 

var myQueryResults = Things["Ford.PFS.GM.Historian.Repository"].QueryDataTableEntries({
maxItems: 200000 /* NUMBER */,
values: undefined /* INFOTABLE */,
query: query /* QUERY */,
source: undefined /* STRING */,
tags: undefined /* TAGS */
});

Best answer by slangley

Hi @ague.

 

Per the information in the case, it appears the issue was the result of a typo:

 

"filters": [

{

"type": "IN",

"fieldName": "Station",

"values": machineArray

},

 

If you are in agreement that this was the solution, please mark this response as the Accepted Solution for the benefit of others on the community.

 

Regards.

 

--Sharon

 

2 replies

Support
September 10, 2019

Hi @ague.

 

It appears that a case was created for this, so we will update the solution here once it is known.

 

Regards.

 

--Sharon

slangleyCommunity ManagerAnswer
Support
September 24, 2019

Hi @ague.

 

Per the information in the case, it appears the issue was the result of a typo:

 

"filters": [

{

"type": "IN",

"fieldName": "Station",

"values": machineArray

},

 

If you are in agreement that this was the solution, please mark this response as the Accepted Solution for the benefit of others on the community.

 

Regards.

 

--Sharon