Page Comparison

...

https://github.com/folio-org/folio-analytics/wiki/Cookbook:-General#6-using-cte-to-prepare-data-to-use-them-in-queries

The functionality of derived tables could also be replaced with FUNCTIONS.

1.7.9 Derived Table for Metadb	Keep or Retire in Metadb v 1.4?	Document in Wiki?	Notes
agreements_custom_property.sql	Retire	Yes	custom properties will be extracted into columns
agreements_package_content_item.sql
agreements_subscription_agreement.sql
agreements_subscription_agreement_entitlement.sql
agreements_subscription_agreement_org_ext.sql
feesfines_accounts_actions.sql
finance_budgets.sql
finance_funds.sql
finance_invoice_transactions.sql
finance_transaction_invoices.sql
finance_transaction_purchase_order.sql
holdings_administrative_notes.sql
holdings_electronic_access.sql
holdings_ext.sql
holdings_notes.sql
holdings_statements.sql
holdings_statements_indexes.sql
holdings_statements_supplements.sql
holdings_statistical_codes.sql
holdings_tags.sql
instance_administrative_notes.sql
instance_alternative_titles.sql
instance_classifications.sql
instance_contributors.sql
instance_editions.sql
instance_electronic_access.sql
instance_ext.sql
instance_formats.sql
instance_identifiers.sql
instance_languages.sql
instance_nature_content.sql
instance_notes.sql
instance_physical_descriptions.sql
instance_publication.sql
instance_relationships_ext.sql
instance_series.sql
instance_statistical_codes.sql
instance_subjects.sql
instance_tags.sql
invoice_adjustments_ext.sql
invoice_adjustments_in_addition_to.sql
invoice_lines_adjustments.sql
invoice_lines_fund_distributions.sql
invoice_voucher_lines_fund_distributions.sql
item_administrative_notes.sql
item_circulation_notes.sql
item_effective_callno_components.sql
item_electronic_access.sql
item_ext.sql
item_notes.sql
item_statistical_codes.sql
item_tags.sql
items_holdings_instances.sql
licenses_custom_property.sql
licenses_license_ext.sql
loans_items.sql
loans_renewal_count.sql
loans_renewal_dates.sql
locations_libraries.sql
locations_service_points.sql
openaccess_checklists.sql
openaccess_publication_request.sql
openaccess_works.sql
po_acq_unit_ids.sql
po_instance.sql
po_line_fund_distribution_transactions.sql
po_line_vendor_reference_number.sql
po_lines_cost.sql
po_lines_details_subscription.sql
po_lines_er_mat_type.sql
po_lines_eresource.sql
po_lines_fund_distribution_transactions.sql
po_lines_locations.sql
po_lines_phys_mat_type.sql
po_lines_physical.sql
po_lines_tags.sql
po_lines_vendor_reference_numbers.sql
po_ongoing.sql
po_organization.sql
po_prod_ids.sql
requests_items.sql
runlist.txt
users_addresses.sql
users_departments_unpacked.sql
users_groups.sql
agreements_custom_property.sql
agreements_package_content_item.sql
agreements_subscription_agreement.sql
agreements_subscription_agreement_entitlement.sql
agreements_subscription_agreement_org_ext.sql
feesfines_accounts_actions.sql
finance_budgets.sql
finance_funds.sql
finance_invoice_transactions.sql
finance_transaction_invoices.sql
finance_transaction_purchase_order.sql
holdings_administrative_notes.sql
holdings_electronic_access.sql
holdings_ext.sql
holdings_notes.sql
holdings_statements.sql
holdings_statements_indexes.sql
holdings_statements_supplements.sql
holdings_statistical_codes.sql
holdings_tags.sql
instance_administrative_notes.sql
instance_alternative_titles.sql
instance_classifications.sql
instance_contributors.sql
instance_editions.sql
instance_electronic_access.sql
instance_ext.sql
instance_formats.sql
instance_identifiers.sql
instance_languages.sql
instance_nature_content.sql
instance_notes.sql
instance_physical_descriptions.sql
instance_publication.sql
instance_relationships_ext.sql
instance_series.sql
instance_statistical_codes.sql
instance_subjects.sql
instance_tags.sql
invoice_adjustments_ext.sql
invoice_adjustments_in_addition_to.sql
invoice_lines_adjustments.sql
invoice_lines_fund_distributions.sql
invoice_voucher_lines_fund_distributions.sql
item_administrative_notes.sql
item_circulation_notes.sql
item_effective_callno_components.sql
item_electronic_access.sql
item_ext.sql
item_notes.sql
item_statistical_codes.sql
item_tags.sql
items_holdings_instances.sql
licenses_custom_property.sql
licenses_license_ext.sql
loans_items.sql
loans_renewal_count.sql
loans_renewal_dates.sql
locations_libraries.sql
locations_service_points.sql
openaccess_checklists.sql
openaccess_publication_request.sql
openaccess_works.sql
po_acq_unit_ids.sql
po_instance.sql
po_line_fund_distribution_transactions.sql
po_line_vendor_reference_number.sql
po_lines_cost.sql
po_lines_details_subscription.sql
po_lines_er_mat_type.sql
po_lines_eresource.sql
po_lines_fund_distribution_transactions.sql
po_lines_locations.sql
po_lines_phys_mat_type.sql
po_lines_physical.sql
po_lines_tags.sql
po_lines_vendor_reference_numbers.sql
po_ongoing.sql
po_organization.sql
po_prod_ids.sql
requests_items.sql
runlist.txt
users_addresses.sql
users_departments_unpacked.sql
users_groups.sql
STOP
agreements_custom_property.sql
agreements_package_content_item.sql
agreements_subscription_agreement.sql
agreements_subscription_agreement_entitlement.sql
agreements_subscription_agreement_org_ext.sql
feesfines_accounts_actions.sql
finance_budgets.sql
finance_funds.sql
finance_invoice_transactions.sql
finance_transaction_invoices.sql
finance_transaction_purchase_order.sql
holdings_administrative_notes.sql
holdings_electronic_access.sql
holdings_ext.sql
holdings_notes.sql
holdings_statements.sql
holdings_statements_indexes.sql
holdings_statements_supplements.sql
holdings_statistical_codes.sql
holdings_tags.sql
instance_administrative_notes.sql
instance_alternative_titles.sql
instance_classifications.sql
instance_contributors.sql
instance_editions.sql
instance_electronic_access.sql
instance_ext.sql
instance_formats.sql
instance_identifiers.sql
instance_languages.sql
instance_nature_content.sql
instance_notes.sql
instance_physical_descriptions.sql
instance_publication.sql
instance_relationships_ext.sql
instance_series.sql
instance_statistical_codes.sql
instance_subjects.sql
instance_tags.sql
invoice_adjustments_ext.sql
invoice_adjustments_in_addition_to.sql
invoice_lines_adjustments.sql
invoice_lines_fund_distributions.sql
invoice_voucher_lines_fund_distributions.sql
item_administrative_notes.sql
item_circulation_notes.sql
item_effective_callno_components.sql

...

Versions Compared

Old Version 5

New Version 6

Key