Question regarding forms and field validation

Certified Senior Developer

need a quick solution on one of the problem statement in Quantum
Form -> fields validation to be done from the pre-configured table validation queries
example:-
- lets assume a form has 5 fields
- 5 fields has 5 different validations
- validations are stored in the database in the form of 5 distinct queries
1. Form Name
2. Field Name
3. Validation ( queries, which is stored in validation table against each field in the below form:
ex : to validate age field the query in the db : select age from table1 where formName = "form1"
and age > 40)
(there will be 5 different, queries like this for each form elements)


Question:-

Is there a ready made solution in Apian for ...

OriginalPostID-191735

OriginalPostID-191735

  Discussion posts and replies are publicly visible

Parents
  • @ajoy, one of the possible way is to create a stored procedure with 5 output parameters, before entering into the user input task in the process model, make a call to the stored procedure, get all the five fields validation limits (through output parameters). and pass them as parameters to the sail form.

    inside the stored procedure, check if you would be able to get the responses using the EXECUTE IMMEDIATE way, i believe reading from table and executing might be difficult.
Reply
  • @ajoy, one of the possible way is to create a stored procedure with 5 output parameters, before entering into the user input task in the process model, make a call to the stored procedure, get all the five fields validation limits (through output parameters). and pass them as parameters to the sail form.

    inside the stored procedure, check if you would be able to get the responses using the EXECUTE IMMEDIATE way, i believe reading from table and executing might be difficult.
Children
No Data