DatabaseQuerySelect class

Located in file /wire/core/DatabaseQuerySelect.php

Click any linked item for full usage details and examples. Hookable methods are indicated with the icon. In addition to those shown below, the DatabaseQuerySelect class also inherits all the methods and properties of: DatabaseQuery, WireData and Wire.

Show class?             Show args?        

Common

NameReturnSummary 
DatabaseQuerySelect::comment string Comments for query 
DatabaseQuerySelect::field Field Field object that is referenced by this query. 
DatabaseQuerySelect::from($sql)
$this
Can also be used as property: DatabaseQuerySelect::from
DatabaseQuerySelect::getQuery()
(nothing)Return the resulting SQL ready for execution with the database 
DatabaseQuerySelect::group string Selector group (for OR-groups) if applicable. 
DatabaseQuerySelect::groupby($sql)
$this
Can also be used as property: DatabaseQuerySelect::groupby
DatabaseQuerySelect::join($sql)
$this)
Can also be used as property: DatabaseQuerySelect::join
DatabaseQuerySelect::leftjoin($sql)
$this)
Can also be used as property: DatabaseQuerySelect::leftjoin
DatabaseQuerySelect::limit($sql)
$this
Can also be used as property: DatabaseQuerySelect::limit
DatabaseQuerySelect::orderby($value)
$thisAdd an 'order by' element to the query
Can also be used as property: DatabaseQuerySelect::orderby
 
DatabaseQuerySelect::parentQuery DatabaseQuerySelect Parent query object, if applicable. 
DatabaseQuerySelect::select($sql)
$this)
Can also be used as property: DatabaseQuerySelect::select
DatabaseQuerySelect::selector Selector Selector object referenced by this query. 
DatabaseQuerySelect::selectors Selectors Original selectors (all) that $selector is part of.  
DatabaseQuerySelect::where($sql)
$this)
Can also be used as property: DatabaseQuerySelect::where

Additional methods and properties

In addition to the methods and properties above, DatabaseQuerySelect also inherits the methods and properties of these classes:

API reference based on ProcessWire core version 3.0.148

Twitter updates

  • ProcessWire 3.0.153 (dev) focuses on comments field updates, significant refactoring/improvements to ProcessWire’s core Template class and PagesLoader class (which is used by the pages API variable), and we introduce a useful new pages API method— More
    20 March 2020
  • ProcessWire 3.0.152 core updates— This week we have some major improvements to our core date/time Inputfield, as well as a new ability to specify your own custom classes for Page objects— More
    6 March 2020
  • This week we’ve got a couple of really useful API-side improvements to the core in 3.0.151, including predefined image settings and static language translation improvements— More
    21 February 2020

Latest news

  • ProcessWire Weekly #307
    In the 307th issue of ProcessWire Weekly we're going to check out the latest dev branch updates, introduce some new third party modules, and more. Read on!
    Weekly.pw / 28 March 2020
  • ProcessWire 3.0.153 core updates
    This latest version of the core on the dev branch focuses on comments field updates, significant refactoring/improvements to ProcessWire’s core Template class and PagesLoader class (which is used by the $pages API variable), and we introduce a useful new $pages API method.
    Blog / 20 March 2020
  • Subscribe to weekly ProcessWire news

“We chose ProcessWire because of its excellent architecture, modular extensibility and the internal API. The CMS offers the necessary flexibility and performance for such a complex website like superbude.de. ProcessWire offers options that are only available for larger systems, such as Drupal, and allows a much slimmer development process.” —xport communication GmbH