[TYPO3-dev] ext sys_action

[Steffen Kamper]

Hi Andreas,

"Andreas Otto" <andreas.otto at dkd.de> schrieb im Newsbeitrag 
news:mailman.1.1187709277.30461.typo3-dev at lists.netfielders.de...
> Hi Steffen,
>
> Steffen Kamper wrote:
>> i tried first time to make an action "SQL-Query", goal was to make an
>> action for empty index-tables.
>
> I can't follow you. Can you explain what kind of query you tried?
>
> The action itself works still fine in 4.1.x:
>
> Sample sql query with action
> Type:   SQL-query
> Description:    Just a sample sql query which gets executed by an action.
>
> Result of query
> uid     username
> 1       test
> 12345   a.otto
> 12346   test0
> 12347   test1
> 12348   test2
> 12349   test3
> 12350   test4
> 12351   test5
> SELECT uid,username,pid,deleted
>                        FROM fe_users
>                        WHERE
>                                (
> fe_users.username LIKE '%%')
>                        LIMIT 100
>
>
> Cheers,
> Andreas
>

i wonder how you could enter a query, I can't do because there is no field 
to enter the query
http://www.sk-typo3.de/fileadmin/ss/ss_sysaction.jpg

and my goal was to execute some truncates to index-tables.

vg  Steffen