Records not showing in data type while report definition returned results
Hi All,
I'm trying to update existing data records but there is no record showing on the data type. I'm 100% sure that we do have records stored because I ran a report definition that belongs to that class and was able to pull out results.
A few things I've tried:
1. Add record and save. As soon as I save it, the record disappeared. RD returned my newly added record
2. Export - empty excel
3. search existing record value using the search bar under Export Import button
Can anyone help me out to make those records appear?
Thanks,
Sue
Accepted Solution
Updated: 26 Aug 2022 15:50 EDT
Capgemini
GB
The records editor is sourced by the autogenerated report definition: DataTableEditorReport. This is autogenerated for every data class that is configured to map to a local table.
Please check that this report is returning results when you run it.
Sometimes developers edit this report and add filters to it instead of creating a new report, doing this will break the records editor.
Booz Allen Hamilton
US
Hi Joe,
Thanks for the quick response. Yes I've ran that DataTableEditorReport RD which did return results (please see my "RD results" screenshot attachment). The issue is not about RD not returning results, it's about data type records is empty while we have instances stored.
Thanks,
Sue
Booz Allen Hamilton
US
Finally understood what you are saying! Yes! it is because the previous developer edited this default RD by adding a filter to it. The data type now displaying records after I remove the filter from DataTableEditorReport.
Thank you so much!
Sue
Infosys Limited
IN
Check the db table mapped to this data class and observe if there are records. If yes, the issue is with the Pega datatype where you need to do the revalidate and save the data class.
Booz Allen Hamilton
US
Yes, there are records. May I ask what type I should be doing revalidate and save?
I've tried revalidate and save both DATA-ADMIN-DB-TABLE and RULE-OBJ-CLASS, did not solve the problem.
Although there was an issue when I tested the database table connectivity. It's complaining that the data table has 2 concrete classes mapped to (see attachment). I'm wondering if that's the cause of records not displayed - since both data types are experiencing the same issue where we have records but they are not displayed.
could that be why I'm not seeing any records?