[Column Filter] how to add filter to multiple columns

[Column Filter] how to add filter to multiple columns

  
Forge Component
(5)
Published on 2014-10-22 by André Vieira
5 votes
Published on 2014-10-22 by André Vieira

I am trying to put filter on more than one column in a table record, can you  help me make it work.

I am able to get single filter working but when i put multiple filter, how to get the data based on both the filters?

Hi Monica,


Can you share a sample .oml of what you're trying to achieve?


Best regards,

Davide Résio

Monica Jain wrote:

I am trying to put filter on more than one column in a table record, can you  help me make it work.

I am able to get single filter working but when i put multiple filter, how to get the data based on both the filters?


Hi Monica,

 you can use multiple filter in your aggrigate to achieve this like below.


 

Monica Jain wrote:

I am trying to put filter on more than one column in a table record, can you  help me make it work.

I am able to get single filter working but when i put multiple filter, how to get the data based on both the filters?

Monica,


I've attached a sample .oml for this component.

Basically what I did was just add a few more filters to the sample .oml provided by the component itself.

After you add the widget to the columns you want to filter, you just need to retrieve the input information of each widget using the function ColumnFilter_Get(WidgetName.Id) in the aggregate that's feeding data to the table.



Hope this helps. 

Best regards,

Davide Résio