Lists do not currently support shared definitions (say like Assays do). Each list in each folder is a separate table belonging to one container, so your container filter strategy won't work.

You could consider

* use a UNION query
* create a table using a file-based module https://www.labkey.org/wiki/home/Documentation/page.view?name=sqlScripts
* keep the list in one folder (e.g. /shared) and have other folders all point to the same list.

Matt