TSref/select

From TYPO3Wiki

TSref/select

Translations	info
An english page for every translation. All pagenames in english. en de nl fr ja zh

TypoScript This page is document in progress.

other Typoscript functions

[edit]

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.