Small bug with Custom Query step

[aschoijett]

PLEASE DELETE THE BUG TEMPLATE DUMMY TEXT BEFORE POSTING THE TOPIC!
Hi,
Using Wappler 5.5.3
NodeJS
Windows 10

When I create a custom query on a table and want to retrieve an Enum field, the query results do not show that field. The query does return it, though.

The Schema tab shows the Type of the Enum field as Empty.

Thanks,

Alex

[famousmag]

Hey @aschoijett,

Using ENUM's in client side inputs

One of the downsides to using ENUM’s in the database is that they are not readily available to be used in client side inputs – for example a select element for choosing a value that is stored as an enum. So if you add a new enum value to the db, you have to update your code as well. Here’s how you can do this dynamically for MariaDB (and presumably MySQL, but I haven’t tested.) Create a custom query with the following content (make sure to swap in your own database name): select col.table_…

[aschoijett]

Thx Tasos,
The article is useful (as it is usual with those from Ken) but it does not address the small bug in the Wappler back end UI. I think this one is something that the guys in Wappler need to fix.

Many thanks!

Alex