searching for purchase orders using line item detail attributes can fail

[Galen Charlton]

Consider an acquisitions search that looks like this:

record type to retrieve: purchase orders
search filter: LID - Fund = /a valid fund/

Attempting a search like this will result in a DATABASE_QUERY_FAILED. Under the hood, the query passed to open-ils.cstore.json_query.atomic would be:

{"from":{"acqpo":{"acqlid":{"type":"inner"}}},"order_by":{"acqpo":{"id":{}}},"limit":15,"select":{"acqpo":[{"transform":"distinct","column":"id"}]},"offset":0,"where":{"-and":[{"+acqlid":{"fund":"457"}}]}}

However, this fails with a "Unable to construct JOIN clause(s)" exception as there is no direct join between acqpo and acqlid. The expected result would returning POs that have line item details that use the selected fund, adding a join on jub.

Evergreen 2.7 (also confirmed in 2.10)

[Erica Rohlfs (erohlfs)]

I set the importance at Medium, because this is affecting the user's ability to successfully search POs based on the fund.

[Tiffany Little (tslittle)]

Noting that I no longer see this bug happening in the new Acq Search in 3.6.