
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