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

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

  • July 21, 2020
  • 2 replies
  • 1705 views

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

Best answer by slangley

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

2 replies

S
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

S
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

Terms & ConditionsAccessibility statement