Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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 Criterion Issue

edited Oct 23, 2019 3:05PM in Visual Builder 7 comments

Summary

The filter criterion works if you provide the first two fields

Content

Hello,

I have the following 6 fields that are used as filter criteria on an SDP.

Treasury Symbol, Fund, Doc Num, Status, fromDate, toDate

Everything works as long as you provide the first two fields (Treasury Symbol, Fund).  It will not work without these two fields.  I am accounting for nulls using a function provided in Andre's blog at: http://andrejusb.blogspot.com/2019/01/search-form-in-oracle-visual-builder.html.  That works fine.

The network tab in Chrome Tools indicates a bad request.  Here is the error message when providing only the Treasury Symbol (the first field):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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