How to check from BDM and display duplicate message in UI designer
I am a beginner working on a project
My requirement is I need to check if record exists with min value, max value, level, group, role in BDM if exists then display error message in UI designer or else continue . How can I approach this . If it is from custom query how should I implement in UI designer .Please suggest
You have to add a variable in your form and link this variable to a REST API, which queries the BDM. Then, you will get in your form if previous information exists, and then display a message.
You can use it in 7.11 the new BDM Rest API in the designer.
If you need, you can create in the BDM a new "custom request" and then call it from the UI Designer;
Note: you have to do server-side a verification. Imagine that 2 users access your form: this is no duplicate information. Then user 1 submits the form, a record is created. Then user 2 submit the form just after: there is no message for him on the form because the verification is done when the user ENTRANCE the form, not when he SUBMIT it. So, server-side, be prepared to have duplicate information. The best is to use a unique index on the BDM to avoid duplication. Then, the submission will fail for the second user.
Hope this help