Skip to content

"Age" field returns CollectionObjectID, should return useful information #6016

Description

@grantfitzsimmons

Describe the bug

Currently, adding the "Age" field to a query creates a column displaying the CollectionObjectID. This identifier is likely unfamiliar to users and may cause confusion in the interface. This is not a catalog number (identifiable) or any other useful information.

To Reproduce

Steps to reproduce the behavior:

  1. Build a "Collection Object" query in a paleo/invertpaleo/geology discipline's collection
  2. Add the "Age" field to the query
  3. Run the query
  4. See that the Collection Object ID is all that is shown in the results
image

Expected behavior

Show the full range computed by the back end for each CO

  • The backend currently search across 3 tables: relative age - absolute age and paleo context.
  • Each value coming from those tables, if any, is transform into a start date and en end date.
  • That new computed range is used to define which CO is returned or not.
  • The column for the virtual field 'Age' in the query result should return that computed range.
  • This could therefore be a different value for each line

Let say the user adds the age field in his mapping and use the range filter.
He enters the values 120 - 10 in his filter.
One CO in the db has those value for each age table once converted to range numbers:
Absolute age: 110 - 50
Relative age: 100 - 50
PaleoContext: 80 - 40
The maximum range for this CO is then defined to be 110 - 40.

==> This 110 - 40 should be the value displayed in the query result column

Metadata

Metadata

Assignees

Labels

1 - BugIncorrect behavior of the product2 - QueriesIssues that are related to the query builder or queries in generalgeospecify

Type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions