CRUD (delete) in Form Data Model

[Jean-foxfly]

Form Data Model have 3 services:

1- get

2- insert

3- update

How is the form to delete lines in database?

[Mayank_Gandhi]

I don't think delete option is available via FDM. What's the use case?

[Jean-foxfly]

Hi Mayank, 

We need to build screens to a traditional CRUD for some database tables in company.  We already create the consult, insert and update functionalities by FDM. But we need include delete functionality. If this can't be done by FDM, what is the best form to do it?

[workflowuser]

You can create your own REST API to create the CRUD operations

and create form data model against that REST API and use it in forms

[Mayank_Gandhi]

You might have to write your own JDBC service for that. FDM might not be able to help you with delete operation directly.

[Jean-foxfly]

Ok. thanks for your response. Have you some link for samples of custom JDBC code in AEM?

[workflowuser]

Connecting to SQL Databases