Skip to main content
U
UY_95159471-Visitor
1-Visitor
August 25, 2020
Solved

Data Filter widget Query

  • August 25, 2020
  • 1 reply
  • 1471 views

Hi,

I am new to ThingWorx Environment.

I did some research on TW Community and based on that I Configured my DATA FILTER Widget.

I put the following codes in my Service:

var params = {
t: Things["SQL_Connection_Testing_DB_Udit"].sql_Output() /* INFOTABLE */,
query: Query /* QUERY */
};
// result: INFOTABLE
var result = Resources['InfoTableFunctions'].params.query;

 

Till now my assumption is that the Query from Data Filter widget will pass on to the input Query of my service and that query in turn will execute the DataTable which I provide under "t" Variable.

 

But somehow I am getting the following error :

Error executing service Service101. Message :: TypeError: Cannot read property "query" from undefined - See Script Error Log for more details.

 

i am guessing, i am doing something wrong with Service query part. DO I need to write any more query than what I mentioned earlier, If yes, Please help me with what kind of structure the query should follow, Considering I want filter 4 Column of Data ?

Please help me with this.

@raluca_edu @posipova @slangley 

 

Thanks in Advance

 

 

    Best answer by jensc

    Hello,

     

    In case someone comes across this post here is one way you can do what you want to achieve:

     

     

     

    // Provide your filter using the format as described in the help topic "Query Parameter for Query Services"
let query = {
 "filters": {
 "type": "EQ",
 "fieldName": "name",
 "value": "<name to filter>"
 }
};

let params = {
	t: "YourInfoTable" /* INFOTABLE */,
	query: query /* QUERY */
};

// result: INFOTABLE
let result = Resources["InfoTableFunctions"].Query(params);

     

     

     

    The query JSON would need to be modified to what you want to query of course. You can read more on how different queries can be built here.

     

    Regards,

    Jens

    1 reply

    J
    jensc17-PeridotAnswer
    17-Peridot
    April 25, 2023

    Hello,

     

    In case someone comes across this post here is one way you can do what you want to achieve:

     

     

     

    // Provide your filter using the format as described in the help topic "Query Parameter for Query Services"
let query = {
 "filters": {
 "type": "EQ",
 "fieldName": "name",
 "value": "<name to filter>"
 }
};

let params = {
	t: "YourInfoTable" /* INFOTABLE */,
	query: query /* QUERY */
};

// result: INFOTABLE
let result = Resources["InfoTableFunctions"].Query(params);

     

     

     

    The query JSON would need to be modified to what you want to query of course. You can read more on how different queries can be built here.

     

    Regards,

    Jens

    Terms & ConditionsAccessibility statement