Post Queries
You can fetch posts in your templates or PHP code using post queries.
{# Create a new post query #}
{% set myQuery = craft.socialPoster.posts() %}// Create a new post query
$myQuery = \verbb\socialposter\elements\Post::find();Once you’ve created a post query, you can set parameters on it to narrow down the results, and then execute it by calling .all(). An array of Post objects will be returned.
See Element Queries (opens new window) in the Craft docs to learn how element queries work.
Example
You can display the posts sent for an entry by doing the following.
- Create a post query with
craft.socialPoster.posts(). - Set the ownerId and limit parameters on it.
- Fetch the posts with
.all(). - Loop through the posts using a for (opens new window) tag to output their contents.
{# Create a post query with the 'ownerId' and 'limit' parameters #}
{% set postsQuery = craft.socialPoster.posts()
.ownerId(entry.id)
.limit(10) %}
{# Fetch the posts #}
{% set posts = postsQuery.all() %}
{# Display their contents #}
{% for post in posts %}
<p>{{ post.getAccount().name ?? 'Deleted account' }}, {{ post.dateCreated|date('short') }}: {{ post.success ? 'Sent' : 'Failed' }}</p>
{% endfor %}Parameters
Post queries support the following parameters.
Narrows the query results to posts sent from the accounts with the given IDs.
| Value | Fetches posts… |
|---|---|
1 | sent from the account with an ID of 1. |
[1, 2] | sent from the account with an ID of 1 or 2. |
'not 1' | not sent from the account with an ID of 1. |
{# Fetch posts sent from the account with an ID of 1 #}
{% set posts = craft.socialPoster.posts()
.accountId(1)
.all() %}// Fetch posts sent from the account with an ID of 1
$posts = \verbb\socialposter\elements\Post::find()
->accountId(1)
->all();Causes the query to return matching posts as arrays of data, rather than Post objects.
{# Fetch posts as arrays #}
{% set posts = craft.socialPoster.posts()
.asArray()
.all() %}// Fetch posts as arrays
$posts = \verbb\socialposter\elements\Post::find()
->asArray()
->all();Narrows the query results based on when the posts were created, which is when they were sent.
| Value | Fetches posts… |
|---|---|
'>= 2026-04-01' | created on or after 1 April 2026. |
'< 2026-05-01' | created before 1 May 2026. |
['and', '>= 2026-04-01', '< 2026-05-01'] | created during April 2026. |
{# Fetch posts sent last month #}
{% set start = date('first day of last month')|atom %}
{% set end = date('first day of this month')|atom %}
{% set posts = craft.socialPoster.posts()
.dateCreated(['and', ">= #{start}", "< #{end}"])
.all() %}// Fetch posts sent last month
$start = (new \DateTime('first day of last month'))->format(\DateTime::ATOM);
$end = (new \DateTime('first day of this month'))->format(\DateTime::ATOM);
$posts = \verbb\socialposter\elements\Post::find()
->dateCreated(['and', ">= {$start}", "< {$end}"])
->all();Narrows the query results based on when the posts were last updated.
| Value | Fetches posts… |
|---|---|
'>= 2026-04-01' | updated on or after 1 April 2026. |
'< 2026-05-01' | updated before 1 May 2026. |
{# Fetch posts updated in the last week #}
{% set lastWeek = date('1 week ago')|atom %}
{% set posts = craft.socialPoster.posts()
.dateUpdated(">= #{lastWeek}")
.all() %}// Fetch posts updated in the last week
$lastWeek = (new \DateTime('1 week ago'))->format(\DateTime::ATOM);
$posts = \verbb\socialposter\elements\Post::find()
->dateUpdated(">= {$lastWeek}")
->all();Causes the query results to be returned in the order specified by id.
{# Fetch posts in a specific order #}
{% set posts = craft.socialPoster.posts()
.id([1, 2, 3, 4, 5])
.fixedOrder()
.all() %}// Fetch posts in a specific order
$posts = \verbb\socialposter\elements\Post::find()
->id([1, 2, 3, 4, 5])
->fixedOrder()
->all();Narrows the query results based on the posts’ IDs.
| Value | Fetches posts… |
|---|---|
1 | with an ID of 1. |
'not 1' | not with an ID of 1. |
[1, 2] | with an ID of 1 or 2. |
['not', 1, 2] | not with an ID of 1 or 2. |
{# Fetch the posts with an ID of 1 or 2 #}
{% set posts = craft.socialPoster.posts()
.id([1, 2])
.all() %}// Fetch the posts with an ID of 1 or 2
$posts = \verbb\socialposter\elements\Post::find()
->id([1, 2])
->all();Combine this with fixedOrder to return the results in a specific order.
Causes the query results to be returned in reverse order.
{# Fetch posts in reverse order #}
{% set posts = craft.socialPoster.posts()
.inReverse()
.all() %}// Fetch posts in reverse order
$posts = \verbb\socialposter\elements\Post::find()
->inReverse()
->all();Determines the number of posts that should be returned.
{# Fetch up to 10 posts #}
{% set posts = craft.socialPoster.posts()
.limit(10)
.all() %}// Fetch up to 10 posts
$posts = \verbb\socialposter\elements\Post::find()
->limit(10)
->all();Determines how many posts should be skipped in the results.
{# Fetch all posts except the first 3 #}
{% set posts = craft.socialPoster.posts()
.offset(3)
.all() %}// Fetch all posts except the first 3
$posts = \verbb\socialposter\elements\Post::find()
->offset(3)
->all();Determines the order that the posts should be returned in.
{# Fetch the most recently sent posts first #}
{% set posts = craft.socialPoster.posts()
.orderBy('elements.dateCreated desc')
.all() %}// Fetch the most recently sent posts first
$posts = \verbb\socialposter\elements\Post::find()
->orderBy('elements.dateCreated desc')
->all();Narrows the query results to posts sent for the elements with the given IDs, usually entries.
| Value | Fetches posts… |
|---|---|
1 | sent for the element with an ID of 1. |
[1, 2] | sent for the element with an ID of 1 or 2. |
'not 1' | not sent for the element with an ID of 1. |
{# Fetch posts sent for the current entry #}
{% set posts = craft.socialPoster.posts()
.ownerId(entry.id)
.all() %}// Fetch posts sent for the current entry
$posts = \verbb\socialposter\elements\Post::find()
->ownerId($entry->id)
->all();Narrows the query results to posts sent from the sites with the given IDs.
| Value | Fetches posts… |
|---|---|
1 | sent from the site with an ID of 1. |
[1, 2] | sent from the site with an ID of 1 or 2. |
{# Fetch posts sent for an entry from the site with an ID of 2 #}
{% set posts = craft.socialPoster.posts()
.ownerId(entry.id)
.ownerSiteId(2)
.all() %}// Fetch posts sent for an entry from the site with an ID of 2
$posts = \verbb\socialposter\elements\Post::find()
->ownerId($entry->id)
->ownerSiteId(2)
->all();Narrows the query results based on the posts’ statuses. Posts are enabled when they’re created, so most queries don’t need this. Pass null to fetch posts regardless of status.
| Value | Fetches posts… |
|---|---|
'enabled' (default) | that are enabled. |
'disabled' | that are disabled. |
null | regardless of status. |
{# Fetch posts regardless of status #}
{% set posts = craft.socialPoster.posts()
.status(null)
.all() %}// Fetch posts regardless of status
$posts = \verbb\socialposter\elements\Post::find()
->status(null)
->all();Narrows the query results based on the posts’ UIDs.
{# Fetch the post by its UID #}
{% set post = craft.socialPoster.posts()
.uid('xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx')
.one() %}// Fetch the post by its UID
$post = \verbb\socialposter\elements\Post::find()
->uid('xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx')
->one();