[TYPO3-seminars] default-values for element-browser

[Oliver Hauser | SIVA creative]

Hi Kerstin,

this is a general typo3 question...

try to change the tca

bla
bla
bla

'type' => 'select',
foreign_table' => 'fe_user',
// here_comes_youre_request -  for eaxample:
'foreign_table_where' => 'ORDER BY fe_user.title DESC',
bla
bla
bla

The items from "foreign_table" are selected with this WHERE-clause.

The table is joined with the "pages"-table and items are selected only 
from pages where the user has read access! (Not checking DB mount 
limitations!)

Example:

AND [foreign_table].pid=0 ORDER BY [foreign_table].sorting

Markers:

You can use markers in the WHERE clause:

    1.

       ###REC_FIELD_[fieldname]###
    2.

       ###THIS_UID### - is current element uid (zero if new).
    3.

       ###CURRENT_PID### - is the current page id (pid of the record).
    4.

       ###STORAGE_PID###
    5.

       ###SITEROOT###
    6.

       ###PAGE_TSCONFIG_ID### -  a value you can set from Page TSconfig 
dynamically.
    7.

       ###PAGE_TSCONFIG_IDLIST### -  a value you can set from Page 
TSconfig dynamically.
    8.

       ###PAGE_TSCONFIG_STR### -  a value you can set from Page TSconfig 
dynamically.

The markers are preprocessed so that the value of CURRENT_PID and 
PAGE_TSCONFIG_ID are always integers (default is zero), 
PAGE_TSCONFIG_IDLIST will always be a commalist of integers (default is 
zero) and PAGE_TSCONFIG_STR will be addslashes'ed before substitution 
(default is blank string).

See documentation:

http://typo3.org/documentation/document-library/core-documentation/doc_core_api/4.0.0/view/4/2/



Mit freundlichen Grüßen / with kind regards

Oliver Hauser



Am 07.06.2010 13:18, schrieb Kerstin Finke:
> Hi list,
>
> when I start a new registration in the backend (list module) I have to 
> select both the Seminar and the Frontend-user by using the 
> element-browsers.
>
> I would like to configure the element browser so that I get the right 
> list (of seminars or feusers) without having to browse to it in the 
> page tree.
> Typo3 always seems to remember the last value, so when I selected the 
> fe-users in the page-tree before, it gives me the right list again 
> when I select the element-browser Frontend-User again. But when I was 
> on the seminars-list before, I have to search my sysfolder fe-users 
> again.
>
> I tried to configure this by putting this in the ext_tables.php:
>
> $TCA['tx_seminars_attendances']['columns']['user']['config']['default'] = 
> 'fe_users';
>
> But it does not show any effect.
> Is there any way to do this?
>
> Greetings
> Kerstin
> _______________________________________________
> TYPO3-project-seminars mailing list
> TYPO3-project-seminars at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-project-seminars