Compound Filter - not working for five fields
SummaryCompound Filter works for three of the five but not last two
I have a compound filter that is based on five fields. I created a function per Shay's recommendation to account for empty fields based on this blog post, http://andrejusb.blogspot.com/2019/01/search-form-in-oracle-visual-builder.html I call the function and then assign the variables. The variables are based on the criteria structure per Shay's blog.
The filter only works for the first three variables. A screenshot is included below. There is one field that is not display and defaulted to a value of '1'. The next two fields, 'Treasury Symbol' and 'Fund' work. So that is the three fields that work. However, the data is not filtered at all (blanks out the screen) when you provide the next field, "Doc Number".