'Data still appearing in Oracle BI report when I dont give any input in the parameter
I have made a BI report using Oracle SQL. When I give an input to the parameter field, I get data. But, when I leave the parameter field as empty without giving any input, still the data appears instead of disappearing. What changes should I do in the SQL or OTBI dashboard to clear this problem?
**SELECT
AIA.INVOICE_NUM
, AHA.RELEASE_REASON
, DECODE (AHA.HELD_BY,'5', (SELECT ALC.DISPLAYED_FIELD
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE(+) = 'NLS TRANSLATION'
AND ALC.LOOKUP_CODE(+) = 'SYSTEM'),
AHA.HELD_BY) "HELD BY"
, DECODE (AHA.LAST_UPDATED_BY,'5', (SELECT ALC.DISPLAYED_FIELD
FROM AP_LOOKUP_CODES ALC
WHERE ALC.LOOKUP_TYPE(+) = 'NLS TRANSLATION'
AND ALC.LOOKUP_CODE(+) = 'SYSTEM'),
AHA.LAST_UPDATED_BY) "RELEASE_BY_USER_NAME"
FROM
AP_HOLDS_ALL AHA
, AP_INVOICES_ALL AIA
WHERE 1=1
AND AHA.INVOICE_ID (+) = AIA.INVOICE_ID
AND (AIA.INVOICE_NUM IN (:INVOICE_NUM) OR COALESCE(NULL,:INVOICE_NUM) IS NULL)**
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
