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]
