Automate Joomla Database Operations
You can automate Joomla database operations. Save time and get more done by setting up automation workflows.
There are four types of database operations for automation:
- Create Record: Create record in any Joomla database table.
- Update Records: Updates column in any Joomla database table.
- Delete Records: Deletes records in any Joomla database table.
- Replace Records: Replaces text in any Joomla database table.
Please note that these operations cannot be undone.
Database Table: Enter the name of the database table without the prefix. For example: content
Sub Action: Choose the type of task you want to automate.
1. Create Record
Data: Enter the key-value data to insert into the database table.
2. Update Record
Where Conditions: Add one or more conditions for updating. This is required field.
Column Name: Enter the name of the column to update.
Column Type: Choose the type of database column.
Column Value: Enter the new value to update.
3. Replace Records
You can perform find and replace on any column.
Where Conditions: Add one or more conditions to select records for replacing. This is required field.
Column Name: Enter the name of column to update.
Replace: Enter the old or existing string or value to replace.
Replace With: Enter the new value to replace with.
4. Delete Records
Where Conditions: Add one or more conditions to delete records. This is required field.
Use Cases
- Republish Joomla articles
- Reset article hits
- Replace previous year to current year in article titles
- Delete old records from other extensions