-
Get the records only belonging to a specific user
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…
-
Possible bug with custom query AND condition
Hi, I posted a question in the "working with APIs" section, which nobody seems to have responded to for several days, about a potential bug with the "AND" condition being treated as an "OR". I have so far found this behaviour appears consistently in all tables with boolean conditions, at the very least. The only workaround…
-
Querying a Database for Matching Element in Array
I have a large database. One of my fields is an array of text. I could easily juggle it around to be an array of objects or an array of some other type if it helps. I am wondering how to query the database to return only records that contain a defined search element. For example if a record had array: [text, dog, cat,…
-
Filtering using a custom query, unexpected handling of AND condition
Perhaps my logic is failing me here, but I'm struggling with what I would deem, a very basic function - that is to filter on two boolean fields, whilst allowing NULL. In essence, I have two fields: isActive, isTrial. For my GET API, these fields are both parameters that allow null. My goal is quite simple - allowing a NULL…