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

    GDC tables aggregating row values instead of listing

    • Product: Voyager
    • Product Version: 9

    Symptoms

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

    Defect Status

    Issue VYG-6392 is currently in Development.

    Replication steps

    1. Open Report Studio > Database Schema package > Create New > Blank
    2. In Query Explorer, create new Query & add simple SQL query. Example:
    SELECT *
    FROM RECORD_SET_RECORDS
    
    1. Validate query
    2. Click OK.
    3. In Page Explorer, add a List, use Query from previous steps, and add Data Items from query.
    4. Run report.
    5. Report should output rows showing record_ids and related information for GDC record sets records. Instead outputs a few values that don't match values in the database. 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.)

    Similar output using Query Studio.


    Article last edited: 06-Nov-2017

    //Feedback