TSRef - TypoScript Reference
5.1.5. select:
This object generates an SQL-select statement needed to select records from the database.
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]