[TYPO3-dev] Only showing a subset of items in a selectbox

[Thorsten Kahler [dkd]]

Hi Thomas,

schrieb Thomas "Thasmo" Deinhamer am 05.09.10 23:14:
> 
> For "filtering" the records I can think of these solutions:
> 1) Use the general record storage page.
> 2) Don't use a select field, but a group (db) field.
> 3) Use a custom foreign_where statement to match desired records.
> 

amongst all the thoughts already mentioned I'd like to point you to Page
TSConfig.

By using TCEFORM.<table>.<field>.PAGE_TSCONFIG_ID or
TCEFORM.<table>.<field>.PAGE_TSCONFIG_IDLIST it's easy to restrict
record listings to a certain page or list of pages (see [1]). These
constants have to be used in the foreign_table_where statement [2] (e.g.
"AND <foreign_table>.pid in ###PAGE_TSCONFIG_IDLIST##") in your TCA.

This only affects the BE so it should not interfere with Extbase. In
respect of flexibility this solution is superior to the "general record
storage page" and extension configuration settings.

The new Ajax suggest feature might improve the handling for your
editors. It's set up in TCEFORM property of TSConfig as well.

Cheers,
Thorsten


[1]
<http://typo3.org/documentation/document-library/core-documentation/doc_core_tsconfig/4.3.2/view/1/5/#id2506417>
[2]
<http://typo3.org/documentation/document-library/core-documentation/doc_core_api/4.3.0/view/4/2/#id2522688>

-- 

Thorsten Kahler
thorsten.kahler at dkd.de