Ghost Filter Query examples

examples.md

Filter Queries - Example Use Cases

Here are a few example use cases, these use cases combine filter with other parameters to make useful API queries. The syntax for any of this may change between now, implementation, and release - they're meant as illustrative examples :)

Fetch 3 posts with tags which match 'photo' or 'video' and aren't the post with id 5.

api.posts.browse({filter: "tags:[photo, video] + id:-5", limit="3"});

GET /api/posts?filter=tags%3A%5Bphoto%2Cvideo%5D%2Bid%3A-5&limit=3

{{#get "posts" filter="tags:[photo,video]+id:-5" limit="3"}}

Fetch posts which have either a tag of 'photo', are marked 'featured' or have an image

api.posts.browse({filter: "tag:photo,featured:true,image:-null"})

GET /api/posts?filter=tag%3Aphoto%2Cfeatured%3Atrue%2Cimage%3A-null

{{#get "posts" filter="tag:photo,featured:true,image:-null"}}

Fetch all tags, ordered by post count, where the post count is at least 1

api.tags.browse({filter: "post.count:>=1", order: "posts.count DESC", limit: "all"})

GET /api/tags?filter=post.count:>=1&order=posts.count%20DESC&limit=all

{{#get "tags" filter="post.count:>=1" order="posts.count DESC" limit="all"}}

Fetch posts by the author 'hannah' which are marked as featured

api.posts.browse({filter: "author:hannah+featured:true"});

GET /api/posts?filter=author:hannah%2Bfeatured:true

{{#get "posts" filter="author:hannah+featured:true"}}

Fetch the 3 most prolific users who write posts with the tag 'photo' ordered by most posts

api.users.browse({filter: "posts.tags:photo", order: "posts.count DESC", limit: 3});

GET /api/users?filter=posts.tags:photo&order=posts.count%20DESC&limit=3

{{#get "users" filter="posts.tags:photo" order="posts.count DESC" limit="3"}}

Fetch 5 posts after a given date

api.posts.browse({filter: "published_at:>'2015-07-20'", limit: 5});

GET /api/posts?filter=published_at:%3E'2015-07-20'&limit=5

{{#get "posts" filter="published_at:>'2015-07-20'" limit="5"}}

How would you filter to have posts with both tags video and photo ?

Hello,
I did'nt get to filter several tags neither...
What I tried, no one seems to work:

tags:one+two
tags:one+tags:two
tags.slug:one+tags.slug:two
tags:[one+two]
tags.slug:[one+two]
tags:(one+two)

How do you get one post that has X tag on it?

I am interested in the above question as well.

How to use the value of variable as a string in the filter.

I'm trying to filter all posts with the tag value given by {{tags from="2"}}, but I can't.

Hey Hannah @ErisDS is there any way to filter substring.

Eg. I want to have a navigation with only some tags.

E.g tags that have the description with tag #features

I'm interested in also filtering out a tag, which I can't seem to figure out.

Tried with:

tags: -tag
tags: [-tag]
tags: -[tag]
tags: [tag1, tag2, -tag3]

No clue what to do so far, or if this is possible.

A workaround to use posts that have both tag one AND two

{{#get "posts" filter="tags:one" include="tags"}}
	{{#foreach posts}}
		{{#has tag="two"}}
			<div class="recent-title"><a href="{{url}}">{{title}}</a></div>
		{{/has}}
	{{/foreach}}
{{/get}}

Also, to filter out a tag, just use ^has for hasn't

any ideas for pulling a random post?

any ideas for pulling a random post?

Just pull X number of posts with determined Limit=m

Great

Hi, can anyone Please tell me how can i get all posts have hash tag (internal tag or private tag). Actually i did not find custom post type in Ghost that's why i ma filtering posts having specific has tag post. Is there any better way to do this. ?

how do i get random 5 tags?

good job

Is there a way to fetch 3 posts that do not match certain tags?

Fetch 3 posts with tags which match 'photo' or 'video' and aren't the post with id 5.
api.posts.browse({filter: "tags:[photo, video] + id:-5", limit="3"});

GET /api/posts?filter=tags%3A%5Bphoto%2Cvideo%5D%2Bid%3A-5&limit=3

{{#get "posts" filter="tags:[photo,video]+id:-5" limit="3"}}

To filter posts with more than one tag (AND):

E.g: unama AND ead

{filter: "tags:unama+tags:ead"}
&filter=tags%3Aunama%2Btags%3Aead

Dont forget to escape the string value.

@luizjr8 it works perfectly

api.tags.browse({filter: "post.count:>=1", order: "posts.count DESC", limit: "all"})
No data is available，filter: "post.count:>=1" ，There is a problem

I'm interested in also filtering out a tag, which I can't seem to figure out.

Tried with:

tags: -tag tags: [-tag] tags: -[tag] tags: [tag1, tag2, -tag3]

No clue what to do so far, or if this is possible.

Very late to the party, but I stumbled here while looking for my answer, so: To include some tags and exclude others, do:
tags:[include,these,tags]+tags:-[skipme]

This is about filtering by internal tags, tags that's starting with a hash (#). Add the hash- prefix to the tag name. For example, your internal tag is #special. Use tags:[hash-special] as your query.

Anyone was successful in filtering tags by post count? Nothing seems to work.

For reference to myself. Filter for posts that are published on a specific day the following syntax allows 2 dates:
'published_at:>2023-10-04+published_at:<2023-10-05'

You could probably use the same for other date fields.