Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    PPR: Error in Circulation Transactions by Dewey Decimal Classification

    • Article Type: General
    • Product: Voyager
    • Product Version: 7.0.4

    Problem Symptoms:
    ? Circulation Transactions by Dewey Decimal Classification report returns abnormally high number
    ? Due to the way MFHD_ITEM table is included, for each item charged, query counts number of items attached to item's MFHD, instead of counting 1

    Cause:
    This behavior is a result of Issue 16384-98.

    Resolution:
    Issue 16384-98 is currently in Development.

    Additional Information

    Replication Steps
    Query as delivered in reports.mdb:
    SELECT DEWEYCLASS_VW.CLASS AS Expr1, [start date] AS StartDate, [end date] AS EndDate, Count(CIRCCHARGES_VW.CHARGE_DATE_ONLY) AS CountOfCHARGE_DATE_ONLY
    FROM DEWEYCLASS_VW, MFHD_ITEM, CIRCCHARGES_VW
    WHERE ((([CIRCCHARGES_VW].[CHARGE_DATE_ONLY]) Between [start date] And [end date]))
    GROUP BY DEWEYCLASS_VW.CLASS, [start date], [end date];

    Workaround
    Use this query instead:
    SELECT DEWEYCLASS_VW.CLASS, [start date] AS StartDate, [end date] AS EndDate,
    Count(CIRCCHARGES_VW.CHARGE_DATE_ONLY) AS CountOfCHARGE_DATE_ONLY
    FROM CIRCCHARGES_VW INNER JOIN DEWEYCLASS_VW ON CIRCCHARGES_VW.MFHD_ID = DEWEYCLASS_VW.MFHD_ID
    WHERE (((CIRCCHARGES_VW.CHARGE_DATE_ONLY) Between [start date] And [end date]))
    GROUP BY DEWEYCLASS_VW.CLASS, [start date], [end date];

    Category: Prepackaged Rpts


    • Article last edited: 10/8/2013