Issues with how ENUMLIST is treated?

WillowMobileSys · 01-31-2024 08:42 AM

I have an app that saves data to a database (in case that's relevant). I am noticing today some odd behavior when attempting to use an ENUMLIST to check for presence of a value using the IN() function

It seems I have to also SPLIT() the ENUMLIST by its delimiter to get a proper List of values to inspect. In other words, the EnumList column is not being treated as a List by default. This behavior is relatively new. See image below for difference.

AleksiAlkio

Is the [System Notifications] column in the "Employees" table?

WillowMobileSys

Yes, it is a physical collumn in the Employees database table.

AleksiAlkio

I have used this kind of formula here and there and I have not seen this kind of behavior where it doesn't work properly.

Aurelien

Hi @WillowMobileSys

As far as I remember, even though EnumList suggests it is being treated as a list, it its first of all treated as a text.

I did not dug it for retrieving it, but Steve explained that once in an old post from 2021 or so.

I personnaly use to wrap it in a SPLIT() expression everytime.

WillowMobileSys

Thanks for the input. That hadn't been my perception but maybe I have been wrong?

Additionally, it seemd to be working just fine for many months until I just recently made a change and tested it.

Suvrutt_Gurjar

Just in case it helps. A quick testing shows that the IN() seems to be working okay when tested in a VC and on a Google sheet backend.