Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Validate Attribute value at entity level validation against Runtime DB Query

Sanjeev-OFMAug 30 2022

Hello Friends,
We are having one requirement where we need to do additional validation against a query text. I'm explaining it with the scenario.
Scenario:
We have to validate entity based view object one String attribute value (which is a combination of 8 multiple values separated via "." Value example-- "001.100.101.00012.ABC123,24343,12019,ak200") against with query text where starting 4 parameter value of String attribute need to pass in query text where clause( select count(*) from table name where param1='001' and param2='100' and param3='101' and param4='00012') and if query text count>0 than allow to save the record and if there is no record with provided combination in query text than need to show error message.

Kindly help with suggestion how we can validate it using the declarative approach.
Thanks
Sanjeev

Comments

Post Details

Added on Aug 30 2022
15 comments
500 views