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?
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?