-
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…
-
Noob question: Filter in Xano
Hi guys, I have a table events that has a column called id_neighbourhood. And I have the table neighbourhood with the name of it. I'm calling an API with an array with the neighbourhoods to use in the filter. That means I can get all the events in one or more neighbourhoods. But when I do this search: get this error: Plase…
-
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…
-
Get query filters for text
Hey there! I have a table called "posts" and in this table there is a column that is called "colors". The entries in this column are datatype text and could look like this: "black, brown, green" Now I want to filter query this with an input of different colors for example like this: { "postcolor": "white, black" } In this…
-
Set a value in a list of objects if condition is met
I have a list of objects made like this: [{restaurant_id: 2, entrance: 4}, {restaurant_id:3, entrance:5},{restaurant_id:4, entrance:6}..] My goal is to edit (possibily using a conditional set filter, the list if restaurant_id equals a given number. I know this could be done also through a FOR cicle or in other ways but I'm…
-
array filter to perform regex
Trying to filter array of objects to return a subset where a string property matches the regex. i am using a filter function on array and in the lambda I have the following but i am having problems getting Objects like RegExp or string methds like match to work var mystr = $this._tags.tag_name.matches; const re = /^[^\$]/…
-
HELP! filter arrays and select the latest /not empty option
Hello everyone; Im working with an external API where Im receiving an arrays of repeat information which I would like to safe in a variable. my problem: Im receiving data with several array of different dates, which each contains the latest information from that date. some of the date arrays are empty and other are not. Im…
-
Add an average and median math filters for arrays
Currently, we have sum, max, min and product math filters that we can perform on arrays, but no median or average filter. Would be great to have a median and average math filters that we can perform on arrays as well.
-
Keep getting a 'Please use a numerically indexed array' message in debugger
Hi @Michael Udinski, I am adding data from an external API and have run into the 'Please use a numerically indexed array' issue in the debugger. I have reviewed the 4 threads on this topic here but still am not able to chase down where the issue is as the debugger does not actually reveal the exact location. I've also…
-
Json response sorting and editing
Hello Community Is there any way to manipulate the order of items in a json response? E.g. I use "set" filter to add an item and a new path+value is added at the bottom of json and I wish it was at the top. Oooh yes, I want it pretty :) Can I update an existing path of an item in json? I am currently doing "set" and…
-
How to extract a section of a URL?
I'm positive Xano has an easy(ish) way of doing this, but I just can't land my finger on it. I have a list of Amazon URL's that I'm needing to extract the ASIN values from. Luckily, in this list Amazon always has the ASIN following the /dp/ folder. See here: I'd like to avoid using regex as much as possible here, but with…