cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X

Data filter for a list of numbers.

svisveswaraiya
17-Peridot

Data filter for a list of numbers.

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.

2 REPLIES 2

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.

Top Tags