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

    GDC tables aggregating row values instead of listing

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

    Problem Symptoms:
    * Query Studio & Report Studio showing some kind of calculated value instead of individual row values for RECORD_SET and RECORD_SET_RECORDS tables

    Cause:
    This behavior is the result of VYG-6392.

    Resolution:
    Issue VYG-6392 is currently in Development.

    Additional Information

    Replication steps:
    1. Open Report Studio > Database Schema package > Create New > Blank
    2. In Query Explorer, create new Query & add simple SQL query. For example:
    SELECT *
    FROM RECORD_SET_RECORDS
    3. Validate the query and click OK.
    4. In Page Explorer, add a List, use Query from previous steps, and add Data Items from query.
    5. Run report.
    6. Report should output rows showing record_ids and related information for GDC record sets records, but instead outputs a few values that don't match values in the database. For example:
    RECORD_SET_ID RECORD_ID RECORD_SET_BULK_NUM
    117 1,436 1
    117 23,520 1
    117 33,152 1
    117 49,311 1
    117 53,815 1
    (But there is no record_set_id=117 in this database.)
    7. Similar output using Query Studio.

    Category: (Voyager Analyzer)

    Subject: Voyager


    • Article last edited: 11/26/2014