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
Hi,
I have a list that displays n no. of vehicle numbers.
I wanted to add a data filter which displays this list.
I have a service to display the list (table from sql).
How to implement a query property for this case?
I dont understand from where to call implementingthingwithdata.
Please provide some solutions on how to proceed this case.
I wanted to display this set of serial numbers using data filter.
Thanks,
V.Shalini.
If this is directly coming from an SQL database, you can just write an SQL Query for it.
Usually what I do with more complex queries I use one regular Thingworx service to create the SQL Query as a string and then I execute it with a Thingworx SQL Query Service using << >> for String substitution.
Please remember that when using string substitution you must apply proper security to protect against sql injection
If it is a fixed service then you can just wrap this service with another Thingworx Service that applies the Query to the infotable
Hi Pai chung,
Is it possible to give query as a property?
I mean how to bind the data to generic query property history?
Please provide some guidance.
Thanks,
V.Shalini.