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

[VaibhavShinde]

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..

thanks

[slangley · Accepted solution]

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]

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