Preferred Taxon Queries do not include Taxa without a Preferred Taxon

[alesan99]

Describe the bug If you make a Taxon Query with Preferred Taxon it sometimes does not display the Taxa without a defined 'Preferred Taxon'

To Reproduce Steps to reproduce the behavior:

1. Ensure you have a Taxon without a Preferred Taxon and one that does have one.

2. Make a new Query matching the screenshots below OR import one of these: SynonymizedTaxaSwitch.json prefTaxon.json

3. Run the Query and look at the results

4. Switch the order of the Query field lines

5. Run the Query and see if the results changed

Expected behavior The query results should still show Taxa without any Preferred Taxon, regardless of the order of the Query fields. Specify 6 handles this well.

Screenshots Undesired result: Switching the order fixes it

Results on Specify 6 (Using the order from the first screenshot):

Please, also fill out the following information manually:

• OS: Windows 11
• Browser: Chrome
• Specify 7 Version: edge
• Database Name: kubirds_8_25_23
• User Name: spbirdadmin

[combs-a]

It's specifically when the Preferred Taxon query is of a specific rank. (any rank) seems to work as normal.

i.e. when a query has (any rank) -> Preferred Taxon -> Rank -> etc...

[emenslin]

Can recreate in edge (7.9.6)

[lexiclevenger]

Eyal from hujinnhc reported that Determination queries with Taxon and Preferred Taxon also return results for rank fullName incorrectly. The results for EITHER the Taxon OR Preferred Taxon table will appear in both columns depending on which table appears first in the mapping.

Specify 7 results:

Specify 6 results: