-
Passing array output from a query into an addon input
Has anyone discovered a way to pass a list of values directly from the output of a query into an addon? I have an addon which does some aggregate calculations, based on an array of values (which it looks up) for the input. The problem is though - I can't find any way to pass ANY list value as an output into the addon (it…
-
Query with a special character.
Im were used the import CSV which has some records with name field contain "m²". But then i can not using the get action in API to get the records with input "m²". Wondering what is the issue and if there are some solution. Thanks for all help.
-
Filter Database Query by 'Does not include those"
Hello dear No-Coders, I'm trying to query all records from a database where every item has a certain task ID, by providing all task IDs that I don't want to have outputted. So if I have a database with the tasks; 1A, 2B, 3C, 4D… and I provide the filter on 3C and 1A… - I would only get an array of 2B, 4D… back. But the IDs…
-
How to retrieve data for a specific user
I am currently using Xano with Draftbit. My goal is to only display data in one table based on the user being set to the current authenticated user that is signed in. At the moment it works as I am able to manually set the user I want. Although, I have only been able to query the user based on email and not their userid.…
-
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 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?