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:
Add record and save. As soon as I save it, the record disappeared. RD returned my newly added record
Export - empty excel
search existing record value using the search bar under Export Import button
Can anyone help me out to make those records appear?
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.
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.
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.
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.
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.
