lowcoder
lowcoder copied to clipboard
[Bug]: SQL Param {{null}} getting passed to postgres as 'null'
trafficstars
Is there an existing issue for this?
- [x] I have searched the existing issues
Current Behavior
I have a function call like
SELECT * FROM func_network___get_network_activity_rollup( p_activity_filter => {{ ui_trackerFilter.value || null }}::varchar );
ui_trackerFilter is a select component. If it is empty the JS Snipped should reduce to {{null}}, but it gets passed to postgres as the string 'null'
Expected Behavior
I would assume a null JS value would get passed to postgres as a NULL
Steps to reproduce
See Above
Environment
2.7.4
Additional Information
No response