Skip to main content
November 8, 2022
Solved

Filter Selected and Unselected in grid

  • November 8, 2022
  • 4 replies
  • 0 views

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.

Best answer by mikes0011

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.

4 replies

stefanhelzle0001
Brainy
November 8, 2022

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
November 8, 2022

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
November 8, 2022

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
November 8, 2022

Thanks, this approach works [emoticon:6d505171faa4497c85c5ca27290c555d]