Database Import Issue
I've created a site using Filament and imported some data from my old database into a table. My issue is, the list page doesn't show any of the data. If I create a new items, they show in the table along with the imported data and on the list page. Any ideas?
Found something odd. I’m using soft deletes and the imported data has no date in that column but is showing on the list page as soft deletes records.
5 Replies
Is
deleted_at actually NULL? Can you share the old columns?When the data was imported, that column had no values for any of the records.
The column probably has ‘’ as its value. So it is an empty string. However, it must be NULL for it to be recognised correctly.
But what does it look like in the db?
Solution
The is_deleted got me. It was blank but not null.