Inconsistent display for -to-many relationship fields in table formats/query combo box

Format:
Here is the Reference Work format as I have described it in Specify itself:

    <format
        name="ReferenceWork"
        title="ReferenceWork"
        class="edu.ku.brc.specify.datamodel.ReferenceWork"
        default="true"
        >
        <switch single="false" field="referenceWorkType">
            <fields value='0'> <!--Book-->
                <field>authors</field>
                <field sep=", ">workDate</field>
                <field sep=", ">title</field>
                <field sep=", ">placeOfPublication</field>
                <field sep=", ">publisher</field>
            </fields>
            <fields> <!--Anything else-->
                <field>authors</field>
                <field sep=", ">workDate</field>
                <field sep=", ">title</field>
                <field sep=", ">publisher</field>
            </fields>
        </switch>
    </format>

When the Reference Work record is a book (Llibre) it would be formatted as:
authors, workDate, title, placeOfPublication, publisher

If it is any other type, it would use the following formatter:
authors, workDate, title, publisher

Output: (Shown in Query Builder)

Formatted correctly!

López González, Pablo José, 11/2020, A new calcaxonian genus and family for Trichogorgia utinomii Cordeiro, 2019 (Octocorallia, Alcyonacea): new records of a scleriteless gorgonian species from Antarctica

Output: (Shown on form and query combo box)
https://mcnb.specifycloud.org/specify/view/referencework/303/

Oddly enough, when looking up a record, it uses the properly formatted name:

Screen.Recording.2023-07-31.at.9.22.07.AM.mov

But you cannot search on the authors since the TypeSearch definition does not allow for that to happen.

11/2020, A new calcaxonian genus and family for Trichogorgia utinomii Cordeiro, 2019 (Octocorallia, Alcyonacea): new records of a scleriteless gorgonian species from Antarctica

Reported By: MCNB

v7.8.13, mcnb, macOS, Firefox

@realVinayak

@realVinayak asked me to try this on v7.9-dev. See below:

The same issue is happening here

Describe the bug The desired format of the ReferenceWork field is not respected after the record is added to the citation form. The format displays correctly when searching and in query results, but the field reverts to the default display order after being added to the form. The table formats are set in schema config for CO citation, Taxon citation, and the Reference Works table.

To Reproduce Steps to reproduce the behavior: Test Panel Database: mcnb_7_31_23

Open a new Collection Object or Taxon record

Open the Citation subview (icon on CO and subform on Taxon)

Search in the referencework field (Cita bibliofràfica) and add a citation

Save form

See error in changed formatting of field

Expected behavior referencework field should display according to the defined format on the forms.

Screenshots If applicable, add screenshots to help explain your problem.

format is correct in queries on the Reference Work table:

format is correct in queries on the CO table ONLY when (formatted) for CO is mapped to the query as well:

Screen.Recording.2023-10-04.at.11.00.42.AM.mov
adding a citation to the form:

Screen.Recording.2023-10-03.at.1.35.49.PM.mov

From #4064 (comment)

Jordi from MCNB has requested an update on the timeline of resolving this for his database.

Can recreate in edge (7.9.6)

Navigation Menu

Repository navigation

Inconsistent display for -to-many relationship fields in table formats/query combo box #3868

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Inconsistent display for -to-many relationship fields in table formats/query combo box #3868

Description

Activity

grantfitzsimmons commented on Jul 31, 2023

melton-jason commented on May 29, 2024

bronwyncombs commented on May 31, 2024

emenslin commented on Aug 5, 2024

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions