Evergreen

Wrong Join Type In Acq Lineitem Detail Causes Inaccurate Reports

Bug #1702489 reported by Chris Sharp
24
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Evergreen
Confirmed
Low
Unassigned

Bug Description

The Line Item Detail reporting source offers the wrong type of nullability when nullability selection is enabled and the user selects the Evergreen Copy ID link (offers "Parent" but should be "Child"). This is because the fieldmapper assumes a "has_a" relationship between acqlid and acp when it should be a "might_have".

Branch on the way.

Evergreen 2.11.1-ish
OpenSRF 2.4.1
PostgreSQL 9.4
Ubuntu 14.04 LTS

Tags: acq reports
Revision history for this message
Chris Sharp (chrissharp123) wrote :

Branch here:

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/csharp/lp1702489_acqlid_to_acp_wrong_reltype

Revision history for this message
Chris Sharp (chrissharp123) wrote :

After deploying the change in the above branch in PINES production, I can confirm that it causes an error when activating purchase orders. The problem reported here remains unsolved.

Changed in evergreen:
assignee: Chris Sharp (chrissharp123) → nobody
Chris Sharp (chrissharp123)
Changed in evergreen:
status: New → Confirmed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.