[TYPO3-english] Direct Mail special query mode in the recipient list

[PIT Solutions]

Hi All,

I am trying to create a new recipient list in the directmail configuration using special query mode. 

My typo3 version is 4.5.3 and my direct mail version is 2.7.0.


Actual problem is I can't edit the default query "SELECT uid,pid,deleted FROM tt_address WHERE (
uid = '1') AND tt_address.deleted=0 ".
This is showed the recipient list from the tt_address table.

But I want to retrieve the recipient list from the direct mail table from the DB.
I've added the table name in TS Config settings using the code "mod.web_modules.dmail.userTable".But not works.

I want to write my own query instead of default query.

Is it possible using the special query mode of directmail?
Please give an answer.

Thanks in Advance,
    Arun Chandran.