GDC tables aggregating row values instead of listing

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

3. Validate query
4. Click OK.
5. In Page Explorer, add a List, use Query from previous steps, and add Data Items from query.
6. Run report.
7. 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