Search_TopicsPostersQuery: Discourse itgen_dce_search_topicspostersquery_plural
read only REST
- Catalog:
Discourse - Schema:
Search - Label: itgen_dce_search_topicspostersquery_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_TopicsPostersQuery 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 |
|---|---|---|---|---|---|
archetype |
varchar2 |
Archetype | writable, ::ancestor. |
||
archived |
char |
Archived | writable, ::ancestor. |
||
bookmarked |
varchar2 |
Bookmarked | writable | The JSON text of the nested object. | |
bumped |
char |
Bumped | writable, ::ancestor. |
||
bumped_ |
varchar2 |
Bumped at | writable, ::ancestor. |
||
category_ |
decimal |
Category ID | writable, ::ancestor. |
||
closed |
char |
Closed | writable, ::ancestor. |
||
created_ |
varchar2 |
Created at | writable, ::ancestor. |
||
fancy_ |
varchar2 |
Fancy Title | writable, ::ancestor. |
||
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. | |
has_ |
char |
Has Summary | writable, ::ancestor. |
||
highest_ |
decimal |
Highest Post Number | writable, ::ancestor. |
||
id |
decimal |
ID | writable, ::ancestor. |
||
image_ |
varchar2 |
Image URL | writable | The JSON text of the nested object. | |
last_ |
varchar2 |
Last Posted at | writable, ::ancestor. |
||
last_ |
varchar2 |
Last Poster Username | writable | The JSON text of the nested object. | |
like_ |
decimal |
#Likes | writable, ::ancestor. |
||
liked |
varchar2 |
Liked | writable | The JSON text of the nested object. | |
pinned |
char |
Pinned | writable, ::ancestor. |
||
pinned_ |
char |
Pinned Globally | writable, ::ancestor. |
||
posts_ |
decimal |
#Posts | writable, ::ancestor. |
||
reply_ |
decimal |
#Replies | writable, ::ancestor. |
||
slug |
varchar2 |
Slug | writable, ::ancestor. |
||
title |
varchar2 |
Title | writable, ::ancestor. |
||
unpinned |
varchar2 |
Unpinned | writable | The JSON text of the nested object. | |
unseen |
char |
Unseen | writable, ::ancestor. |
||
views |
decimal |
Views | writable, ::ancestor. |
||
visible |
char |
Visible | writable, ::ancestor. |
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_TopicsPostersQuery is removed
A statement that reads Discourse.Search.Search_TopicsPostersQuery fails after the upgrade. It had 30 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