Hi, I am building a portal and wish to be able to filter on all the different filters available in the “Table” portlet. I fetch my data via a flow and I wonder how to set it up so that, for example, you can filter on all the options you have in the date column? Unfortunately, I don’t think it’s clearly stated in the help section.
How to set up:
BR, Viktor
Hi, you could use onRowSelected as the filter type and then you have all the options.
(as you then would for example put your variable in the where clause, and can use “between” or whatever logic you like)
Hi, I don’t quite understand what you mean.
Aren’t these the ones I should be using?
I have many columns, and I want to be able to filter all of them.
So the question is, how do I set it up so that I have the ability to filter using all the different options available?
BR,
Viktor
Hi,
The “pagination and filtering” would only be needed if you need to send a “next page” command to your data source. Which in reality means REST or Odata.
It sounds like you have a database as a data source, so then I would advise to NOT use the pagination and filtering (which you set up when creating the data source workflow in the image below, the image shows the setting turned on since it is from the training material, but just to show what I mean).:
Not using pagination and filtering, but using a onRowSelection filter gives you the option to pre-filter on something and use it in the where clause, like this:
.And in the where clause then you can use “between” or whatever logic you need, similar to what you do inside of the table (from the columns).
Be aware though, that you then limit the data set, so if you would pre-filter on order no 5 for example, that would be the only row in your table.
If you do the self paced training we have there is a chapter on this. (web.edapp.com, let me know if you need a login)
