Using an aggregated model in a Table with a Drawer

Hi All,

Is it possible to use an aggregated model in a Table Drawer that uses another aggregate model for Context?

The scenario is that we have opportunities that can be raised against multiple Site accounts so we want to display a summary of the opportunity product quantities and total prices by Site account. It's easy enough to product the tables but we want to be able to display the result using a drawer so that you see a list of Site Accounts and then if you expend a Site Account drawer it will show you the summarised opportunity data for that Site.

I have attached an image of the closest I can get but if I set the context of the drawer so that it matches on the 'Site account idr id' it doesn't display any results.

Many thanks,
Rob

Best Answer

Answers

  • I think I understand what you are trying to do.

    so the table would be based AggModel1.

    Each aggregation would be a row.

    Each row would have a row action. That row action would do three things:

    1) Activate and set condition on AggModel2 that limits the opportunities to just those of the Site Account in context from that row.

    2) query model AggModel2

    3) open a drawer displaying a table on AggModel2

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!