Currently there is complex joins etc.. as well as functionality ot generate linked item summaries. THis could probably be better served by storing it in the DB as a view as a number of these different views are used multiple times. This would also better support having the lists be sortable / filterable by this aggregate information.
Currently there is complex joins etc.. as well as functionality ot generate linked item summaries. THis could probably be better served by storing it in the DB as a view as a number of these different views are used multiple times. This would also better support having the lists be sortable / filterable by this aggregate information.