Try ERPNext Buy Support Partners Foundation

Is it possible to override the query of a child table? How?

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?