AEM forms displaying search results from DB

[krithikar545354]

Hi All,

I have a search form component which takes input like firstname , last name, etc . When i click on Search button the form is submitted and i have a servlet which is invoked , it will return data from database. Now i need to use this data returned to populate a table below the search component. Is it possible to achieve the same with table component or any other aem forms features ?. I have gone through helpx document to populate the table dynamically using xml , but doesn't match my requirements. TIA

[Mayank_Gandhi · Accepted solution]

Once you have data with you in xml or json you can try to use jquery data table and populate the data in it. This will, of course, be a custom approach.

Working with jQuery DataTables — SitePoint

[workflowuser]

Adobe Experience Manager Help | AEM Forms with JSON Schema and Data

[Mayank_Gandhi]

Here is a great sample published by Lee. Please refer the sample code at below link:

https://forms.life/2019/06/03/datatables-in-adaptive-forms/