Skip to Main Content
Feature Request FR-2051
Product Area Developer Experience
Status CLOSED

4 Voters

Client Side Validation using SQL/PLSQL

fahdbahoo Public · Oct 10 2021

Idea Summary
Client side validation should allow to use SQL and PL/SQL and show custom messages.

Use Case
Client side validation is a very basic requirement for any web application, and most of the times data has to be checked from the database to verify the validity of the data. so APEX should provide an out of the box solution to write SQL/PLSQL to validate and inform user about validity of the data.

Preferred Solution (Optional)
Should provide a simple dynamic action which should be able to user SQL/PLSQL and give a client side message to the user, both on item level and page level.

This request is likely a duplicate of FR-222.

Comments

Comments

  • jorge.cribb OP 1.4 years ago

    Sometimes it is necessary to perform validations between dates or numerical formats, or things of this nature, and it is not appropriate to perform them on the server due to the level of interactivity required. For example: You have 3 dates and the 1st must be before the 2nd (if provided), the 3rd date must be after the 1st or the 2nd if provided, and all dates must be earlier than today or on the same day. All of this cannot be done correctly on the server due to the interactivity required. This includes sending warning messages if validation fails. Additionally, all this validation logic should be executed on the server without having to be programmed again in PLSQL. I think the best approach would be that we can program the validation in PLSQL and indicate that it should also be validated on the client. In that case, APEX should translate the PLSQL to JavaScript for the validation to be executed on the client as well.