You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Compound Filter - not working for five fields

Accepted answer
18
Views
5
Comments
edited Jul 1, 2019 9:53PM in Visual Builder 5 comments

Summary

Compound Filter works for three of the five but not last two

Content

Hello,

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".

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!