---
title: "Search_PostsQuery (Discourse)"
description: "itgen_dce_search_postsquery_plural"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Search.Search_PostsQuery
original: https://documentation.invantive.eu/en/datamodels/discourse/Discourse.Search.Search_PostsQuery
updated: 2026-11-01T16:08:49Z
license: https://documentation.invantive.eu/en/
---

# Search_PostsQuery: Discourse itgen_dce_search_postsquery_plural

`read only` `REST`

- Catalog: `Discourse`
- Schema: `Search`
- Label: itgen_dce_search_postsquery_plural

Search for something

Can only retrieve data.

## Summary

Search for something

## API Source

- Endpoint: `/search/query`
- Operation: `get /search/query`

## Performance Characteristics

| Characteristic | Value |
|---|---:|
| Average access latency (ms) | 243 |
| Write rows per minute | 219 |

The result can be cached on the client.

## Parameters

| Name | Data Type | Required | Default | Documentation |
|---|---|:---:|---|---|
| `include_blurbs` | `` | [ ] |  |  |
| `term` | `` | [x] |  |  |

## Table Columns

The columns of the table `Search_PostsQuery` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `avatar_template` | `varchar2` | Avatar Template | [ ] | writable, `avatar_template` |  |
| `blurb` | `varchar2` | Blurb | [ ] | writable, `blurb` |  |
| `cooked` | `varchar2` | Cooked | [ ] | writable, `cooked` |  |
| `created_at` | `varchar2` | Created at | [ ] | writable, `created_at` |  |
| `grouped_search_result_more_categories` | `varchar2` | Grouped Search Result More Categories | [ ] | writable | The JSON text of the nested object. |
| `grouped_search_result_more_posts` | `varchar2` | Grouped Search Result More Posts | [ ] | writable | The JSON text of the nested object. |
| `grouped_search_result_more_users` | `varchar2` | Grouped Search Result More Users | [ ] | writable | The JSON text of the nested object. |
| `id` | `decimal` | ID | [ ] | writable, `id` |  |
| `like_count` | `decimal` | #Likes | [ ] | writable, `like_count` |  |
| `name` | `varchar2` | Name | [ ] | writable | The JSON text of the nested object. |
| `post_number` | `decimal` | Post Number | [ ] | writable, `post_number` |  |
| `topic_id` | `decimal` | Topic ID | [ ] | writable, `topic_id` |  |
| `username` | `varchar2` | User Name | [ ] | writable, `username` |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Discourse](/en/release-notes/drivers?driver=discourse)

### Changes of This Table, 26.0 to 27.0

<div class="rn-item" id="DCE-27.0-D029">

##### Table function Discourse.Search.Search_PostsQuery is removed

A statement that reads Discourse.Search.Search_PostsQuery fails after the upgrade. It had 13 columns. The operation is not in the updated Discourse specification, or has another name.

<div class="rn-action">

**What to Do**

Check statements, views and scripts that use it before the upgrade.

</div>

<div class="rn-chips">

- **can break a statement**
- importance 5

</div>

</div>

[All changes of the driver, 26.0 to 27.0](/en/release-notes/drivers?driver=discourse&step=26.0-to-27.0#discourse-26.0-to-27.0)

