Generated aggregate fields

[pgr]

Maybe something like this

Subpanels Cases

Let me try giving you a copy of a different example. My advice is to first try to get my example working as it is, without changing anything; only after it’s working you try and adapt it to your requirement, ok? Create this file custom/Extension/modules/Accounts/Ext/Layoutdefs/Leads.php with these contents: <?php $layout_defs["Accounts"]["subpanel_setup"]['leads'] = array( 'order' => 80, 'module' => 'Leads', 'sort_order' => 'asc', 'sort_by' => 'first_name, last_name', 's…

You can make your own SQL query. It’s for a subpanel, I am not sure if it will work on List views, probably yes.

This should make all the hard processing be handled by MySQL, and everything will be done with one JOIN query for all rows, instead of a separate query per row. this should probably bring the performance into acceptable levels.