filters

Trying to concatenate within a table
In my "user" table I just want to combine the "First_Name" and "Last_Name" into one name, with a space between them. The output should be recorded in the "Full_Name" column in the related row. I cant seem to make it work.
How to check if the value (not the field type) is an integer?
I know about the "is_int" filter, however, the "is_int" filter checks if the field type is an integer, not the actual value. I have my field type set to decimal because it stores both decimals and/or integers. As a result, I have no way of checking if the value itself is an integer or not because the "is_int" function…
Exception: Param: transactionAmount - Text filter requires a scalar
Hello! I am trying to run a loop to save multiple records from an external API to my DB. When doing an API call (without loop) it is workign fine and returning all data. (screen 1) Once I add the loop it runs into an "Exception: Param transactionAmount - Text filter requires a scalar." The custom function is the working…
Show all records if URL param is empty?
Hi Everyone I'm doing a fetch GET request to my API endpoint. I have an external filter setup for members location, which is sent to the API as a URL param. "URL_ENDPOINT?location=27" and this works. Shows results for location 27. I have set this up following the Xano docs on External Filtering. My input "location" is of…
How to filter or query records where a table reference no longer exists
I am just trying to clean up our data as we're about to go live to 100 external beta testers. I was just wondering if there is quick way to filter or query records where a table refrence no longer exists? I have tried != = 0 = null and have not had any success in the spreadsheet view of the table
Why can I not filter by boolean==false with ignore empty values checked?
I'm facing an issue when querying all records of a table in my database and trying to apply filters. When I use a boolean to filter, it only works if the value is true and has no effect if it's false. I have the ignore empty values option checked. It seems like Xano treats false as an empty value, which doesn't make sense.…
Sort and filter by count
I have an Property table n-1 Floor table. And Floor n-1 with building table. Now im having a case that need to query building with sort and filter by Property record count. And Filter and Sort by Owner[] which is an field of Property. Can xano do this natively. Thanks alot.
How to count the number of characters in a text?
Hi, Is there a filter or something to count the number of characters in a text? Example: "Hello" count characters = 5 Thanks!
Removing diacritics from a string
I'm new to Xano and recently came across the issue of having to remove diacritics (accents) from a string, namely to transform a user-provided title into a slug so as to avoid presenting ASCII-encoded characters in the URL. In my (relatively limited) experience as a programmer, this usually requires some sort of library,…
1.53.3 (Jul 6, 2023)
🏗️ Re-Order, Disable, & Clone Filters! We've added the ability for you to re-order, disable, and even clone your filters just like you can with steps in your function stack! This also includes the ability to re-order arguments on the sprintf filter. ⌨️ Regex Validation at the Database Level With a new filter that can be…
How do I fix "Malformed UTF-8 characters, possibly incorrectly encoded"
Hi. I'm trying to parse a text file. I'll be getting some data from the file and adding them to a record however I'm receiving this error: Malformed UTF-8 characters, possibly incorrectly encoded. I have hunch that it's because of these characters: á,ü,ó, etc. I tried using the strip accent filter however I still keep…
Create_object filter no returning entry from a null value.
I have two lists, key_list = ["a", "b", "c"], values_list = [1,2,null]. The create_object filter will return {"a":1, "b":2}, the entry with null will not be included. What can I do to ensure I return {"a":1, "b":2, "c":null}?
Add filter to change or replace key names in an object.
The filter should take an object such as {"key1":"value1","key2":"value2", "key3":"value3"} and provide a list of text to replace the key names e.g. ["mykey1","mykey2","mykey3"} and return: {"mykey1":"myvalue1","key2":"myvalue2", "key3":"value3"}. WHY? At times, one needs to provide more descriptive keys to the frontend (a…
How can I ensure the create_object filter returns a null value in the object?
I have two lists, key_list = ["a", "b", "c"], values_list = [1,2,null]. The create_object filter will return {"a":1, "b":2}, the entry with null will not be included. What can I do to ensure {"a":1, "b":2, "c":null}?
Pagination in combination with (external) filtering
Hi there, I have looked at the docs of external pagination and (external) filtering. I would like to know if pagination in Xano do take filtering into account. For example: I have 120 records paged by 20 records per page so I canfetch data for a total of 6 pages. But then I use a filter and only 56 records remain. Does…
What filter can I use to convert "$ 60,000 USD" into "60000"?
Hi, I'm receiving some prices through an external api and need to extract the price number. What is the best way to to convert "$ 60,000 USD" into "60000"? Thanks!
Does anyone know how to fix this error when using set_ifnotempty?
I am trying to edit this data in my project without the fields that are already populated turning blank. I added the set_ifnotempty filter to one of the inputs as shown in the tutorial video in the documentation. However, whenever I run it, I get this error. Anyone know how to fix this? Any help is greatly appreciated!
Query filter - how to use regex
Table = places Column = placename I want to find all records where placename begins with the content of variable placeNameStr. The 'regex matches' operator seems a good fit for this. However, the example below does not work. I also tried /^placeNameStr/ The example in the screenshot generates this error:…
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…
Return only the first n characters of a text
Hi, I have to trim this description text so that it returns only the first 92 characters. How can I do that? Also, if I needed to return the last 92 characters how could I do that? Thanks!
How to get number of Months since unix epoch
Hey guys, Is there a filter option to get the number of months from the unix epoch? I'm doing a query all records and looking to see if the user already has a record in the table for the current month, so looking to get the number of months since the unix epoch to compare. How would I go about this? Thanks
Between filter missing?
I'm trying to use a between filter to check wether a date is in a certain range but, between filter doesn't appear at all! Was it removed from Xano?
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…

filters

Discussion List