OTBI filter show no data
Summary:
Hello experts,
we have a report for recruiting requisitions, but when trying to search in the values we get no data..
the list of values:
SELECT DISTINCT
IRB.REQUISITION_NUMBER || ' - ' || IRT.TITLE AS "REQUISITION_ID_Filter"
FROM IRC_REQUISITIONS_B IRB
JOIN IRC_REQUISITIONS_VL IRT ON IRB.REQUISITION_ID = IRT.REQUISITION_ID
WHERE 1=1
AND IRB.ATTRIBUTE_CHAR8 = 'N'
AND IRB.REQUISITION_NUMBER IS NOT NULL
AND IRT.TITLE IS NOT NULL
ORDER BY 1 DESC.
no matter what put on search, no data can be found.
best regards-