WindmillWWindmill
Powered by
giyuG
Windmill•16mo ago•
6 replies
giyu

[FIXED] Windmill Database Studio Type Conversion Issue

I'm running into a strange issue with Windmill's Database Studio component that I thought I'd share:

Is it an issue with my database?

Context:

Using Database Studio to query a Postgres table
Getting a type conversion error between String and Boolean parameters
Tried setting Extra Config with ({ "is_desc": true }) but still hitting the issue

Query Structure:

Has 5 parameters including a boolean flag for sort direction
Parameter 4 is causing the conversion error
Table columns: Id, Title, Url, Date, Summary, Full_text, Source, Created_at
image.png
WindmillJoin
3,362Members
Resources
Recent Announcements

Similar Threads

Was this page helpful?
Recent Announcements
henri-c

Weekly kenote to tell you about our latest updates https://discord.com/channels/930051556043276338/1278977038430240813 https://youtube.com/live/2dGd9TdT8xs?feature=share

henri-c · 4d ago

Pyra

### HTTP tracing (EE) Capture HTTP requests made by job scripts as observability spans Features: - View HTTP request traces (method, URL, status, timing) in the job details UI - Auto-instrumentation for Native TypeScript, MITM proxy for other languages - Integrates with external OpenTelemetry collectors changelog: https://www.windmill.dev/changelog/http-tracing docs: https://www.windmill.dev/docs/advanced/instance_settings#http-tracing Additionally jobs memory metrics are now fully OSS!

Pyra · 2w ago

henri-c

First keynote of the year here https://discord.com/channels/930051556043276338/1278977038430240813 🙂

henri-c · 4w ago

Similar Threads

Database Studio Table - Error
cali (brazil)Ccali (brazil) / help
2y ago
Database studio doesn't show tables
hcbHhcb / help
2y ago
Handling foreign keys in database studio tables
graemedouglasGgraemedouglas / help
2y ago
Issue with ms_sql_server in Windmill cloud
cmptrCcmptr / help
11mo ago