Steve, The HTML output of every report has a link at the top (intentionally made dimmer than others) that says "Debugging Info". If you click that, you'll see the actual SQL that ran.
Your problem comes from this path: Circulation -> Item :: Circulations That goes from one circ (presumably your target), to the item, and then to all the circs that item has had, adding a row for each to the output. Without more information I couldn't say if that path is actually needed for the report you want to produce, but from the description I would suspect it's not. HTH, -- Mike Rylander | President | Equinox Open Library Initiative | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@equinoxinitiative.org | web: http://equinoxinitiative.org On Tue, Mar 20, 2018 at 8:04 AM, swills beyond-print.com <swi...@beyond-print.com> wrote: > Chris asked me to post this problem. It was surprising to me that he gets > the report results that he does. As an aside, i'd like to be able to see > the report writers actual query at some point. Is there a debug trap for > that? Anyway, here is his problem. > > > have an interesting Evergreen “Reports” issue. > > I want an “overdues” report where: > > 1. I want to name the library > > 2. I want a range of Overdue/Due Dates > > 3. For everything that isn’t checked in. > > The problem I am having is that the report seems to add additional records > (with later Due dates) to the report. > > I built a report with these Base Filters. > > [overduereportfailure1.jpg] attached shows a pic of the reportwriter filters > used. > > But, when I run the report, I get “extra records” (Due dates in the future). > In the following case, I asked for a range of Mar 16 to Mar 16. But I got > two “extra” items. > > [overduereportfailure2.jpg] attached shows a pic of unexpected result report > rows > > > We looked at one of the items (“Princess Stories, etc.) in the database and > found this: > > [overduereportfailure3.jpg] attached shows psql select of the item > asset.copy rows for the princess story item. > > As you can see, this item has two transactions. The first, has a “null” > check In Date/Time. The second has a due date of 2018-03-16. > > Logically, I understand why this item might be included. But how can I > filter out items like this?? > > Steve says: I don't see why the items that don't satify all of the filters > were included? suggestions? > > Thanks > > >