Search Component using AEM forms

[srinithi_abira1]

Hi All,

I have given a task to analyse,I have given an Classic ASP page with search functionality.the search is based on data or topics the result will be displayed down.

this sight has been migrated to AEM but this search alone is pending. the result data are stored in sql server.

My question is whether we can rebuilt it in AEM using AEM forms and sql?

Any suggestion would be welocome 

Thanks.

[Sakshi1]

Sure, You would be able to achieve it by AEM Forms. Please refer to following links, for any reference.

[0] https://helpx.adobe.com/aem-forms/6-2/topics.html

[1] https://helpx.adobe.com/aem-forms/6-2/introduction-aem-forms.html

[srinithi_abira1]

i need to store all the data in sql,can i be able to retrieve it using java and display it?

or is there any possiblity to use JCR for storing

[Sakshi1]

Yes, both are possible.

You can write your data dumping / retrieval logic in java or if you wish you can store in JCR as well.

[0] https://helpx.adobe.com/aem-forms/6-2/custom-submit-action-form.html

[1] https://helpx.adobe.com/aem-forms/6-2/configuring-submit-actions.html

[2] https://helpx.adobe.com/aem-forms/6-2/prepopulate-adaptive-form-fields.html

[srinithi_abira1]

the search component's result should be already stored in database. how to store all the data in JCR in AEM? it is not submit form where we can get the data form form and store it in db. the result data should be stored predefined so using search we can just retrieve  the data and display it.

[Sakshi1 · Accepted solution]

Hello Srinithi,

Those links were for reference. You can always write a click expression on your button, hit your servlet and fetch results. If your search web service have swagger / wsdl configured, you can directly map your fields to its input and output using rule editor. [0] [1]

If your result is in form of array/list, you will find it useful to use repeatable panels [2] or repeatable row in table [3]. 

[0] https://helpx.adobe.com/aem-forms/6-2/using-web-service-rule-editor.html

[1] https://helpx.adobe.com/aem-forms/6-2/invoke-web-services-adaptive-forms.html

[2] https://helpx.adobe.com/aem-forms/6-2/creating-forms-repeatable-sections.html

[3] https://helpx.adobe.com/aem-forms/6-2/adaptive-forms-tables.html