invantive documentation
Invantive Support ForumsLog In / Sign Up

Search_TopicsQuery: Discourse itgen_dce_search_topicsquery_plural

read only REST

  • Catalog: Discourse
  • Schema: Search
  • Label: itgen_dce_search_topicsquery_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_TopicsQuery 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, archetype
archived char Archived writable, archived
bookmarked varchar2 Bookmarked writable The JSON text of the nested object.
bumped char Bumped writable, bumped
bumped_at varchar2 Bumped at writable, bumped_at
category_id decimal Category ID writable, category_id
closed char Closed writable, closed
created_at varchar2 Created at writable, created_at
fancy_title varchar2 Fancy Title writable, fancy_title
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.
has_summary char Has Summary writable, has_summary
highest_post_number decimal Highest Post Number writable, highest_post_number
id decimal ID writable, id
image_url varchar2 Image URL writable The JSON text of the nested object.
last_posted_at varchar2 Last Posted at writable, last_posted_at
last_poster_username varchar2 Last Poster Username writable The JSON text of the nested object.
like_count decimal #Likes writable, like_count
liked varchar2 Liked writable The JSON text of the nested object.
pinned char Pinned writable, pinned
pinned_globally char Pinned Globally writable, pinned_globally
posts_count decimal #Posts writable, posts_count
reply_count decimal #Replies writable, reply_count
slug varchar2 Slug writable, slug
title varchar2 Title writable, title
unpinned varchar2 Unpinned writable The JSON text of the nested object.
unseen char Unseen writable, unseen
views decimal Views writable, views
visible char Visible writable, visible

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_TopicsQuery is removed

A statement that reads Discourse.Search.Search_TopicsQuery 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

All changes of the driver, 26.0 to 27.0