CloudBackend and CloudDB use different quoting settings for multi-select fields

[Daniel Mulroy]

Perhaps related to the other dropdown issue

It seems Cloud Backend's UI and CloudUI treat the multi-select fields differently.

CloudBackend escapes the integer Primary Keys, but the CloudDB UI does not. I ended up with something like this if you use both on a single row:

Also, because the dataType in SQL is medium text, not JSON, it's very difficult to parse.

Can you please make it consistent (integers alone, without quotes, is preferred but any consistency is better than this) and also can you tell us if it's possible to add a JSON data field type? Aurora SQL supports MySQL 5.7+ now including JSON field types

[Wassim]

Hello,
We now use consistently strings in our array so you would have everywhere ["298", "5"] if you use CloudDBUI or not.
About the JSON type, I added it to the list and we'll check what impacts it would have.

[Daniel Mulroy]

Thanks Wassim ! I will check it out and hopefully I can make everything work now for my scripts

[Daniel Mulroy]

Hi @Wassim, while we were waiting for the fix, I switched one of the fields back to linked 'field' (singular), but unfortunately, now that column is blank in CloudDB (but not in CB).

The data in each field is just an integer, no brackets, etc., and it shows up correctly in CloudBackend.

[Wassim]

Hi,
Ok I added a fix to handle them even if they're string instead of integers. It will be pushed in production tonight.