Equivalent of "where exists" with subselect in IFS Cloud

A rather common case for saved queries and start pages in older versions are queries like "all shop orders for inventory parts with safety code S". In IFS EE, this can be done with a "where exists" sql clause and a subselect query. Is there a way to do this type of filtering in an IFS Cloud page? It can be done in a lobby element, but I can't get navigation to work since I cannot make the same filtering in the target page.