Open grantfitzsimmons opened 3 months ago
This issue has been mentioned on Specify Community Forum. There might be relevant details there:
https://discourse.specifysoftware.org/t/querying-taxon-group-number/1198/2
Duplicate of https://github.com/specify/specify7/issues/2364?
@melton-jason Yes. You have no idea how many issue titles I searched on... going to merge the details of that into this one rather than the other way around.
This request has been approved by Taylor at the Florida Museum of Natural History. Here is the additional clarification of the issue they are facing:
I can show you the differences we’re experiencing more concisely:
In Sp6, this query, when filtered on Family Group Number:
Yields:
That same query in Sp7 won’t run, as the mapping doesn’t translate and results in an showstopper error. The Not Mapped is the Family Group Number in sp6:
So, if I eliminate that field from the query, and then add the Any -> Group Number, I get no results:
So, it seems that when you filter using Any, it returns results for, in this case, the Group Number on Family, only results for determinations that would be made to the Family that had the Group Number, not a child of it, like a determination made to a child Genus->Species.
So, making Group Number queryable directly on the Family would solve this. The issue you submitted encapsulates this and I thank you greatly for it.
The same issue reported by Taylor is causing an issue with this query defined in Specify 6:
{
"tableList": "1,9-determinations,4",
"stringId": "1,9-determinations,4.taxon.Family groupNumber",
"fieldName": "Family groupNumber",
"isRelFld": false,
"sortType": 0,
"position": 2,
"isDisplay": true,
"operStart": 11,
"startValue": "",
"isNot": false
}
As described in https://github.com/specify/specify7/issues/4697#issuecomment-2025741314, you can only search on "Author" and "Full Name" at a given rank, therefore Specify 7 is unable to successfully execute the query. If we extended support to searching on groupNumber
, that would solve this case, but we should do it more generalized if possible.
It looks like Name, Author, and Group Number are explicitly defined as special tree fields in Specify 6 here:
This issue has been mentioned on Specify Community Forum. There might be relevant details there:
https://discourse.specifysoftware.org/t/querying-specific-field-for-a-specific-taxonomic-rank/1822/1
I have a similar issue as Querying taxon group number
In our latest collection we assigned several new fields to taxa on Species level.
I would like to retrieve some of them in one of my queries. Though, when constructing a collection object query, I am unable to specify species taxonomic rank and still select these fields. The only options are Author, Full Name and ID.
I can see that the related GitHub ticket 2 is soon to be closed, but it seems to only solve that specific case (group number support), not in general. Any hope to tackle the general issue as well? ( Add support for querying on any tree table field from a chosen rank 2)
Reported by Zsuzsanna at NHMD
This issue has been mentioned on Specify Community Forum. There might be relevant details there:
https://discourse.specifysoftware.org/t/querying-specific-field-for-a-specific-taxonomic-rank/1822/2
Is your feature request related to a problem? Please describe. Currently in Specify 6 and 7 there is no ability in the query builder to search on any arbitrary field in the tree table once you select a specific rank.
Current Behavior
At (any rank)
See that all fields and relationships are exposed in the list of fields to choose from
The
stringid
s are constructed as you'd expect:At {Rank} level
Only
author
andfullName
can be chosen from the list of fields once you select a level in the tree.The
stringid
s associated with these rank-specific query items are unusual. They are formatted as follows:It looks like there is special logic handling these
treeNodeCols
when constructing a string ID for these items.Describe the solution you'd like
Currently, users can only choose two fields at any given tree rank:
Users should be able to select any rank in a tree (e.g. Family, Genus, Species, etc.) and select any field in the tree table at that level.
Instead of seeing only these two fields:
You should see this:
The list of fields should be comprehensive, including
Author
,Common Name
,Full Name
,GUID
,Is Preferred
,Name
,Protected Status
,Remarks
,Source
.Reported By Louisiana State University Museum of Natural Science, University of Washington, University of Florida, CSIRO, University of Kansas, many others
Initially reported in #2364
@grantfitzsimmons:
@maxpatiiuk said the following in this comment:
Last march I asked for that code to be removed but no forward movement has occurred since that discussion.
Issues to Resolve: