Skip to main content
Nintex Community Menu Bar
Solved

Using an aggregated model in a Table with a Drawer

  • July 11, 2024
  • 1 reply
  • 0 views
  • Translate

Forum|alt.badge.img+3

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 by Rob_Clough

Thanks, this was perfect

View original
Did this topic help you find an answer to your question?

Forum|alt.badge.img+17

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

Translate

Forum|alt.badge.img+3

Thanks, this was perfect

Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings