Twenty•4w ago

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 MOP•4w ago

Hi twenty crm team I am waiting for your help!

Prastoin•4w ago

Prastoin•4w 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 MOP•4w ago

any way to drop all the people's table data???

Prastoin•4w 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 MOP•4w 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•4w 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 MOP•4w ago

Sure Thank you for your support. Any thing else i will come back to you.

Prastoin•4w ago

Sounds good ! Enjoy coding !

Abdullah MOP•4w 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•4w ago

You need to connect to your database remotely

Gaming

Programming

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

Did you find this page helpful?