Container search should allow searching by host.

Parent Issue

No response

User Story

As a user, I want to be able to search by host when adding a container to a template, so I can properly filter out containers from other sites if I have a long list of sites to search through.

For a customer example, they have a large number of sites, over 100, and they have used the same naming scheme for their containers across all their sites. One example being "All Pages | Pre-Footer". They are running into an issue now where the site they are on isn't at the top of the list or even included in the list and there is no pagination in the search either which has it's own Git issue here https://github.com/dotCMS/core/issues/30047

Acceptance Criteria

When adding a container to a template, the search bar should allow for searching the host of the containers as well as the container names.

Proposed Objective

User Experience

Proposed Priority

Priority 2 - Important

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

https://dotcms.freshdesk.com/a/tickets/29647

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response

Start by reviewing issue #30047 and tracing the container search flow used when adding a container to a template. Confirm how results are currently filtered by container name. Done means the same search also filters by host, as required by the acceptance criteria.