Hi, I strongly suspect that reporter.simple_record having multiple rows when a bib has multiple series statements is just an oversight and that the intention is that there be exactly one rsr row per bib. Certainly (IMO) having the possibility of more than one row in that view per bib would make that view less than "simple".
Regards, Galen On Fri, Dec 12, 2025 at 3:43 PM Josh Stompro via Evergreen-dev < [email protected]> wrote: > Hello, I was just writing some sql reports and used for > reporter.simple_record instead of reporter.super_simple_record just to try > it out. This was for a top titles of 2026 report which counts circulation. > > After some tinkering I switched back to reporter.super_simple_record as a > method of pulling in the title, and noticed that my stats changed. > > I finally figured out that reporter.simple_record will give multiple rows > for any bib that has multiple series entries. I'm just curious if that is > just expected for that view, and it isn't for use in reports? Having > multiple entries for a bib must not matter for it's normal usage. > > Thanks > Josh > > [image: Company logo] > *Josh Stompro* > *IT Director * > [email protected] | 218-233-3757 ext. 139 > *Lake Agassiz Regional Library* > 118 5th ST S > Moorhead MN 56560 > www.larl.org > *Our mission is to enrich lives and strengthen communities.* > _______________________________________________ > Evergreen-dev mailing list -- [email protected] > To unsubscribe send an email to [email protected] > -- Galen Charlton Implementation and IT Manager Equinox Open Library Initiative [email protected] https://www.equinoxOLI.org phone: 877-OPEN-ILS (673-6457) direct: 770-709-5581 <http://evergreen-ils.org>
_______________________________________________ Evergreen-dev mailing list -- [email protected] To unsubscribe send an email to [email protected]
