nextcloud / server

		$query2->andWhere($or);

		// No need for like when the pattern is empty

		if ('' !== $pattern) {

			$query2->andWhere($query2->expr()->ilike('cp.value', $query->createNamedParameter('%' . $this->db->escapeLikeParameter($pattern) . '%')));

		}

		$query->select('c.carddata', 'c.uri')->from($this->dbCardsTable, 'c')

			->where($query->expr()->in('c.id', $query->createFunction($query2->getSQL())));

		}

		$innerQuery->andWhere($or);

		if ($pattern !== '') {

			$innerQuery->andWhere($innerQuery->expr()->iLike('op.value',

				$outerQuery->createNamedParameter('%' .

					$this->db->escapeLikeParameter($pattern) . '%')));

		}

		$outerQuery->select('c.id', 'c.calendardata', 'c.componenttype', 'c.uid', 'c.uri')

			->from('calendarobjects', 'c');