Skip to content

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

@ScottKemp

Description

@ScottKemp

Is there an existing issue for this?

  • 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

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions