Table format and aggregation for Agent Groups

Get Help
1

For determiners, I am using the determiner field in the determination table. When there are multiple determiners, I create a group and add each determiner as a member of the group.

Then, I configured the Record Formatters for the Agent table to be conditional to the agent type, so that when it is a group, the aggregated Group Members are shown:

3
31435×967 58.6 KB

This works well in the form, which shows the group members aggregated as expected:

1
1703×235 15 KB

But the query results table does not show the aggregated determiners:

2
21682×444 37.2 KB

Maybe the problem is in the configuration of the Record Formatters for the Group Person table. This I what I did:

Table aggregation:

4
4726×755 31.8 KB

Table format:

7
71172×642 35.1 KB

As the last screenshot shows, I used the field Member for the table format. There is also the field Group:

5
51183×688 42.1 KB

But the field Group does not seem right because it gives no option to show Members, which in the end is what I want to show:

6
61184×690 40.7 KB

What am I missing?

2

Hi sorosoro,

Could you please download and send us your Record Formatters App Resource file so we can investigate this further? You can either reply to this comment or send us an email at support@specifysoftware.org. Thanks!

3

Hi @lexiclevenger6. Here is my Record Formatter xml.
DataObjFormatters.xml (22.3 KB)
Cheers.

4

Hello,

There is no issue with how you set up your Record Formatters. Instead, this seems like a bug; the query you created should display the Determiner field as it appears on the Determination form. I have written up a bug report on GitHub to notify the developers of the issue: Queries not showing aggregated group members configured in Agent field format · Issue #5363 · specify/specify7 · GitHub.

If you would like to avoid this issue, there is a “Determiners” one-to-many relationship that can be rendered as a subview on the Determination form instead of the Determiner field. This relationship allows you to add multiple Determiner agents without the need to create a Group.

Here is what you might add to your Determination form definition:

    <row>
      			<cell type="subview" viewname="Determiners" id="9" desc="Authorization" name="Determiners" colspan="12"/>
    </row>

You can learn more about editing forms here: Editing Forms in Specify 7.

Thank you for bringing this to our attention!

1 Like
5

Hi @lexiclevenger6, thanks for looking into this.

I wish I could use the Determiners table instead of using the determiner field with groups of agents for cases when there are several determiners. But the Determiners table cannot be accessed in the workbench from the Collection Object table. This is still an open issue (Support nested -to-many relationships in WorkBench · Issue #2331 · specify/specify7 · GitHub).

I decided to use the determiner field in the Determination table to avoid having to do a separate import for the determinations, but using groups of agents for multiples determiners is not ideal, it makes the import file a bit complicated. I am actually considering a simple text field for the determiners, at least until this is sorted.

Cheers.
Soraya

6

3 posts were split to a new topic: Move Determiner to Determiners