List View Custom Script

Hi all,

I have Doctype A that has a child table, and Doctype B that has a field Linked to Doctype A.

How can I write a custom script so that in the List view of Doctype B, someone can select the Field (In filters) that links to Doctype A and add/show data from the childtable of Doctype A?

The official docs dont provide much help/guidance on List Views Scripts.
Any help is greatly appreciated.
Thanks

Try to create a query report. You can write the simple SQL query to achieve the same.

Hey, I agree, but my client wishes for the user to stay on the Doctype B list page, instead of accessing reports.