possible to write a SQL statement that searches current container plus child containers?

LabKey Support Forum (Inactive)
possible to write a SQL statement that searches current container plus child containers? jeckels  2011-06-03 13:15
Status: Closed
 
Hi Ben,

We don't have a way to specify a container filter inside of a custom query. However, we've done work in the past and I recently made an improvement in 11.2 so that if you set a container/folder filter on the view, it should get propagated into the query and respected by the various subqueries. So, I think that your suggested alternative should work as you intend, at least in 11.2.

Thanks,
Josh