Filters allow you to find specific rows from a database table. Actions allow you to do something with those rows.
The following actions are available:
- No action – just display the search results.
- Global text replace – if you enter a global search phrase then the global text replace will replace that phrase wherever it is matched.
- Modify matches – construct a powerful set of modifications to the matched row. Described further below.
- Export matches – export matched data to CSV, SQL, or JSON
- Delete matches – delete all matching rows from the database
- Run action – run a WordPress action (
do_action) for each matching row. This can be used for custom functionality
Modify matches
You can modify any number of columns in each matched row by clicking the ‘add’ button:
The kind of modification you can perform depends on the column being modified. Some columns cannot be modified (for example, IDs).
- Text
- Set – replace the original value with a new value
- Replace – replace a sub value. Regular expressions are available
- Date
- Set – replace with the new date
- Increment – add to the existing value
- Decrement – subtract from the existing value
- Number
- Set – replace with the new value
- Increment – add to the existing value
- Decrement – subtract from the existing value
- Member – set the current value, add a value, or remove a value
For example, you can use this action to:
- Add a category to all matching posts
- Increment a date if the timezone is wrong
Only one modification can be performed on a column, but it is possible to modify multiple columns.