Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Knowledge Articles
    4. GDC tables aggregating row values instead of listing

    GDC tables aggregating row values instead of listing

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Symptoms
    2. Defect Status
    3. Replication steps
    • 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

    View article in the Exlibris Knowledge Center
    1. Back to top
      • GDC services will not start
      • GDC: "Connection Refused", "Failed to retrieve saved searches", "Failed to load existing record sets" and other error messages
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Voyager
    2. Tags
      1. voy-unresolved
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved