Skip to main content
M
Muthu_chithira1-Visitor
1-Visitor
December 23, 2018
Solved

How to use Data filter in mashup? what is the service required?

  • December 23, 2018
  • 7 replies
  • 4233 views

First time am using this 'Data filter' widget.

I dont know how to use it

I saw video which is given in document.

There, they binding 'data filter-> query' to 'service' in thing.

 

Now my doubt is

what should i do in service? I must write SQL query? what query i have to use? 

What should i give input ? How to get input query?

Best answer by zyuan1

I don't know which version of TWX you're using, but it's quite clear to use it in TWX 8.3

 

You have a Filter widget, bind a infotable result from a service to it, and view mashup, you can then click on the Add Filter in the widget, and it will expand a list of propertis (from the infotable Datashape) to listen to.

 

Select any row, you'll know how to use the expressions. Then you can drag the Query field of the Filter widget to the service you get the Infotable data from in Data panel service list

 

 

 

7 replies

Z
zyuan15-Regular MemberAnswer
5-Regular Member
December 24, 2018

I don't know which version of TWX you're using, but it's quite clear to use it in TWX 8.3

 

You have a Filter widget, bind a infotable result from a service to it, and view mashup, you can then click on the Add Filter in the widget, and it will expand a list of propertis (from the infotable Datashape) to listen to.

 

Select any row, you'll know how to use the expressions. Then you can drag the Query field of the Filter widget to the service you get the Infotable data from in Data panel service list

 

 

 

S
slangleyCommunity Manager
Support
December 31, 2018

Hi @Muthu_chithira.

 

If the response provided by @zyuan1 helped to resolve your issue, please mark it as the Accepted Solution for the benefit of others with the same question.

 

Thank you for using our community!

 

Regards.

 

--Sharon

M
Muthu_chithira1-VisitorAuthor
1-Visitor
January 2, 2019

I made all the connections.

Trigger service through an event

But data is not filtering yet.

In service i wrote "Select * from table" query..

Should i change anything in query??

Terms & ConditionsAccessibility statement