Skip to main content
Known Participant
Nov 8, 2022 6:57 PM UTC
Solved

Filter Selected and Unselected in grid

Is there a way to filter a grid on the rows that you selected or have not selected.

Use case being if your grid is really large and data are on multiple pages. When you go through pages selecting items, maybe you want to filter by selected items to see all the items you've selected?

Is there a way to make a selected filter? Not sure if this can be a user filter.

mikes0011
mikes0011Answer
Brainy
Nov 8, 2022 8:19 PM UTC

my favorite way to handle this usually involves constructing some sort of read-only display below the grid that summarizes the items you've selected.  if you want to get fancy, this could also be made to allow de-selecting items as well.

The Expression Guru

4 replies

stefanhelzle0001
Brainy
Nov 8, 2022 7:58 PM UTC

You will need to build a query that just returns the items with their ID in a list of already selected IDs. That is easy to do, but not as a user filter.

ericm0013Author
Known Participant
Nov 8, 2022 8:20 PM UTC

So I won't be able to have this as a dropdown filter above the grid like the user filters. Would probably go above/outside of the grid field object

mikes0011
mikes0011Answer
Brainy
Nov 8, 2022 8:19 PM UTC

my favorite way to handle this usually involves constructing some sort of read-only display below the grid that summarizes the items you've selected.  if you want to get fancy, this could also be made to allow de-selecting items as well.

The Expression Guru
ericm0013Author
Known Participant
Nov 8, 2022 8:29 PM UTC

Thanks, this approach works [emoticon:6d505171faa4497c85c5ca27290c555d]