Ansible jobs on nested host groups

I have some nested host groups, for example I have a Databases host group with a mysql and Postgres host group below it. When I configure an Ansible job to run on the Databases host group no hosts are included in the job.

Expected outcome:
Configuring an Ansible job to run on the Databases host group would include all hosts in the mysql and Postgres host groups.

Foreman and Proxy versions:
Foreman version

Foreman and Proxy plugin versions:
Not sure what plugin versions are relevant to this problem

Distribution and version:
Rocky Linux 8.7

Other relevant data:

I’m not familiar with the Foreman Ansible plugin, but I assume you have to put in some kind of search query there, like with all kinds of remote execution.
What you are looking for is most likely a search query like hostgroup_title ~ database. hostgroup_title is the full name of a hostgroup, including the full parent hostgroup path. ~ is the “like” or “contains” operator in searches, and “database” is what I assume is your databse hostgroup name.With that query, you would get all hosts in both “databse/postgres” and “databse/mysql”.
Maybe the manual also has some more helpful info to you. Just leaving the link in case don’t know it yet.