Queries not showing aggregated group members configured in Agent field format

[lexiclevenger]

Describe the bug If the Determiner field is formatted to show an aggregation of group members, the Query builder only shows the configured separators instead of the group members. On the Determination form, the field formatter works as expected:

---

To Reproduce Steps to reproduce the behavior:

1. Go to App Resources -> Record Formatters

2. Click Load File and upload this: DataObjFormatters copy.txt

3. Add a new Determiner agent to a Determination record and set the Agent Type value to Group

4. Add multiple agents to the Members subview and save the records

https://kubirds20240606-v7962.test.specifysystems.org/specify/view/agent/3512/

4. Go to the Query Builder and query for that record
5. Add the field Determination -> Determiner -> (formatted) to the mapping
6. Run the query and see that the group members are not returned

---

Expected behavior The Determiner -> (formatted) field should return the information like this:

---

Screenshots

https://kubirds20240606-v7962.test.specifysystems.org/specify/view/collectionobject/129537/

Specify 7 System Information - 2024-10-31T21_56_38.034Z.txt

Please fill out the following information manually:

• OS: Mac
• Browser: Chrome
• Specify 7 Version: production and earlier
• Database Name: KUBirds_2024_06_06
• Collection name: Ornithology
• User Name: spbirdadmin
• URL: https://kubirds20240606-v7962.test.specifysystems.org/specify/query/39/

Reported By: @sorosoro on Discourse

[specifysoftware]

This issue has been mentioned on Specify Community Forum. There might be relevant details there:

https://discourse.specifysoftware.org/t/table-format-and-aggregation-for-agent-groups/2001/4