Hi
Apex 21.2
I have a report with a search region. The region has many select lists and text boxes, to create the search.
This working fine, I write the sql where like this
where (:P4_FIRMENNR is null or instr(upper(FIRMENNR),upper(:P4_FIRMENNR))>0)
and (:P4_ZNGNR is null or instr(upper(ZNGNR),upper(:P4_ZNGNR))>0)
and (:P4_WERK is null or instr(upper(WERK),upper(:P4_WERK))>0)
and (:P4_GEBAEUDE is null or instr(upper(GEBAEUDE),upper(:P4_GEBAEUDE))>0)
and (:P4_GESCHOSS is null or instr(upper(GESCHOSS),upper(:P4_GESCHOSS))>0)
and (:P4_BENENNUNG is null or instr(upper(BENENNUNG),upper(:P4_BENENNUNG))>0)
The problem I am having is that I also have some date filters (date pickers, format dd.mm.yyyy).
I have a :P4_FROM and :P4_TO, so a date range.
Can someone help me with the sql required to get the filters working.
The date filters are not always used
Reagrds
Gus