what the title says...
Here's where my head is at.. my app has a classic report with a bunch of rows. For illustration, let's imagine its a "select * from products".
I want to add a Favorite button on EVERY ROW to the classic report, so that EVERY USER can have their own stored list of product favorites. I think i can get that done by ensuring that the button click saves to a DB table that tracks UserID->ProductID.
I'm also intuitively thinking that i should be creating a comma delimited storage for this, so that it is easy to use in a WHERE clause, like:
select * from Products WHERE ProductID IN (111, 222, 333, etc etc)
Then on some button click, i want to dynamically add the IN Filter to the Classic Report's SQL Source attributes.
Any help how I can go about doing this?
=============
I also have a Faceted Search region supporting the classic report.. it feels "inefficient" to subquery the Favorites table for every row in the main classic report query.. maybe i'm overthinking this.. is there an efficient query that will light up Favorites as a facet?