Get the records only belonging to a specific user

yrewq

Hi everyone,

I'm quite new on using Xano and I'm struggling on set up an API to get all records belonging to a specific user.

I've a 3 tables on my DB (user, workspace and content)

Every user, after signing up, have to create a workspace to start creating a content.
Every workspace can have multiple users (ideally with multiple roles but not my focus ATM)
Content belongs to a workspace (and so to a sigle user).

This is my API endpoint to GET all the workspace related to an user and the error message I got.

user authentication required is ON

BY JOIN

workspace.users_user_id (workspace_users_user_id) via inner join

BY CUSTOM QUERY

auth:id in db:workspace.users_user_id

RESULT

{
message: ParseError: 2 in "workspace_users_user_id", message=Array is required for 2nd operand. }

Here some screenshots

Thank you in advance for your help .

Alessandro

Michael Udinski

Switch your operator to an EQUALS instead of IN 😊