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_ |
`` | |||
term |
`` |
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_ |
varchar2 |
Avatar Template | writable, avatar_ |
||
blurb |
varchar2 |
Blurb | writable, blurb |
||
cooked |
varchar2 |
Cooked | writable, cooked |
||
created_ |
varchar2 |
Created at | writable, created_ |
||
grouped_ |
varchar2 |
Grouped Search Result More Categories | writable | The JSON text of the nested object. | |
grouped_ |
varchar2 |
Grouped Search Result More Posts | writable | The JSON text of the nested object. | |
grouped_ |
varchar2 |
Grouped Search Result More Users | writable | The JSON text of the nested object. | |
id |
decimal |
ID | writable, id |
||
like_ |
decimal |
#Likes | writable, like_ |
||
name |
varchar2 |
Name | writable | The JSON text of the nested object. | |
post_ |
decimal |
Post Number | writable, post_ |
||
topic_ |
decimal |
Topic ID | writable, topic_ |
||
username |
varchar2 |
User Name | writable, username |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver:
Changes of This Table, 26.0 to 27.0
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.
What to Do
Check statements, views and scripts that use it before the upgrade.
- can break a statement
- importance 5