Thu, 24 Sep 2026
Login

jdbc datalist action

Confluence User - 07 Jun, 2023

im using a jdbc action binder im trying to perform a delete on rows of the datalist the problem is that when i use this query "DELETE FROM dir_user WHERE id={id} " nothing happen the page just reload with no delete , 

in fact when i use this querry "DELETE FROM dir_user WHERE id='respect' " the user with an id "respect" get deleted

datalists;plugins;forms;user;jdbcbinder

1

Confluence User •
12 Jun, 2023 •
confluenceUser •
•
confluenceUser •

Hi Saif,

Thank you for providing the information. I understand that you have a datasource set up, and you've shared an image of how it looks. Based on the image, everything seems to be in order. 

However, let me explain how I set up a similar application using Joget DX Enterprise Version: 7.0.36

Step 1: This is the datasource. 



Step 2: In the JDBC query, I specified the table name as "app_fd_user". For example, the query would be: "DELETE FROM app_fd_user WHERE id = {id}".


Step 3: And I have successfully been able to execute this action.

Step 4: And it successfully deletes the row.

If you have any further questions or need assistance with any other aspects, please feel free to ask. I'm here to help!




1
CSV | Excel | XML | PDF
RELATED QUESTIONS
Process not starting with Form submission.
Form Submission Performance Issue
Export As PDF
Select Box
one to many relationship
Can we create a dropdown field directly in a Joget List so that users can change the status of a record from the list view itself?
How to auto load client data after selecting it in a dropdown?
Joget User Visits Statistics
Plugin for PDF Editor
Limit User Approval
1
CSV | Excel | XML | PDF

Your answer

To answer a question you'll need an account.

Print