Data filter for a list of numbers.

[svisveswaraiya]

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.

[PaiChung]

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

[svisveswaraiya]

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.