How to Pass filter condition to "Data table" widget dynamically?

[ManideepN]

Hi all,

I am trying to pass filter condition dynamically from "Data table form" widget to "Data table" widget.I am giving the filter condition from "Data table form" as object and retrieving those values in "Data table" widget. But when I see it passing a null value to "Data Table" widget don't know why. In that widget I see that it's an encoded filter. Check the attachments provided how it's going on and let me know if you had any queries also.

Can any one help me out how to pass the filter condition dynamically to "Data table" widget.

Thanks in advance

Regards,

Manideep Nadimpelli.

[Shambhu5]

Hi,

Are you using OOTB widget called Data Table from Instance Definition ?

If so, then in order to filter, why aren't you using Instance Option, and then specify your Table, filter and fields query? (instead of coding)

- Vishrut 

[ManideepN]

I need put different filter conditions based on the query. 

Thanks,

Manideep Nadimpelli.

[Shambhu5]

Hi Manideep,

Have you tried creating Instance Option for Data Table from Instance Definition Widget? We can query and add filters through that too. 

As in my case I had to use a query of Active is true for my Change Request. please find below screen-shots and steps to reproduce the same.

1. You clone the widget and add it to your page

2. Now click on Edit button  (pencil icon)

3. Instance Option dialog will get open

4. Fill all the values such as table, filter, fields, etc

5. Save it

Now you will be able to see your filtered query, as I have configured for Change. Please find below image:

Please mark my answer as Correct/Helpful if that helped you anyhow.

Regards,
Vishrut

[manmathpanda]

Hi virshut,

Could you help me in this widget , how can we set the filter readonly means noone can edit anything on this filter and apart from this filter he can create a new filter there according to his need.

Please suggest if it can be done.