Filter drawer from primary table filter

  • 1
  • Question
  • Updated 4 years ago
I have an aggregate table on the Opportunity object that groups opportunities by sales reps (custom obj) and sums the Amounts of their opportunities. I then have a drawer to show each opportunity and some details about each. On the main table I also have a filter to show totals based on the opportunities Stage. So (Example) we see on the main table Brad Jones (sales rep) has $100,000 in opportunities accross all stages but if we filter the stage to only show Closed Won we see he only has $25,000 in "Closed Won" opportunities. What I want is to, at this point, open the drawer and it show only the opportunities that are "Closed Won". How do I accomplish this?
Photo of Megan Vaughan

Megan Vaughan

  • 872 Points 500 badge 2x thumb

Posted 4 years ago

  • 1
Photo of Irvin Waldman

Irvin Waldman, Champion

  • 9,006 Points 5k badge 2x thumb
Sorry, I am not really following but are you familiar with Before Load actions? Maybe they can help.

http://help.skuidify.com/m/components...
Photo of Rob Hatch

Rob Hatch, Official Rep

  • 44,006 Points 20k badge 2x thumb
Meghan,  this is actually not easily possible today.  You can't build a filter on model A and have it impact the items in the drawer contained within it that actually shows data from model B. 

Pat has posted some code about cross model conditions (where condition on model A affects model B)  but I cannot guarantee it will be effective in this case.  https://community.skuidify.com/skuid/topics/cross-model-linked-conditions
Photo of Megan Vaughan

Megan Vaughan

  • 872 Points 500 badge 2x thumb
Thank you Rob-- that is exactly what I was looking for. Bummer