Accessing people result in `Cannot return null for non-nullable field FullName.lastName.`

While fetching getting error, Please check the below video issue explained deatiled- https://www.loom.com/share/94c606a366fd4cb89a95fff3a02edbf2
Loom
Error to fetch the data in twenty crm
In this video, I discuss the data we've saved in our system, specifically focusing on the 4,300 records we have in the
11 Replies
Abdullah M
Abdullah MOP2d ago
Hi twenty crm team I am waiting for your help!
Prastoin
Prastoin2d ago
No description
Prastoin
Prastoin2d ago
Hello @Abdullah M What does you twenty-server logs looks like ? Seems like you have a null lastname in db in your people's table
Abdullah M
Abdullah MOP2d ago
any way to drop all the people's table data???
Prastoin
Prastoin2d ago
If you do so you'll loose all your data If I was you I would change any fullname null value to either empty string or whatever placeholder
Abdullah M
Abdullah MOP2d ago
Actually I have 4000 records in people's table The people's table data not able to get the records to check which has null in lastName So how can i change null data to string in lastname Give an solution to resolve this.
Prastoin
Prastoin2d ago
Either use a db GUI explorer or psql directly Something like But first check:
SELECT *
FROM YOUR_WORKSPACE_SCHEMA.YOUR_TABLE
WHERE YOUR_COLUMN IS NULL;
SELECT *
FROM YOUR_WORKSPACE_SCHEMA.YOUR_TABLE
WHERE YOUR_COLUMN IS NULL;
To update
UPDATE YOUR_WORKSPACE_SCHEMA.YOUR_TABLE
SET YOUR_COLUMN = ''
WHERE YOUR_COLUMN IS NULL;
UPDATE YOUR_WORKSPACE_SCHEMA.YOUR_TABLE
SET YOUR_COLUMN = ''
WHERE YOUR_COLUMN IS NULL;
I strongly recommend that you backup your database before
Abdullah M
Abdullah MOP2d ago
Sure Thank you for your support. Any thing else i will come back to you.
Prastoin
Prastoin2d ago
Sounds good ! Enjoy coding !
Abdullah M
Abdullah MOP11h ago
HI how can i check the above provided code in twenty crm server I tried with node server i cant able to reach out the twenty crm database
Prastoin
Prastoin9h ago
You need to connect to your database remotely

Did you find this page helpful?