Comment Queries

// Fetch comments above this one
$comments = \verbb\comments\elements\Comment::find()
    ->ancestorOf($comment)
    ->ancestorDist(3)
    ->all();

// Fetch comments above this one
$comments = \verbb\comments\elements\Comment::find()
    ->ancestorOf($comment)
    ->all();

// Fetch comments as arrays
$comments = \verbb\comments\elements\Comment::find()
    ->asArray()
    ->all();

// Fetch comments that mention Craft
$comments = \verbb\comments\elements\Comment::find()
    ->comment('*Craft*')
    ->all();

// Fetch comments posted last month
$start = (new \DateTime('first day of last month'))->format(\DateTime::ATOM);
$end = (new \DateTime('first day of this month'))->format(\DateTime::ATOM);

$comments = \verbb\comments\elements\Comment::find()
    ->commentDate(['and', ">= {$start}", "< {$end}"])
    ->all();

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

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

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

$comments = \verbb\comments\elements\Comment::find()
    ->dateUpdated(">= {$lastWeek}")
    ->all();

// Fetch comments below this one
$comments = \verbb\comments\elements\Comment::find()
    ->descendantOf($comment)
    ->descendantDist(3)
    ->all();

// Fetch comments below this one
$comments = \verbb\comments\elements\Comment::find()
    ->descendantOf($comment)
    ->all();

// Fetch comments from users with a .co.uk domain on their email address
$comments = \verbb\comments\elements\Comment::find()
    ->email('*.co.uk')
    ->all();

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

// Fetch comments that have descendants
$comments = \verbb\comments\elements\Comment::find()
    ->hasDescendants()
    ->all();

// Fetch the comment by its ID
$comment = \verbb\comments\elements\Comment::find()
    ->id(1)
    ->one();

// Fetch comments in reverse
$comments = \verbb\comments\elements\Comment::find()
    ->inReverse()
    ->all();

// Fetch comments posted from an IP address
$comments = \verbb\comments\elements\Comment::find()
    ->ipAddress('203.0.113.7')
    ->all();

// Fetch comments that are flagged
$comments = \verbb\comments\elements\Comment::find()
    ->isFlagged(true)
    ->all();

// Fetch comments that have no descendants
$comments = \verbb\comments\elements\Comment::find()
    ->leaves()
    ->all();

// Fetch comments positioned at level 3 or above
$comments = \verbb\comments\elements\Comment::find()
    ->level('>= 3')
    ->all();

// Fetch up to 10 comments
$comments = \verbb\comments\elements\Comment::find()
    ->limit(10)
    ->all();

// Fetch comments posted by guests named Jane
$comments = \verbb\comments\elements\Comment::find()
    ->name('Jane*')
    ->all();

// Fetch the next comment
$comment = \verbb\comments\elements\Comment::find()
    ->nextSiblingOf($comment)
    ->one();

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

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

// Fetch the highest-rated comments on this entry
$topComments = \verbb\comments\elements\Comment::find()
    ->owner($entry)
    ->orderBy('voteCount DESC')
    ->limit(5)
    ->all();

// Fetch comments created for this entry
$comments = \verbb\comments\elements\Comment::find()
    ->owner($entry)
    ->all();

// Fetch comments made on Article entries
$comments = \verbb\comments\elements\Comment::find()
    ->ownerEntryType('article')
    ->all();

// Fetch comments made on entries with an entry type ID of 4
$comments = \verbb\comments\elements\Comment::find()
    ->ownerEntryTypeId(4)
    ->all();

// Fetch comments created for an element with an ID of 1
$comments = \verbb\comments\elements\Comment::find()
    ->ownerId(1)
    ->all();

// Fetch comments made on entries in the News and Blog sections
$comments = \verbb\comments\elements\Comment::find()
    ->ownerSection(['news', 'blog'])
    ->all();

// Fetch comments made on entries in the section with an ID of 22
$comments = \verbb\comments\elements\Comment::find()
    ->ownerSectionId(22)
    ->all();

// Fetch comments made in the French site
$comments = \verbb\comments\elements\Comment::find()
    ->ownerSite('fr')
    ->all();

// Fetch comments made in the site with an ID of 2
$comments = \verbb\comments\elements\Comment::find()
    ->ownerSiteId(2)
    ->all();

// Fetch comments for specific element type
$comments = \verbb\comments\elements\Comment::find()
    ->ownerType(craft\elements\Entry::class)
    ->all();

// Fetch comments after this one
$comments = \verbb\comments\elements\Comment::find()
    ->positionedAfter($comment)
    ->all();

// Fetch comments before this one
$comments = \verbb\comments\elements\Comment::find()
    ->positionedBefore($comment)
    ->all();

// Fetch the previous comment
$comment = \verbb\comments\elements\Comment::find()
    ->prevSiblingOf($comment)
    ->one();

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

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

// Fetch comments beside this one
$comments = \verbb\comments\elements\Comment::find()
    ->siblingOf($comment)
    ->all();

// Fetch comments from the French site
$comments = \verbb\comments\elements\Comment::find()
    ->site('fr')
    ->all();

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

// Fetch comments with any status
$comments = \verbb\comments\elements\Comment::find()
    ->status(null)
    ->all();

// Fetch pending comments
$comments = \verbb\comments\elements\Comment::find()
    ->status('pending')
    ->all();

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

// Fetch comments posted from the blog
$comments = \verbb\comments\elements\Comment::find()
    ->url('*/blog/*')
    ->all();

// Fetch comments posted from Firefox
$comments = \verbb\comments\elements\Comment::find()
    ->userAgent('*Firefox*')
    ->all();

// Fetch the current user's comments
$user = Craft::$app->getUser()->getIdentity();

$comments = \verbb\comments\elements\Comment::find()
    ->userId($user->id)
    ->all();