-
Notifications
You must be signed in to change notification settings - Fork 38
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Add support for querying on any tree table field from a chosen rank #4697
Comments
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 #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:
|
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 #4697 (comment), 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 |
It looks like Name, Author, and Group Number are explicitly defined as special tree fields in Specify 6 here: |
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:
The text was updated successfully, but these errors were encountered: