Skip to content

Refactor table alias to reflect the table name #460

@rmathew1011

Description

@rmathew1011

During review of the Shelflist Holdings query workflow, it was noted that some table aliases do not match their underlying table names.

            + '\n\t\tLEFT JOIN folio_reporting.holdings_statements hold_state ON holdings_ext.holdings_hrid = hold_state.holdings_hrid'
            + '\n\t\tLEFT JOIN folio_reporting.items_holdings_instances item_hold_in ON holdings_ext.instance_id = item_hold_in.instance_id'
            + '\n\t\tLEFT JOIN item_detail item_detail ON holdings_ext.holdings_id = item_detail.holdings_id';
var from = 'folio_inventory.holdings_record__t__ holdings_ext'
Should we have the query table alias reflect the table name refactor?

Update all SQL queries in the codebase so table aliases match their table names

  • Refactor hegis-po workflow query

  • Refactor Evans Pres Repr workflow query

  • Refactor create notes workflow query

  • Refactor Shelflist item workflow query

  • Refactor Shelflist holdings query

  • Refactor Print Serials workflow query

  • Refactor Rapid Prinit Monos workflow query

  • Refactor Rapid Electronic Monos workflow query

  • Refactor Nbs item note workflow query

  • Refactor Item History Update workflow query .

  • Refactor Hegis Purchase Order workflow query

  • Refactor coral extract workflow query

  • Refactor Hathitrust workflow query

  • Refactor GOBI workflow query

  • Refactor Duplicate Instance Report workflow query

  • Refactor Circ-fines workflow query

  • Refactor Books-call-number workflow query

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions