cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Filter infotable data based on input values like month=6, year=2019

VaibhavShinde
16-Pearl

Filter infotable data based on input values like month=6, year=2019

Hi,

i am looking to filter data based on input month and year, please tell me how can we do it using query parameter in thingworx.? i have timestamp column as below..

VaibhavShinde_0-1595350577977.png

 

 

 

thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Hi VaibhavShinde.

 

If you're expecting to run it at runtime, you could use the filter widget.  If you're trying to filter before passing it to the mashup, you can build your query as detailed here. The timestamp should be formatted as epoch time.

 

Regards.

 

-Sharon

View solution in original post

2 REPLIES 2

Hi VaibhavShinde.

 

If you're expecting to run it at runtime, you could use the filter widget.  If you're trying to filter before passing it to the mashup, you can build your query as detailed here. The timestamp should be formatted as epoch time.

 

Regards.

 

-Sharon

slangley
23-Emerald II
(To:slangley)

Hi VaibhavShinde.

 

If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.  If you are still having issues, please let us know.

 

Regards.

 

--Sharon

Top Tags