[TYPO3-dev] ext sys_action

[JoH asenau]

> "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