How to build Dynamic Query with Groups?

In this case, "Container" refers to Docker containers, not the Orion.Container entity (aka Groups). Your dynamic query is looking for Docker containers, which is why it doesn't find any of your groups.

Unfortunately, you can't build a dynamic query to populate a group the way you want. However, you can use the SWQL query below to collect the contents of all of your NYC% groups. Then, you can use this query to populate a custom query or custom table resource.

select FullName
, Status
, DetailsUrl as _LinkFor_FullName
, ContainerMembers.Container.Name as ContainerName
from Orion.ContainerMembers
where ContainerMembers.Container.Name like 'NYC%'
order by FullName