Submission Queries

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

// Fetch submissions 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);

$submissions = \verbb\workflow\elements\Submission::find()
    ->dateCreated(['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 submissions that are still in progress
$submissions = \verbb\workflow\elements\Submission::find()
    ->isComplete(false)
    ->all();

// Fetch submissions waiting for review
$submissions = \verbb\workflow\elements\Submission::find()
    ->isPending(true)
    ->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 submissions with the most recently reviewed first
$submissions = \verbb\workflow\elements\Submission::find()
    ->orderBy('lastReviewDate desc')
    ->all();

// Fetch submissions for the draft being edited
$submissions = \verbb\workflow\elements\Submission::find()
    ->ownerId($entry->getCanonicalId())
    ->ownerDraftId($entry->draftId)
    ->all();

// Fetch submissions made on this entry
$submissions = \verbb\workflow\elements\Submission::find()
    ->ownerId($entry->id)
    ->all();

// Fetch submissions made on this entry in the current site
$submissions = \verbb\workflow\elements\Submission::find()
    ->ownerId($entry->id)
    ->ownerSiteId(Craft::$app->getSites()->getCurrentSite()->id)
    ->all();

// Fetch submissions the current user has acted on as a publisher
$user = Craft::$app->getUser()->getIdentity();

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

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

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

// Fetch submissions a reviewer has approved or rejected most recently
$submissions = \verbb\workflow\elements\Submission::find()
    ->role('reviewer')
    ->all();

// Fetch submissions from the site with an ID of 2
$submissions = \verbb\workflow\elements\Submission::find()
    ->siteId(2)
    ->all();

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

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

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