TaskQueryBuilder::getNotViewedField

private function getNotViewedField(): ExpressionField
{
	$this->joinByAlias(self::ALIAS_TASK_VIEW);

	return new ExpressionField(
		"NOT_VIEWED",
		'CASE
			WHEN
				%3$s IS NULL
				AND
				%2$s != '. $this->taskQuery->getBehalfUser() .'
				AND
				(%1$s = '. Status::NEW .' OR %1$s = '. Status::PENDING .')
			THEN
				'Y'
			ELSE
				'N'
		END',
		["STATUS", "CREATED_BY", self::ALIAS_TASK_VIEW.".USER_ID"]
	);
}