Xata•15mo ago•

2 replies

Unable to link a field to table via Xata SDK (JS/TS)

hello, I have been trying to link a

role

role

field in one table to a record in the

roles

roles

table via the Xata SDK, but it does not seem to work. For more context, I am trying to create a new user and the

role

role

field is a link to the

roles

roles

table. In the schema definition, the

role

role

cannot be null, but

console.log

console.log

ing the return value from

db.users.create

db.users.create

returns the created user without the link under the

role

role

field.
I have tried manually passing in the ID to the role I want to link, but that returns Fig. 1 and the new user record is not created

If I try to pass the actual value I want from the roles table i.e.

roles.role

roles.role

e.g. being == 'user', the create command is successful but

users.role

users.role

is still null. see Fig.2.

I have also tried querying the DB for the role I want, and then passing it as value for

users.role

users.role

, if I pass the full object i.e,

userRole

userRole

, or

userRole.xata_id

userRole.xata_id

I get the error in Fig.1 if I pass the

UserRole.role

UserRole.role

I get the error from Fig.2

I am using a Postgres-enabled workspace and Dedicated clusters

Xata•15mo ago•

2 replies

Kaligraphy

Unable to link a field to table via Xata SDK (JS/TS)

hello, I have been trying to link a

role

role

field in one table to a record in the

roles

roles

table via the Xata SDK, but it does not seem to work. For more context, I am trying to create a new user and the

role

role

field is a link to the

roles

roles

table. In the schema definition, the

role

role

cannot be null, but

console.log

console.log

ing the return value from

db.users.create

db.users.create

returns the created user without the link under the

role

role

roles.role

roles.role

e.g. being == 'user', the create command is successful but

users.role

users.role

is still null. see Fig.2.

I have also tried querying the DB for the role I want, and then passing it as value for

users.role

users.role

, if I pass the full object i.e,

userRole

userRole

, or

userRole.xata_id

userRole.xata_id

I get the error in Fig.1 if I pass the

UserRole.role

UserRole.role

I get the error from Fig.2

I am using a Postgres-enabled workspace and Dedicated clusters

Unable to link a field to table via Xata SDK (JS/TS)

Similar Threads

Unable to link a field to table via Xata SDK (JS/TS)

Similar Threads