invantive documentation
Invantive Support ForumsLog In / Sign Up

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 ``

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:

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

All changes of the driver, 26.0 to 27.0