De:TSref/select
This page is document in progress. TypoScript (Liste TypoScript)weitere Typoscript Funktionen
select
This object generates an SQL-select statement needed to select records from the database.
Is used by the CONTENT Object.
Some records are hidden or timed by start and end-times. This is automatically added to the SQL-select by looking in the tables.php-array (enablefields)
Also, if the "pidInList" feature is used, any page in the pid-list that is not visible for the user of the website IS REMOVED from the pidlist. Thereby no records from hidden, timed or access-protected pages are selected! Nor records from recyclers.
| Property: | Data type: | Description: | Default:
|
| uidInList | list of page_id | ||
| pidInList | list of page_id /stdWrap | this | |
| orderBy | SQL-orderBy | without "order by"! Eg. "sorting, title" | |
| groupBy | SQL-groupBy | without "group by"! Eg. "CType" | |
| max | int
+calc +"total" |
max records
Special keyword: "total" is substituted with count(*) | |
| begin | int
+calc +"total" |
begin with record number value
Special keyword: "total" is substituted with count(*) | |
| where | SQL-where | without "where"!, Eg. " (title LIKE '%SOMETHING%' AND NOT doktype) " | |
| andWhere | SQL-where /stdWrap | without "AND"!, Eg. "NOT doktype". | |
| languageField | string | If set, this points to the field in the record which holds a reference to a record in sys_language table. And if set, the records returned by the select-function will be selected only if the value of this field matches the $GLOBALS[TSFE]->sys_language_uid (which is set by the config.sys_language_uid option) | |
| selectFields | string | List of fields to select, or count(*). | * |
| join
leftjoin rightjoin |
string | Enter tablename for JOIN , LEFT OUTER JOIN and RIGHT OUTER JOIN respectively. |
[tsref:->select]
