-
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,…
-
database query with filter on field in an object
Hi ! Let's imagine a user database. This database has a list field of objects called "states". Each object has a state (int) and date (timestamp) field. This represents the user's status history. Is it possible to make a query that will directly filter users with a specific status on the most recent date? At the moment,…
-
Add the ability to access and use database meta data in the function stack.
Please, please add the ability to access and use database (tables, relationship, content, columns) meta data in the function stack instead of calling them from the api. We should be able to use them like every custom or inbuilt function. It would be great!👌. I imagine how quickly it can help my app to be able to easily…
-
How to store booking times effectively?
I am creating somewhat of a calendly alternative and I need people to be able to select the times that they are available for bookings. However, I am confused, about what type of field type I should use for something like this because the booking availability will have the person's normal weekly hours but then on a…
-
How to conditionally add a new record, when a null is present in the ID?
Hi All, fairly new here migrating to Xano, moving away from bubble.io thanks to their completely misguided pricing model changes. Having a few challenges trying to migrate some core parts of the DB into Xano. I come from a DBA background, so I'm quite comfortable with the underlying structure. My specific use case is that…
-
How to update all Records in a database without Query All
I have a large database(1.5 Million Records), and am wanting to go through and update a field for each of them. What would be the best way to do this given that Query All seems to be returning a memory issue. Thanks for any help! Edit: At the moment my plan is to update them in chunks, just curious if there is a better way?
-
Automating workflow on record creation or update
Hi, I just started using Xano and I'd like to learn if it's possible for me to trigger a workflow on the creation or update of a record in the database? One of my uses cases requires the data in a field to be used in an (external) API call to receive a response that can be saved in another field. For example: let's say I…
-
What is the ideal table structure, where courses have slide-based lessons with unique content types?
Hello everyone 👋, I'm new to Xano and working on a project which is about learning management system. I'm using Webflow + Wized + Xano. So here I have 2 tables "Courses" and "Lessons". Courses table will have list of course name and some more information about that course. Lessons table will have content for each course.…
-
1.53 (May 23, 2023)
🚸 NEW Maintenance Panel We've introduced a new Maintenance Panel to all paid plans enabling more control over certain maintenance operations for your Xano instance and database. Read more about this in our documentation here. If you're unsure about whether or not maintenance operations should be performed, please refer to…
-
How do I delete a list variable in my database?
At the start of my function I want to delete the existing variable list in my user database, so that it is empty and I can repopulate it with new variables. I know there is delete record, but I want to delete all the items in the list instead of just one item. What's the easiest way to do this?
-
How do I correctly upload images to my database?
I'm using JavaScript to upload all these images to my database, and these images that are being uploaded through the endpoint are not loading correctly. How am I supposed to upload these images correctly?
-
uploading csv data to update entire database
Hi, I'm hoping that some experienced Xano user might be able to offer a solution? I am working for a client who has a Launch account and they have a main table with a 100,000 records (each with about 25 fields). They want to be able to upload a csv file (actually 3) and update the table. Not really a problem (thanks to a…
-
Creating tagging system in Flutterflow
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…
-
External API call successful, but unable to save data on the database! Please help
Hi Xano team, I am super new to Xano, so excuse my naivety. I've been working on getting the data from external API, and I've been successful in calling the data, but when it comes to saving the data using the 'for each loop option', I seem to be having no luck. I've thoroughly followed the instructions from this youtube…
-
A true cascade delete
Hi - would love to see an option that intelligently cascade deletes. Perhaps in the datatable view section include an option to link this primary key to a foriegn key elsewhere; perhaps just more control over definitions. Then, functions can remain the same as the logic will be respected on the table side-of-the-house. Is…
-
"having" statement in aggregate functions
I'm doing a group by to aggregate a table and get a count of record. I'd like to only get the rows where the count = 1. In SQL, this would be something like: select name, count(1) from table group by name having count(1) = 1. Is this possible using the query all record function? I don't see it in the output tab.
-
How do you design your Xano DB schema?
Hello! I wonder if there are any good practices about designing Database Schema with Xano. Does Xano comes built-in with any tool that would generate such schema (of the existing tables)? We're thinking of using to design our DB, and then integrate those into Xano manually, but I was wondering if there wouldn't exist…
-
New records not saving in database
Hello! Just a little bug report. I'm seeding our database right now. Includes fields for Image, title, etc. I went through and added 30 images and titles, went Back to db dashboard, changed some details in another table, came back to the one in question and 14 of the records that had apparently saved (the little purple…
-
Double-checking database structure - object vs relation
I've been looking through the forum and I think I've understood what I should do from other posts, but before I start trying to build this, could someone check my logic? I've started trying to map out the data structure I need for my Webflow/Wized/Xano based client app in this FigmaJam file. When I started mapping it out,…
-
Get first 20 records
Hi, I'm looking to achieve the following scenario. I currently have a database call that gets all records, and includes pagination (this shows 28 records per page) If the user is not on a premium plan, however, I only want them to be able to see 20 items maximum. How can I limit the amount of items that I retrieve from the…
-
Boolean being read as a text
Hey folks! I'm having a simple types issue in the Function stack. I've got a boolean type “isAcceptingSubmissions” that shows up as a text type in the API. Boolean in Database: In Debugger: But it is a “text” type when querying the database: Is this a bug? Thanks so much for your help!
-
How to make a data source conditional in my api endpoint
Hi, I'm planning on creating a conditional whether the data being used is “live" or “test”. If the data being used is “live”, I'll use the live api keys for my external api and if “test”, I'll use the test api keys for my external api. Do I make this by using $datasource == ‘live’ // $datasource == ‘test’? for my…
-
Where Can I find the Postgres Database URL?
Hey, Trying to connect to the Xano database from an external scheduling platform that asks for the “Postgres Database URL”. Where can I find the database URL? Thanks, H.
-
More optimized way to get huge json into database
Hey guys, I am having a hard time getting a big number of rows into the database. Currently, I get zipped file from ftp, unzip it, split it into about 250 json files less than 1mb (otherwise, i get 413 error) and send it to xano api to insert the rows into my table, there are a total of 750000 rows in total. The problem…
-
What is the best way to structure this database?
Hey, So just getting used to Xano and I want to know what you think would be the best way to structure this database. It is a 2-way marketplace where there are 2 types of users. Brands & Creators. Brands will create job listings with certain paramters (Age, niche, location, language etc...) Creators will be see a list of…