Item Queries

// Fetch items as arrays
$items = \verbb\wishlist\elements\Item::find()
    ->asArray()
    ->all();

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

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

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

$items = \verbb\wishlist\elements\Item::find()
    ->dateUpdated(">= {$lastWeek}")
    ->all();

// Fetch items created for an element with the provided class
$items = \verbb\wishlist\elements\Item::find()
    ->elementClass(\craft\elements\Entry::class)
    ->all();

// Fetch items created for an element with an ID of 1
$items = \verbb\wishlist\elements\Item::find()
    ->elementId(1)
    ->all();

// Fetch items created for an element with an ID of 1, for a site with an ID of 2
$items = \verbb\wishlist\elements\Item::find()
    ->elementId(1)
    ->elementSiteId(2)
    ->all();

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

// Fetch the item by its ID
$item = \verbb\wishlist\elements\Item::find()
    ->id(1)
    ->one();

// Fetch items in reverse
$items = \verbb\wishlist\elements\Item::find()
    ->inReverse()
    ->all();

// Fetch up to 10 items
$items = \verbb\wishlist\elements\Item::find()
    ->limit(10)
    ->all();

// Fetch items in the list with an ID of 1
$items = \verbb\wishlist\elements\Item::find()
    ->listId(1)
    ->all();

// Fetch items in lists of the Favourites list type
$items = \verbb\wishlist\elements\Item::find()
    ->listTypeHandle('favourites')
    ->all();

// Fetch items in lists of the list type with an ID of 1
$items = \verbb\wishlist\elements\Item::find()
    ->listTypeId(1)
    ->all();

// Fetch all items except for the first 3
$items = \verbb\wishlist\elements\Item::find()
    ->offset(3)
    ->all();

// Fetch the item for an element in size large
$item = \verbb\wishlist\elements\Item::find()
    ->listId($list->id)
    ->elementId($product->id)
    ->options(['size' => 'large'])
    ->one();

// Fetch items that share an item’s options
$items = \verbb\wishlist\elements\Item::find()
    ->optionsSignature($item->optionsSignature)
    ->all();

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

// Get the search query from the 'q' query string param
$searchQuery = \Craft::$app->getRequest()->getQueryParam('q');

// Fetch all items that match the search query
$items = \verbb\wishlist\elements\Item::find()
    ->search($searchQuery)
    ->all();

// Fetch disabled items
$items = \verbb\wishlist\elements\Item::find()
    ->status('disabled')
    ->all();

// Fetch all items, regardless of status
$items = \verbb\wishlist\elements\Item::find()
    ->status(null)
    ->all();

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

// Fetch items eager-loaded with their linked elements
$items = \verbb\wishlist\elements\Item::find()
    ->listId($list->id)
    ->with(['element'])
    ->all();