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.

Sign up for GitHub

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

Jump to bottom

ERM - Add new tables for refdata to derived table "agreements_custom_property" #792

Open
stdombek opened this issue Aug 16, 2023 · 1 comment · May be fixed by #824
Open

ERM - Add new tables for refdata to derived table "agreements_custom_property" #792

stdombek opened this issue Aug 16, 2023 · 1 comment · May be fixed by #824
Assignees
@stdombek
Labels
enhancement New feature or request ERM Electronic Resources Management
Milestone
1.8

Comments

@stdombek
Copy link
Contributor

stdombek commented Aug 16, 2023 •
edited
Loading

There are new additional tables that need to be added to the derived table agreements_custom_property.

  • "custom_property_refdata" with their "refdata_value"

agreements_custom_property
LEFT JOIN folio_agreements.custom_property_refdata ON custom_property_refdata.id = agreements_custom_property.id
LEFT JOIN folio_agreements.refdata_value ON refdata_value.rdv_id = custom_property_refdata.value_id
@stdombek stdombek added enhancement New feature or request ERM Electronic Resources Management labels Aug 16, 2023
@kitokirti
Copy link

Hi @stdombek , I would like to work on this. Please assign this to me.

@stdombek stdombek added this to the 1.8 (Quesnelia) milestone Oct 17, 2023
@stdombek stdombek assigned stdombek and unassigned kitokirti Feb 16, 2024
@stdombek stdombek changed the title ERM - Add new tables to derived table "agreements_custom_property" ERM - Add new tables for refdata to derived table "agreements_custom_property" Feb 16, 2024
@stdombek stdombek linked a pull request Feb 16, 2024 that will close this issue
Open
@stdombek stdombek removed this from the 1.8 milestone Aug 21, 2024
@stdombek stdombek added this to the 1.8 milestone Nov 13, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@stdombek stdombek

Labels
enhancement New feature or request ERM Electronic Resources Management
Projects
None yet
Milestone
1.8
Development

Successfully merging a pull request may close this issue.

Added columns for custom reference data for agreements stdombek/folio-analytics
2 participants
@kitokirti @stdombek