I have a many to many to many situation.
Many actions can be performed on many widgets for many customers and warehouse locations.
When altering details of a widget it is useful to view actions taken on it. Having a separate report is ok, but having the report appear as a read-only child table would be better. The data is already recorded by actions elsewhere so there is no need to save redundantly to the child table doctype.
How can I fill the child table from a different query than the child table’s default query?
Ideally I would like this to happen on the server side, so:
Is there something like a server-side
onLoad() method on a doctype that allows the data retrieved from the database to be altered before it is passed on to the client-side?