​

Submission Queries#

// Fetch all submissions, regardless of status
$submissions = \verbb\workflow\elements\Submission::find()
    ->anyStatus()
    ->all();

// Fetch submissions as arrays
$submissions = \verbb\workflow\elements\Submission::find()
    ->asArray()
    ->all();

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

$submissions = \verbb\workflow\elements\Submission::find()
    ->dateApproved(['and', ">= {$start}", "< {$end}"])
    ->all();

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

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

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

$submissions = \verbb\workflow\elements\Submission::find()
    ->dateRejected(['and', ">= {$start}", "< {$end}"])
    ->all();

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

$submissions = \verbb\workflow\elements\Submission::find()
    ->dateRevoked(['and', ">= {$start}", "< {$end}"])
    ->all();

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

$submissions = \verbb\workflow\elements\Submission::find()
    ->dateUpdated(">= {$lastWeek}")
    ->all();

// Fetch the current user's submissions
$user = Craft::$app->getUser()->getIdentity();

$submissions = \verbb\workflow\elements\Submission::find()
    ->editorId($user->id)
    ->all();

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

// Fetch the submission by its ID
$submission = \verbb\workflow\elements\Submission::find()
    ->id(1)
    ->one();

// Fetch submissions in reverse
$submissions = \verbb\workflow\elements\Submission::find()
    ->inReverse()
    ->all();

// Fetch up to 10 submissions
$submissions = \verbb\workflow\elements\Submission::find()
    ->limit(10)
    ->all();

// Fetch all submissions except for the first 3
$submissions = \verbb\workflow\elements\Submission::find()
    ->offset(3)
    ->all();

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

// Fetch submissions created for this entry
$submissions = \verbb\workflow\elements\Submission::find()
    ->owner($myEntry)
    ->all();

// Fetch submissions created for an element with an ID of 1
$submissions = \verbb\workflow\elements\Submission::find()
    ->ownerId(1)
    ->all();

// Fetch submissions created for an element with an ID of 1, for a site with a handle of 'foo'
$submissions = \verbb\workflow\elements\Submission::find()
    ->ownerId(1)
    .ownerSite('foo')
    ->all();

// Fetch submissions created for an element with an ID of 1, for a site with an ID of 2
$submissions = \verbb\workflow\elements\Submission::find()
    ->ownerId(1)
    .ownerSiteId(2)
    ->all();

// Fetch the current user's submissions
$user = Craft::$app->getUser()->getIdentity();

$submissions = \verbb\workflow\elements\Submission::find()
    ->publisherId($user->id)
    ->all();

// Fetch disabled submissions
$submissions = \verbb\workflow\elements\Submission::find()
    ->status('disabled')
    ->all();

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