set_ifnotnull - does not work with bool field type

Options

im not 100% sure if that is a bug or not, but, from the description of that filter i would expect that if will copy a field value in edited record, as it works with set_ifnotempty for me in same exact setup. But every time i send null as a value for that bool filed when field has value true - it changes it to false.
var update =

edit step:

test runs that show issue:

1.

2.

Comments

  • Ray Deck
    Ray Deck Trusted Xano Expert ✭✭✭
    Options

    Is the input on the function nullable? If not, passing a null might just treat it as "missing" and fall back to a default value, like "false"

  • Max
    Max Member
    edited October 2023
    Options

    thanks a ton!!

    that was not but its just me not thinking of that option, because when input is linked to table like by default - there was no option to choose if noolable is on :(

    please who ever is able, move this from bugs :)

  • Ray Deck
    Ray Deck Trusted Xano Expert ✭✭✭
    Options

    I remember this coming up before with database-linked inputs. They are a good feature for getting started, but I don't use them now that I have some more experience because of the lack of control like in this situation.