Overview

In order to support querying for invoices based on acquisitions units, we need to create a view which joins the invoices and acquisitions_unit_assignments tables on:

invoices.id == assignments.recordId

The GET /invoice-storage/invoices endpoint should be updated to query this view instead of the invoices table directly. The response schema should still be a collection of invoices

Approach

Use the RMB method of view creation, e.g. see an example here

Acceptance Criteria

• The new view is created and used when querying invoices

• Unit tests are updated