Skip to content
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

Automatically create CollectionObjectGroupType records #6013

Open
grantfitzsimmons opened this issue Dec 23, 2024 · 0 comments
Open

Automatically create CollectionObjectGroupType records #6013

grantfitzsimmons opened this issue Dec 23, 2024 · 0 comments
Labels
1 - Enhancement Improvements or extensions to existing behavior

Comments

@grantfitzsimmons
Copy link
Member

Is your feature request related to a problem? Please describe.
There are no CollectionObjectGroupType records out of the box, which makes it so you cannot create a CollectionObjectGroup record.

Describe the solution you'd like
Automatically, and for all collections, there should be at least two types created:

  • Consolidated
  • Discrete

The records should appear as follows, with the Agent of the user who created the collection inserted where appropriate:

INSERT INTO collectionobjectgrouptype (COGTypeID, Name, Type, Version, TimestampCreated, TimestampModified, CollectionID, CreatedByAgentID, ModifiedByAgentID) 
VALUES (1, 'Consolidated', 'Consolidated', 0, NOW(), NOW(), 4, 1661, null);

INSERT INTO collectionobjectgrouptype (COGTypeID, Name, Type, Version, TimestampCreated, TimestampModified, CollectionID, CreatedByAgentID, ModifiedByAgentID) 
VALUES (2, 'Discrete', 'Discrete', 1, NOW(), NOW(), 4, 1661, null);

(Drill Core can be created by the user if needed (or only for Geology collections))

Describe alternatives you've considered
Users can create these records themselves, but it is unintuitive and adds another barrier to usage.

@grantfitzsimmons grantfitzsimmons added the 1 - Enhancement Improvements or extensions to existing behavior label Dec 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
1 - Enhancement Improvements or extensions to existing behavior
Projects
None yet
Development

No branches or pull requests

1 participant