public function modifyElementsQuery(DbCommand $query, ElementCriteriaModel $criteria)
{
$query->addSelect('
workflow_submissions.ownerId,
workflow_submissions.draftId,
workflow_submissions.editorId,
workflow_submissions.publisherId,
workflow_submissions.status,
workflow_submissions.notes,
workflow_submissions.dateApproved,
workflow_submissions.dateRejected,
workflow_submissions.dateRevoked
')->join('workflow_submissions workflow_submissions', 'workflow_submissions.id = elements.id');
if ($criteria->ownerId) {
$query->andWhere(DbHelper::parseParam('workflow_submissions.ownerId', $criteria->ownerId, $query->params));
}
if ($criteria->draftId) {
$query->andWhere(DbHelper::parseParam('workflow_submissions.draftId', $criteria->draftId, $query->params));
}
if ($criteria->editorId) {
$query->andWhere(DbHelper::parseParam('workflow_submissions.editorId', $criteria->editorId, $query->params));
}
if ($criteria->publisherId) {
$query->andWhere(DbHelper::parseParam('workflow_submissions.publisherId', $criteria->publisherId, $query->params));
}
if ($criteria->status) {
$query->andWhere(DbHelper::parseParam('workflow_submissions.status', $criteria->status, $query->params));
}
if ($criteria->notes) {
$query->andWhere(DbHelper::parseParam('workflow_submissions.notes', $criteria->notes, $query->params));
}
if ($criteria->dateApproved) {
$query->andWhere(DbHelper::parseDateParam('workflow_submissions.dateApproved', $criteria->dateApproved, $query->params));
}
if ($criteria->dateRejected) {
$query->andWhere(DbHelper::parseDateParam('workflow_submissions.dateRejected', $criteria->dateRejected, $query->params));
}
if ($criteria->dateRevoked) {
$query->andWhere(DbHelper::parseDateParam('workflow_submissions.dateRevoked', $criteria->dateRevoked, $query->params));
}
if ($criteria->dateCreated) {
$query->andWhere(DbHelper::parseDateParam('workflow_submissions.dateCreated', $criteria->dateCreated, $query->params));
}
}