Request - question about summary agent information

[happiah-madson]

Help us understand your request (check below):

• search or data request (help with SQL or provide the specific fields you are trying to retrieve for your collection)
• add a new Github user to the Arctos Users team
• a new barcode series
• a new term for data entry or management
• a change or new report or label
• update to an Agent (split, merge, or other type of change)
• bulkload changes (to Agents, Identifiers, etc that are not already available as a bulkloading tool)
• new feature or otherwise a good idea to make Arctos even better
• quarantine taxon name and suggested replacement (please supply links)
• API key request (see https://handbook.arctosdb.org/documentation/api.html for requirements)
• error or bug (please include enough specific information to reproduce)
• general inquiry (or email arctoscontact@googlegroups.com)
• access issue (see https://arctosdb.org/faq/)
• other

Describe what you're trying to do
I'm looking at agent summary information for a student so that I can summarize their work in the collection. There are 2 sections I have questions about:

This seems to be saying that the items that she collected are from 2030? While dope if true, the records don't show that information. They say they were collected in the much more feasible 2025. Am I misunderstanding this field?

For Catalog Records Entered, the data seems to be repeated? When I click on the two links, the records shown are the same set. What am I missing?

[dustymc]

misunderstanding

Yea - because the documentation has disappeared at some point...

The data come from this code, I can do something different but not rounding to ~decade is going to require more resources than I have:

arctosprod@arctos>> select
                            guid_prefix,
                            coalesce(round(year, -1)::text,'?') decade,
                            case 
                                when state_prov is not null then state_prov 
                                when country is not null then country 
                                else '?' 
                            end place,
                            collector_role,
                            count(*) cnt
                        from
                            collector
                            inner join filtered_flat on collector.collection_object_id=filtered_flat.collection_object_id
                        where
                            collector.agent_id=21360387
                        group by
                            guid_prefix,
                            decade,
                            place,
                            collector_role
                        order by
                            decade,
                            place,
                            guid_prefix
;
 guid_prefix | decade |     place     | collector_role | cnt 
-------------+--------+---------------+----------------+-----
 OGL:Genomic | 2030   | Massachusetts | collector      |   6
(1 row)

Maybe just needs some sort of documentation, but this comes from an API and the documentation should be in the API, not the UI, and that might also be more worms than anyone wants to deal with at the moment.

Entered

The top row is a summary, which is a bit redundant when there's only one collection involved. Not real sure what to do about that either....

From the other end of the spectrum....

[happiah-madson]

Dope, thanks for clarifying! That explains all the things.

[dustymc]

Tentatively moving to documentation...

[Jegelewicz]

Does anyone else think it's weird that 2025 winds up in the decade 2030?

[Jegelewicz]

The top row is a summary, which is a bit redundant when there's only one collection involved. Not real sure what to do about that either....

Instead of listing all the collections, just say "All Collections"?