KnowledgeBaseArticles
The articles which match the given query string across all service desks.
Select
To query this table, you must specify either the Query column or both ServiceDeskId and Query in the WHERE clause. For example:
SELECT * FROM KnowledgeBaseArticles WHERE Query = 'guide'; SELECT * FROM KnowledgeBaseArticles WHERE Query = 'guide' AND ServiceDeskId = 2;
Aside from the required columns mentioned above and the Highlights pseudo-column used by the 本製品 to process server-side filtering through the Jira Service Management API, all other filters in the WHERE clause are applied client-side by the 本製品.
Note: This view is available only for Jira Service Management Cloud instances. It is not supported on Jira Service Management Server or Data Center deployments.
Columns
| Name | Type | Description |
| ServiceDeskId | String | The Id of the service desk. |
| Title | String | The title of the article. |
| Excerpt | String | The excerpt of the article. |
| SourceType | String | The article's source type |
| SourcePageId | String | The article's source page id |
| SourceSpaceKey | String | The article's source space key |
| ContentiFramesource | String | The link to the article. |
| Query | String | The string used to filter the articles (required). |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Highlight | Boolean | If set to true matching query term in the title and excerpt will be highlighted using the {@code @@@hl@@@term@@@endhl@@@} syntax. Default: false. |