Check whether attribute in query is null

Support
#1

When in my ScreenA in a Datasource I have :custom$ parameter When I open ScreenA from say menu :custom$ parameter is undefined and I get postgreSQL error “can’t infer parametr $x type”. How do I pass default parameters used in refresh() by platform? Or how do I force JPQL ignore undefined parameters?

#4

It turns out that exactly presence of x is null where x is null causes error. Without “is null” everything works. But how do I ckeck whether the parameter is null then? For example
how to ignore condition
and (e.event.start between :component$startDateFld and :component$endDateFld)
when :component$startDateFld is null?

#5

Use Query Filter.

1 Like