I am trying understand Orbeon to use in one of our project. Here is my query.
I understand data filled in the form is stored in xml format in database table. Now if I have two fields in the form say "First Namë" and "Last Name", and I want to find all records whose first name begins with "B" or having First Name as "Bhimashankar", How can I achieve this functionality in Orbeon forms?
I want to filters on data and don't want to use row Id.
There are a few ways for you to access captured by the forms you created in Form Builder:
- You can have Form Runner call a service you provide, passing the form data when users submit the form.
- You can call a REST API provided by Form Runner to access the data.
- You can access the data directly at the database level.