Posted: 25 Jan 2019 16:27 EST Last activity: 30 Jan 2019 15:58 EST
Data table's existing records are gone after re-arranging the columns
We have a data table called SADataTitle which holds some information in regards to user titles. There was one column which we re-arranged in action -> edit columns by drag and dropping the field to which we wanted to move the location to. Once we moved the field to a new location, all the records we had in the data table became missing/not shown. When we tried to add the records again, we get a error message stating that the records are pre-existing.
How do we get back our records to show in the data??
***Edited by Moderator Marissa to update platform capability tags****
The issue was resolved, few of the field was not a date property type(text type) so the report definition was not able to correct filter based on validity dates. Once I removed the filter condition for validity dates, all the records reappeared. I did not know the datatype records are filtered based on a report in the datatable.