[TYPO3-dev] ext sys_action

[Steffen Kamper]

Hi Joey,

"JoH asenau" <info at cybercraft.de> schrieb im Newsbeitrag 
news:mailman.1.1187739033.8208.typo3-dev at lists.netfielders.de...
>> "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
>>
>> 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.
>
> First you have to "create" the query with the form shown in your jpg.
> Then you have to really create a query using
>
> DB check => full search => avdanced query
>
> If you created at least one query element first, you will be able to "save
> to action" using the LOAD/SAVE QUERY select box.
>
> HTH
>
> Joey
>
> -- 
> Wenn man keine Ahnung hat: Einfach mal Fresse halten!
> (If you have no clues: simply shut your gob sometimes!)
> Dieter Nuhr, German comedian
> openBC/Xing: http://www.cybercraft.de
> T3 cookbook: http://www.typo3experts.com
>
>

nice trick - where is such way described ?
I tried but was not successful. I saved my query, then i have my action in 
the selectbox. If i choose it and save, empty query is saved.
how do i save my query to the action ?

vg  Steffen