Skip to main content
E
etc61-Visitor
1-Visitor
August 28, 2019
Solved

Use of a DataFilter widget

  • August 28, 2019
  • 2 replies
  • 4238 views

Hello guys,

 

I have an external Oracle database and it's no problem to show queried information (using a service for that of course)  inside a grid in a mashup. But how do I filter the information in this grid (InfoTable)?

 

I would like to know how to use a DataFilter widget on an InfoTable.

Could someone provide code (inside the different services) plus bindings?

I found tutorials for the bindings and different code snippets but never a complete, well explained, tutorial.

 

Thanks in advance

 

 

Best answer by rjanardan

As I understand you already have a service that returns all data in an Infotable(as expected) from an external DB. 
One approach would be to not bind this data directly to a grid and instead feed this as input to a second service which will do the actual filtering. 

 

Features for this new service 

1. Input:Two. 1 of type infotable based on same data shape of the infotable in your existing service and 2 of type query

2. Output: Infotable based on same data shape of the infotable in your existing service

3. Code: Use snippet Resources -> Infotable functions -> Query. Edit the code with your Input variable names chosen (infotable and query)

In mashup,

  1. Add new service but it should not be called on mashup loaded
  2. bind:
  • service invoke completed event of your service to new service
  • query from Data Filter widget to query parameter of new service
  • returned data from your first service to data of data filter widget & input infotable of new service
  • output infotable of new service to Grid
  • changed event of Data Filter widget to new service

2 replies

V
vangne16-Pearl
16-Pearl
August 28, 2019

@etc6 Have you checked this information? It also contains a video tutorial which may help.

1. Which Thingworx version you are using?

2. Also, did you try filtering the information in the grid and received any error?

 

Thanks,

Vibhuti

E
etc61-VisitorAuthor
1-Visitor
August 28, 2019

Hey,

the provided information doesn't help a lot and the tutorial is good for the bindings but it does still not work.

 

1. ThingWorx 8.2.6-b456

2. When I try filtering I get this error:

org.json.JSONObject cannot be cast to java.lang.String

 

Here is a screen of my service and my bindings:

 

 

 

V
vangne16-Pearl
16-Pearl
August 28, 2019

@etc6 

1. Have you tried replacing the [[...]] with <<...>>>?

2. Have you tested with the INPUT parameter of type String instead of JSON?

 

You may refer this article to get an idea on opType / dataType

 

Thanks,

Vibhuti

R
rjanardan16-PearlAnswer
16-Pearl
August 28, 2019

As I understand you already have a service that returns all data in an Infotable(as expected) from an external DB. 
One approach would be to not bind this data directly to a grid and instead feed this as input to a second service which will do the actual filtering. 

 

Features for this new service 

1. Input:Two. 1 of type infotable based on same data shape of the infotable in your existing service and 2 of type query

2. Output: Infotable based on same data shape of the infotable in your existing service

3. Code: Use snippet Resources -> Infotable functions -> Query. Edit the code with your Input variable names chosen (infotable and query)

In mashup,

  1. Add new service but it should not be called on mashup loaded
  2. bind:
  • service invoke completed event of your service to new service
  • query from Data Filter widget to query parameter of new service
  • returned data from your first service to data of data filter widget & input infotable of new service
  • output infotable of new service to Grid
  • changed event of Data Filter widget to new service
E
etc61-VisitorAuthor
1-Visitor
September 4, 2019

Hello,

 

I appreciate your help and I think your given solution

led me to the right direction but I still have a little problem.

 

I've created the new sevice and put the script inside as you said to do.

But the problem is that I don't know how I can acces the Inputparameters with the script.

I changed the names and tried various thing but I either get an NullPointerException

 

(08:48:15 ERROR - Error in invoking service Things_POC_ATBB_CHILD_CONNECTOR, GetPRwithoutCCR, Things, POC_ATBB_CHILD_CONNECTOR, Services, GetPRwithoutCCR. Error from the server: "Error executing service GetPRwithoutCCR. Message :: Wrapped java.lang.NullPointerException - See Script Error Log for more details.")

 

or my table in the mashup remains empty when I do the filtering.

I also tried to acces the properties direct but then I get this error

 

09:24:42 ERROR - Error in invoking service Things_POC_ATBB_CHILD_CONNECTOR, GetPRwithoutCCR, Things, POC_ATBB_CHILD_CONNECTOR, Services, GetPRwithoutCCR. Error from the server: "Error executing service GetPRwithoutCCR. Message :: TypeError: Cannot read property "RPT" from undefined - See Script Error Log for more details." 

 

which tells me again that I have no acces to the Infotableparameter.

 

The filter has problems to get basic data it needs for filtering. 

 

As I said I tried various thing (changed bindings, changed code) but I don't get this filtering done.

 

Any ideas?

 

 

 

 

 

 

 

 

R
rjanardan16-Pearl
16-Pearl
September 4, 2019

If your initial service is returning data properly as an infotable there is no reason for this approach to not work. 


I hope you have not set the new service(GetPRwithoutCCR?) to be invoked upon Mashup load(Mashup loaded checkbox). Your new service has to be triggered only after your service to fetch data from DB has completed execution. Otherwise, the infotable input would be null. 

Terms & ConditionsAccessibility statement