Describe the bug

Queries mapped to Rank → Full Name (e.g. string ID 1,10,2,3.geography.Continent) previously showed the Name value, not the FullName value. We need to restore this behavior.

TL;DR: v7.10.2 changes the behavior for displaying tree "full name" values in queries. This causes issues with how queries and labels are displayed, but most importantly changes how data exports are presented.

If you want to show the formatted Geography for a Locality, you can do so by adding Geography (formatted), and this respects the full name construction configured in the geographytreedefitem table.

You can configure each rank to display only the name by removing all higher-level geography from the full name. However, this would eliminate the ability to use the formatted geography in forms, queries, and other areas of the software.

Despite the underlying string IDs for the query fields being the same between v7.10.1 and v7.10.2, the way the value is presented in the query builder and in exports has changed.

<field stringId="1,10,2,3.geography.Continent" oper="11" value="" isNot="false" isRelFld="false"/>
<field stringId="1,10,2,3.geography.Country" oper="11" value="" isNot="false" isRelFld="false"/>
<field stringId="1,10,2,3.geography.State" oper="11" value="" isNot="false" isRelFld="false"/>
<field stringId="1,10,2,3.geography.Sea Basin" oper="11" value="" isNot="false" isRelFld="false"/>
<field stringId="1,10,2,3.geography.County" oper="11" value="" isNot="false" isRelFld="false"/>

This remains the same between versions:

It is now showing the fullName value instead of the name value for the record. This is unlikely to be immediately obvious in cases like Taxon, but it makes a huge difference for Geography.

To Reproduce
Perform these steps in both v7.10.1 and v7.10.2 to see the expected behavior and the unexpected behavior:

1. Login to the spadmin user
2. Click on the Reports dialog
3. Select "Specimen Label"
4. Select a record set (e.g. "Problem Nos")
5. See that the labels no longer appear correctly.

Left: v7.10.1 Expected
Right: v7.10.2 Unexpected

You can test this in the query builder here: /specify/query/19/?recordsetid=1

Expected behavior
If a user selects a tree rank (e.g. "Genus", "Species", "State", "Country", or "Continent") in a query, they should only see the name of that node, not the fullName.

Reported By
Shell Museum