[TYPO3-dev] sys_action and SQL query

[Martin Kutschker]

Steffen Kamper schrieb:
> Hi,
> 
> this is really a powerful one!
> Unfortunally it's not described how to build the query for the action,
> here short summary:
> 
> 1) create sys_action "SQL-query"
> 2) go to DB check -> Search Whole Database -> Advanced Query
> build your query and save to the created sys_action
> 
> Unfortunally this is admin_only, it would be nice to use such actions
> for editors, so you can define a complex query like "Show all comments
> from last week", "show all records of table_xyz" having flag abc =
> false" etc.

I thought that while you have to be admin to create the action, anyone
can use it as long as the admin sets it up for you.

Masi