query

Get request with Array Query works in debugger but not in live
Hi, Been trying to figure this out for a while now, I have a get request that has an input for an array in the debugger it's passed like this { "color_in": ["Red","Green"]} And when I try to do the same in postman it doesn't work, and I tried all different alternatives but nothing it only works in postman if I try it with…
Returning the "x" last records from the table, but in ascending order
Hello. How do I make a query on a table, returning the "x" last records from the table, but in ascending id order? Thank very much for help.
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,…
Column depending on another
I have a column that depends on another. Depending on the value that is entered, the other column needs to be automatically filled with a predefined value. I've been trying to do an endpoint, but isn't working.
How can I make a count/aggregate on object's array
Hi there, I need help setting up a query that includes a count of an object column within a database table. The set-up: I have a database called "notifications" Each notification has a column called "reactions" This column is an array of an object. Each reaction being for example an object containing userID, date, … so in…
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?
Looking for consulting expert (up to $200) to improve query all records speed performance
Hi folks! I'm looking for someone who can take a brief look at our database (35k requests, but with many fields, and part of them is arrays), and give some working recommendations about how we can improve query all records requests speed. Our query all records requests include many "overlaps" and "in" filters (10 filters),…
How to use the queried record's key as param for addon?
I am using the addon and want to use the value as param in the addon for where condition. Suppose I want to fetch the posts of users where post_type = unseen. The post type variable will be in user object. But I am not able to use the value from User object in addon. How can I acheive this?
How to get the sales per day in xano
So I have a requirement where I want to fetch the sales per day which can easily be doable in sql query. I want to know if there is any way of doing it in xano based on created at. I want to get the response of each day sales. Anyone here for help?
How do you use a join in a Query All for an array of tablerefs?
I am trying to use a join that take an array of tablerefs and adds the other tables details so that they can be used in the query versus doing it as an addon. Example: Events table has an artists column that is a list/array of artist_ids that reference their corresponding row in the Artists table. I am creating a text…
How to remove objects from list of entries that match another list of entry values?
I have two database. One that contains a list of companies and their associated emails and other information. In the other I have a list of user_id with company_ids that correspond with companies in the first database. I need a way to remove any companies (via Query All Record variable) in the first database of companies…
NOT IN Condition - How do I populate array of values?
Hi, I'm trying to add a NOT IN condition (custom query) using the Expression Query Bulder, but am unable to work out how to add an array of values to complete the expression? Can't see any examples in the documentation? Any time I try I end up with an empty array? Any help would be greatly appreciated. Thanks, Bren
"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 to edit an existing record targeting it by two or more parameters (fields) evaluating to true?
I want to update a field for a record based on if two column values are true for that record. E.g - Update/Edit "Complete_Status" to a "1" IF "Customer_ID" == "12345" AND && "Subscriber_Status" == "Subscribed" How would I got about doing this? I see that the Edit a record endpoint has the limit stating "If you choose a…
How to return a single record with 2 or more parameters (inputs) having to be true? (GET)
I see in the endpoint query maker tool the note "If you choose a field_value that maps to multiple records, then the first one found will be used." This would not work for my use case. I have a table with multiple recrods containing the same field value. However I would like to know how to search by multiple field values…
Remove duplicates based on two fields
I have a table that looks like this: id / status_uuid / timestamp / json_data I need to query and process in bulk (loop) only the newest (by timestamp) entries for each status_uuid. How do I get those or how do I dedupe to get rid of the rest? Thanks
How to filter data by date from external api request
I have an endpoint that lists invoices. An invoice has a query parameter called “modified” which is a timestamp. How do I fetch those invoices that have been modified after my modified query parameter?
Pinterest load more?
Hi there, I'm trying to create a similar website to pinterest. Rather than having fixed pagination, is it possible to have a “load more” (that just returns 25 EXTRA items, rather than loading a new list of the 25 NEXT items)? Many thanks
How to add dynamic input at the end of the api request url?
Hi! I have the following sample inputs: data[Name]=John data[LastName]=Cruz data[InvoiceDate]=01/01/2023 and I would like to add them in the end of this sample URL: https://www.pdfotter.com/api/v1/pdf_templates/tem_12345/fill? the URL will look like this:…
Table join producing duplicates?
Hey there! I'm querying a database of users and a database of pages where each page is assigned to a user via a user id. I want to select users whose pages fit a particular conditional, so I'm using an inner join with the following standard condition: user.id == page.user_id However, the result of this join is that each…
Performance issues on random requests
Hi, I am seeing veeery slow (up to 14 seconds, sometimes around 5s) requests on some of my endpoints regularly. But when I use the given parameters to test the query, it is quite ok with ~0.6-1s. endpoin 1: endpoint 2: How can I find out what the problem could be? Is there a way to have a “Explain query” like function like…
Why do Addons return as individual arrays? Where as query all records returns a normal array?
players_in is an addon where are all_players is a query all records. You can see by the additional [] in players_in that it is storing all the records from the addon in their own array. Why is this and how do I fix it? I need players_in to output the same as all_players
Join two table is slow so how to we should do it?
Hi everyone! We have this table that is related to another like this: table 1 (20k records) → column fk_jobs[] (any array of id of table 2) table 2 (10k records) → column id (an id) When we do a query all paginated the speed is very good (~0.07s), but if we want to join the table to use a search index in a fuzzy search…
Is it possible to get the most recent record for each group?
Hi everyone! I have a table candidate link to tables order and worker. Each line in this table candidate have different status like: I want to make a query all request filtered by "where order_id = input.order_id" to fetch only the candidates of a specific order. But I want to only have one record per worker_id so I can…
Query all records from - filter
Hello, I have a table with a JSON field that on some records is empty. When using the above query method I want to filter out all the records with that JSON field empty. However differently then the filter list that appears usually in this case I can not find the is_empty filter. Comparing the JSON to empty object did not…
Question about dynamically populating pages.
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…
Geting X number of latest records from a table
As the title mention, how can I do it from an API?

query

Discussion List