Skip to main content
VaibhavShinde16-Pearl
16-Pearl
July 21, 2020
Solved

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

slangleyAnswer
Support
July 21, 2020

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 in thread

2 replies

slangleyCommunity ManagerAnswer
Support
July 21, 2020

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

Translate
slangleyCommunity Manager
Support
August 3, 2020

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

Translate
Terms & ConditionsAccessibility statement