In This Article
Field Support for Filtering and Sorting
Endpoints that allow for querying follow the API Query Language.
Note that the "hasSome" operator works the same as the operator "IN" in SQL.
Post API
Fields That Allow Filtering
Field | Operators | Sorting Allowed |
---|---|---|
id | $eq, $ne, $hasSome | Allowed |
categoryId | $eq, $ne | |
title | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome | |
ownerId | $eq, $ne | |
contentText | $eq, $ne, $contains, $hasSome, $startsWith, $endsWith, $hasSome | |
bestAnswerCommentId | $eq, $ne | |
pinned | $eq, $ne | Allowed |
commentingEnabled | $eq, $ne | |
commentCount | $eq, $ne, $lt, $lte, $gt, $gte | Allowed |
likeCount | $eq, $ne, $lt, $lte, $gt, $gte | Allowed |
viewCount | $eq, $ne, $lt, $lte, $gt, $gte | Allowed |
createdDate | $eq, $ne, $lt, $lte, $gt, $gte | Allowed |
updatedDate | $eq, $ne, $lt, $lte, $gt, $gte | |
lastActivityDate | $eq, $ne, $lt, $lte, $gt, $gte | Allowed |
slug | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome | Allowed |
Examples
Query pinned posts
Copy
1
Get all posts, sorted by created date (latest first)
Copy
1
Get posts by IDs
Copy
1
Category API
Fields That Allow Filtering
Field | Operators | Sorting Allowed |
---|---|---|
id | $eq, $ne, $hasSome | Allowed |
parentId | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome | |
name | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome | |
rank | $eq, $ne, $lt, $lte, $gt, $gte | Allowed |
headerTitle | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome | |
headerType | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome | |
description | $eq, $ne, $contains, $hasSome, $startsWith, $endsWith, $hasSome | |
postCount | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome | Allowed |
postViewCount | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome | Allowed |
slug | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome |
Examples
Query categories by description
Copy
1
Get all categories, sorted by rank
Copy
1
Get categories by IDs
Copy
1
Draft Post API
Fields That Allow Filtering
Field | Operators | Sorting Allowed |
---|---|---|
id | $eq, $ne, $hasSome | Allowed |
categoryId | $eq, $ne | |
title | $eq, $ne, $contains, $hasSome, $urlized, $startsWith, $endsWith, $hasSome | |
ownerId | $eq, $ne | |
contentText | $eq, $ne, $contains, $hasSome, $startsWith, $endsWith, $hasSome | |
commentingType | $eq, $ne | |
createdDate | $eq, $ne, $lt, $lte, $gt, $gte | Allowed |
Examples
Query draft post by content text
Copy
1
Get all draft posts, sorted by createdDate
Copy
1
Get draft posts by IDs
Copy
1
Was this helpful?
Yes
No