Session Queries

// Fetch sessions that don’t belong to event drafts
$sessions = \verbb\events\elements\Session::find()
    ->allowOwnerDrafts(false)
    ->all();

// Fetch sessions that don’t belong to event revisions
$sessions = \verbb\events\elements\Session::find()
    ->allowOwnerRevisions(false)
    ->all();

// Fetch sessions as arrays
$sessions = \verbb\events\elements\Session::find()
    ->asArray()
    ->all();

// Fetch sessions with a capacity of 100 or more
$sessions = \verbb\events\elements\Session::find()
    ->capacity('>= 100')
    ->all();

// Fetch sessions created last month
$start = (new \DateTime('first day of last month'))->format(\DateTime::ATOM);
$end = (new \DateTime('first day of this month'))->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->dateCreated(['and', ">= {$start}", "< {$end}"])
    ->all();

// Fetch sessions updated in the last week
$lastWeek = (new \DateTime('1 week ago'))->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->dateUpdated(">= {$lastWeek}")
    ->all();

// Fetch sessions that finish today or later
$today = (new \DateTime('today'))->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->endDate(">= {$today}")
    ->all();

// Fetch sessions for an event
$sessions = \verbb\events\elements\Session::find()
    ->event($event)
    ->all();

// Fetch sessions for the event with an ID of 1
$sessions = \verbb\events\elements\Session::find()
    ->eventId(1)
    ->all();

// Fetch sessions in a specific order
$sessions = \verbb\events\elements\Session::find()
    ->id([1, 2, 3, 4, 5])
    ->fixedOrder()
    ->all();

// Fetch the other sessions in the same recurring group
$sessions = \verbb\events\elements\Session::find()
    ->groupUid($session->groupUid)
    ->all();

// Fetch sessions for live conference events
$sessions = \verbb\events\elements\Session::find()
    ->hasEvent(['type' => 'conference', 'status' => 'live'])
    ->all();

// Fetch the session by its ID
$session = \verbb\events\elements\Session::find()
    ->id(1)
    ->one();

// Fetch sessions in reverse
$sessions = \verbb\events\elements\Session::find()
    ->inReverse()
    ->all();

// Fetch recurring sessions
$sessions = \verbb\events\elements\Session::find()
    ->isRecurring(true)
    ->all();

// Fetch up to 10 sessions
$sessions = \verbb\events\elements\Session::find()
    ->limit(10)
    ->all();

// Fetch all sessions except for the first 3
$sessions = \verbb\events\elements\Session::find()
    ->offset(3)
    ->all();

// Fetch all sessions in order of date created
$sessions = \verbb\events\elements\Session::find()
    ->orderBy('elements.dateCreated asc')
    ->all();

// Fetch sessions owned by an event
$sessions = \verbb\events\elements\Session::find()
    ->owner($event)
    ->all();

// Fetch sessions owned by the event with an ID of 1
$sessions = \verbb\events\elements\Session::find()
    ->ownerId(1)
    ->all();

// Fetch sessions created on an event
$sessions = \verbb\events\elements\Session::find()
    ->primaryOwner($event)
    ->all();

// Fetch sessions created on the event with an ID of 1
$sessions = \verbb\events\elements\Session::find()
    ->primaryOwnerId(1)
    ->all();

// Fetch all sessions that are related to myCategory
$sessions = \verbb\events\elements\Session::find()
    ->relatedTo($myCategory)
    ->all();

// Fetch all sessions that match the search query
$searchQuery = \Craft::$app->getRequest()->getQueryParam('q');

$sessions = \verbb\events\elements\Session::find()
    ->search($searchQuery)
    ->all();

// Fetch sessions from the Foo site
$sessions = \verbb\events\elements\Session::find()
    ->site('foo')
    ->all();

// Fetch sessions from the site with an ID of 1
$sessions = \verbb\events\elements\Session::find()
    ->siteId(1)
    ->all();

// Fetch sessions that start today or later
$today = (new \DateTime('today'))->format(\DateTime::ATOM);

$sessions = \verbb\events\elements\Session::find()
    ->startDate(">= {$today}")
    ->all();

// Fetch disabled sessions
$sessions = \verbb\events\elements\Session::find()
    ->status('disabled')
    ->all();

// Fetch sessions with a title that contains "Foo"
$sessions = \verbb\events\elements\Session::find()
    ->title('*Foo*')
    ->all();

// Fetch the session by its UID
$session = \verbb\events\elements\Session::find()
    ->uid('xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx')
    ->one();

// Fetch sessions eager-loaded with the “Related” field’s relations
$sessions = \verbb\events\elements\Session::find()
    ->with(['related'])
    ->all();