nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

How to use Textbox filters

User_SYYDG

If I only do one with one expression filter, it works, but if I put the 2nd parameter with an expression filter, I get no data found???? Why

Find more posts tagged with

OAC

Accepted answers

Clare Murtagh

what about wrapping it : (RES = @parameter ("P_Res")('') OR @parameter ("P_Res")('') = '') AND (ACC = @parameter ("P_Acc")('') OR @parameter ("P_Acc")('') = '')

If the blank complains give both parameters a default like 'ALL' and swap the = '' for = 'ALL’??

All comments

Clare Murtagh

Hi @User_SYYDG - P_Acc is blank, so the second filter goes looking for an empty account value and finds nothing. Workbook filters all have to be met together, so that one wipes out the whole result. Try:

RES = @parameter ("P_Res")('') OR ACC = @parameter ("P_Acc")('')

User_SYYDG

The problem with this is I need the 2 to only bring back a combination of those 2 values

Clare Murtagh

what about wrapping it : (RES = @parameter ("P_Res")('') OR @parameter ("P_Res")('') = '') AND (ACC = @parameter ("P_Acc")('') OR @parameter ("P_Acc")('') = '')

If the blank complains give both parameters a default like 'ALL' and swap the = '' for = 'ALL’??

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders

Mallikarjuna Kuppauru-Oracle 51