F
Filament•2mo ago
Reaper8911

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.
Solution:
The is_deleted got me. It was blank but not null.
Jump to solution
5 Replies
Dennis Koch
Dennis Koch•2mo ago
Is deleted_at actually NULL? Can you share the old columns?
Reaper8911
Reaper8911•2mo ago
When the data was imported, that column had no values for any of the records.
CyQuer
CyQuer•2mo ago
The column probably has ‘’ as its value. So it is an empty string. However, it must be NULL for it to be recognised correctly.
Dennis Koch
Dennis Koch•2mo ago
But what does it look like in the db?
Solution
Reaper8911
Reaper8911•2mo ago
The is_deleted got me. It was blank but not null.
Want results from more Discord servers?
Add your server
More Posts
Manipulation on uploaded image before saveAs a a bit advanced step (for me) in learning Filament I wanted to build a system which will a new aHow to get and use current model of view page within a widget?```protected function getData(): array { $currentModel = ...? //... }``` I want t load statTable custom query, where from request path.I have a table with sub-entities. I wan't to display only limited list of sub-entities based on paraSlow Initial Page Load Time Despite Cache Clearing and Setting in Filament DemoIssue: When attempting to clear and set the cache for the Filament demo on GitHub, there persists a Problem in uploading large files after publishing the applicationA problem in uploading files if they are large in size and have been uploaded to hostingDuplicate Query in Resource Navigation BadgeI don't know why this results in two queries to fetch the count.Open a information modal on Resource StartupHi! How can I display a modal with information or warning when the Resource starts up? For example,Action not working in livewire componentmy actions button shown but can't perform anything this is my code Inside of my class page ```php cget form processing stateHi 👋 I have an action modal that loads for a few seconds. I just need to get the current form's pa cell with a zero value is not displayed, even when formattingthe following code does not work: ```php TextColumn::make('is_notifications_allowed') ->label('N