-
Flutterflow showing all data as "null"
Hi, building my first fullterflow app with xano. If I set all the fields in the database as "Nullable" = no, then I am getting all fields on the screen displayed as "null". If I set all the fields as "Nullable" = yes, I am getting an flutter error saying was expecting a string but got a null. Please advise how to sort…
-
How to nullfill variable (equivalent of SQL coalesce)
I keep running into the use case of wanting to create a variable that is the first non-empty value of a series of other variables. For example for some final variable X: I want X to be the first non-empty value of variables A, B, and C So if A = 2, B = null, C = 1 then I want X = 2 If A = null, B = null, C = 1 then I want…
-
Problem with non-input array parameters
I have two tables. Table 2 has a one-to-many relationship with table 1. Edit query table 2 has an optional parameter with this connections array. When I try to update the data in table 2 and don't enter this parameter, I expect the parameter to become null, but the test shows that Xano makes it an empty array. Main…
-
Filtering using a custom query, unexpected handling of AND condition
Perhaps my logic is failing me here, but I'm struggling with what I would deem, a very basic function - that is to filter on two boolean fields, whilst allowing NULL. In essence, I have two fields: isActive, isTrial. For my GET API, these fields are both parameters that allow null. My goal is quite simple - allowing a NULL…
-
Is integer value 0 treated as null in Xano?
I created a test endpoint with an input with an integer that can be null and passed the value 0. In the endpoint, there is a conditional that returns when the input value is null. The value 0 is returning null. 0 is considered null in Xano?
-
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}?
-
How to conditionally add a new record, when a null is present in the ID?
Hi All, fairly new here migrating to Xano, moving away from bubble.io thanks to their completely misguided pricing model changes. Having a few challenges trying to migrate some core parts of the DB into Xano. I come from a DBA background, so I'm quite comfortable with the underlying structure. My specific use case is that…
-
How to handle "null" coming as string?
I do not want to update fields in my database when it is coming as null or as a "null" string. Bubble API connector is sending unset string fields as "null" string. I am using first_notempty as explained in the below video. But this doesn't seem to handle "null" strings. The only alternative way to handle this situation I…
-
Select records where relative other table is null
Hi there, I have two tables: messages and users_messages where this last one has a reference to messages by its id. I'm a java developer and normally I would do select * from messages m left join users_messages um on um.message_id = m.id where um.id = null My goal is to select all the messages that hasn't a reference to…