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 [image: logo with link to Georgia Public Library Service website] <https://georgialibraries.org/> Tiffany Little *PINES Bibliographic Projects Manager* ------------------------------ Georgia Public Library Service 2872 Woodcock Blvd, Suite 250 | Atlanta, GA 30341 (404) 235-7161 | tlittle@georgialibraries.org [image: logo with link to Georgia Public Library Service Facebook page] <https://www.facebook.com/georgialibraries>[image: logo with link to Georgia Public Library Service Instagram page] <https://www.instagram.com/georgialibraries/>[image: logo with link to Georgia Public Library Service LinkedIn page] <https://www.linkedin.com/company/georgia-public-library-service/>[image: logo with link to Georgia Public Library Service Threads page] <https://www.threads.net/@georgialibraries> Join our email list <http://georgialibraries.org/subscription> 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 w <https://wiki.evergreen-ils.org/doku.php?id=acq:reports>iki). 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: 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 Kirkwood Public Library <https://kirkwoodpubliclibrary.org/> 140 E. Jefferson Ave. Kirkwood, MO 63122 kyoung@kplmo.org <http://kyoung@kplmo.org/kyoung@kirkwoodpubliclibrary.org> 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
