Get help, find answers, and meet experts for all your Xano backend and no-code development needs. Xano is scalable, secure, and connects to anything.
Hi Guys, I think i'm running into a small bug. The issue is database tables with columns of the structure LIST with nullable set to YES. If you query records in that table with the direct database query and any record within the set has a NULL value in one of those structure LIST columns it throws a nasty error.
I am trying to make an sql query as shown in the screenshot but I am having issues replacing the parameters as some of them are arrays, how can I prevent the error on the right and have the array render properly in the query without the square brackets
Hi, new to Xano but not to building apps. We're porting an existing app to xano so i started with datamigration. Every table (about 70 of them) has a updatedAt field. We use this field to determine what the last point was that the table content was synchronised. Initially i've build a function that has an enum named table…
I am wondering if I can take advantage of Direct Database Query to remove multiple (thousands) of records. My query: DELETE FROM abc WHERE id IN (?); This works if I specify the id values by hand, but when using an argument there I run into an SQL error. Even when I transform an array of ids to a text like "1, 2, 3", the…
Im building a somewhat niche CRM system that relies heavily on users managing, logging and screening high volume emails. Slogging through the various mail client setups is disheartening. Im looking to build an MVP on the side, as I service my consulting clients. Just looking for any input. Maybe someone knows of a better…
Hello, I would like to create a tagging system in Flutterflow. For every item in the table there would be string tags to select from the list of custom tags created by the user. The user would be able to create, edit and delete the tags. It would be perfect to filter with any tag also. My idea was to do UI in a form of…
So I recently realized that rendering data on a page from a backend like xano would result in either a nondescriptive URL path, or an uncrawlable query parameter by search engines. For example, (with a token) example.com/user-profiles example.com/user-profiles?id=239487234987 I've created a marketplace using webflow and…