filters

Parsing Object with Quotes into Array
My frontend is providing me with this: { "2": { "domEvent": {} "value": [ 3, 4, 5 ] } "3": { "domEvent": {} "value": [ 7, 10, 11 ] } } I'm trying to get the values as a list. What sequence of filters would I need to use to transform this into an integer list / array of [3, 4, 5, 7, 10, 11]? These are coming from a sidebar…
Getting only the INTof a record id from a get all records query
I am unable to get a only the INT from a simple get all records query. I am getting the company id from the logged in user and store it in buyer_id. Using the buyer_id, I filter my second query certificates using only the company_id INT. How can I get only the number the INT and not the object with the number? The closest…
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 filter / summarise a response based on a criteria nested two levels deep?
I have a response from an get all records query called certificates, enriched by some addons (farm, credits). I want to filter my response where credits.status == ex_post. How can I achieve this? Using the result I want to summ different data from that list like total_tonnesco2e with credit status ex_post I tried dot…
simple query to get a set of search terms
A big challenges of a query is to get useful information from flawed user input.. The fuzzy search tool is really amazing at doing just that. But synonyms and spelling may still present challenges to users especially on mobile devices. I would like to generate a list of words that a user could tap on their screen to…
First not empty filter with Push Filter for Array
Hello, How can I push to an array (when editing a record) ONLY if the input is not null? This is what I have but its not working. I'm really hoping I can use a filter for this instead of having to use if statement Any help is greatly appreciated!
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.…
How do I filter out / query all the commissions that's within the last month?
I have a background task that's activated every 1st of the month to pay my affiliates a commission. How do I filter out / query all the commissions that's within the last month? Problem is that some months have 30 days, some months have 31 days, and so on... Example: On the 1st of October, I want to process all the…
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.…
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
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?

filters

Discussion List