-
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…
-
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…
-
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…
-
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…
-
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…