lowcoder icon indicating copy to clipboard operation
lowcoder copied to clipboard

[Bug]: SQL Param {{null}} getting passed to postgres as 'null'

Open ScottKemp opened this issue 3 weeks ago • 0 comments
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

ScottKemp avatar Oct 27 '25 21:10 ScottKemp