cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

What is best for generating periodic reports like daily, weekly , monthly etc

VaibhavShinde
16-Pearl
16-Pearl
‎Jul 23, 2020 07:59 AM
‎Jul 23, 2020 07:59 AM

What is best for generating periodic reports like daily, weekly , monthly etc

Hi,

I am confused about what should i prefer to generate reports in thingworx, Javascript or SQL query(as i am using Database)? i have to generate reports based on  input like in below image.. 

 

VaibhavShinde_1-1595505194630.png

VaibhavShinde_0-1595505116873.png

if we choose javascript then how can i compare these inputs or how i can filter data based on input like month and year? i know there is Query param for query service but in query param where  can i put this month & year? 

 

Thanks,

Labels:
0 Kudos
Notify Moderator
0 REPLIES 0
Announcements