COT catalog number formats not formatted properly in query builder

[emenslin]

Describe the bug
Introduced in #5485, if you have at least 2 different COT with different catalog number formats, if you query the catalog number without filtering by COT, the non default format is formatted like the default format. If you filter the query to sort the Cat # by the non default COT all results are then formatted properly.

To Reproduce
Steps to reproduce the behavior:

1. Make at least 2 different COT with different cat # formats (or find a db with this already)
2. Make sure each COT has a CO record
3. Go to queries -> CO as base table
4. Query on the cat # and COT -> name
5. See results are all formatted with default format
6. Add 'equal' filter on cat #
7. Press the gear and select a non default format
8. Query
9. See results are all formatted based on their correct format

Expected behavior
Query results should always appear with their correct format

Screenshots
In this db paleontology is the default COT

01-16-2025__11-44.mp4

Please fill out the following information manually:

• OS: Windows 11
• Browser: Chrome
• Specify 7 Version: production
• Database Name: ojsmnh
• Collection name: fossil invertebrates
• User Name: spadmin
• URL: https://ojsmnh110242024production-production.test.specifysystems.org/specify/query/188/

[emenslin]

Duplicate of #6239