Hi Karen,

That one's my report, and I was puzzling how to do it without a right join. If this bug were fixed, we could come at it from the Item source: https://bugs.launchpad.net/evergreen/+bug/1988430

But since it's currently not, if right joins aren't supported in the Angular reporter then I'm not sure how else to create it. :\

Tiffany



logo with link to Georgia Public Library Service website

Tiffany Little

PINES Bibliographic Projects Manager


Georgia Public Library Service

2872 Woodcock Blvd, Suite 250 | Atlanta, GA 30341

(404) 235-7161 | tlittle@georgialibraries.org


logo with link to Georgia Public Library Service Facebook pagelogo with link to Georgia Public Library Service Instagram pagelogo with link to Georgia Public Library Service LinkedIn pagelogo with link to Georgia Public Library Service Threads page


Join our email list for stories of Georgia libraries making an impact in our communities.



On Thu, Apr 10, 2025 at 4:11 PM Karen Young via Evergreen-acq <evergreen-acq@list.evergreen-ils.org> wrote:
Hello -- I semi-regularly use the "orphaned barcodes" report to locate items that are no longer associated with a viable PO (I copied my report set-up from the PINES report on the acq wiki). This report uses nullability -- specifically right joins. It works great in the legacy reporter. However, the new reporter doesn't appear to allow right joins:
image.png
I can run my old report in the new reporter, but I cannot clone it to make changes -- it fails to run and I'm pretty sure the debugging info indicates it's related to the join type. Does anybody have suggestions/ideas to make right joins work in the new reporter? Or how to retool this report to work in the new reporter?

Best wishes,
Karen

Karen Young (she, her, hers)
Manager of Cataloging & Acquisitions
140 E. Jefferson Ave.
Kirkwood, MO 63122
314-821-5770 x1014
_______________________________________________
Evergreen-acq mailing list -- evergreen-acq@list.evergreen-ils.org
To unsubscribe send an email to evergreen-acq-leave@list.evergreen-ils.org