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

Search Query in VBCS

edited Nov 17, 2017 8:00AM in Visual Builder 2 comments

Summary

Search Query in VBCS

Content

Hi i'm new to VBCS, i'm developing a sample application in which i enter employee details such as name, dob, age etc.. i calculated age based on a dob using formula{(new Date() -new Date($dateOfBirth) )/ (60*60*24*1000*365)}.

Now i want to search an employee based on age (for example whose age is greater than 30). I've followed a link that explains custom search query page in VBCS

https://blogs.oracle.com/shay/creating-custom-searchquery-pages-with-visual-builder   which works fine for other attributes such as name, but when i do same for age it dosen't works.

How to do custom search query for calculated values??

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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