Overview
This command will list the text content of the articles in English in a certain knowledge base.
Related tables
TABLE
|
Description
|
Primary key (PK)
|
Connection tables
|
KBKNOWLEDGEBASE
|
Table to store the knowledge bases
|
OID
|
ADALLUSERS
GNTYPEROLE
|
KBLANGUAGEDATA
|
Table that stores the fields of the KBKNOWLEDGEBASE table in different languages
|
OID
|
KBKNOWLEDGEBASE
|
KBARTICLEREVISION
|
Table that stores the revisions of the articles in a knowledge base
|
OID
|
GNASSOC
ADALLUSERS
GNREVISION
KBARTICLEDATA
KBCATEGORY
KBKNOWLEDGEBASE
|
KBARTICLEREVLANGUAGE
|
Table that stores information of articles in a certain language according to the revision
|
OID
|
KBARTICLEREVISION
GNASSOC
SERICHTEXT
|
SERICHTEXT
|
Table that stores the richtext data in the system
|
OID
|
SETEXT
|
SETEXT
|
Table used to save large content as text, such as images, etc.
|
OID
|
|
Oracle/Postgres/SQL Server
SELECT
KB.IDKNOWLEDGEBASE,
KBLAN.NMKNOWLEDGEBASE,
KBART.IDARTICLE,
KBALAN.NMARTICLE,
SETXT.TXDATA
FROM
KBKNOWLEDGEBASE KB
INNER JOIN KBLANGUAGEDATA KBLAN ON (KB.OID = KBLAN.OIDKNOWLEDGEBASE)
INNER JOIN KBARTICLEREVISION KBART ON (KB.OID = KBART.OIDKNOWLEDGEBASE)
INNER JOIN KBARTICLEREVLANGUAGE KBALAN ON (KBART.OID = KBALAN.OIDREVISIONARTICLE AND KBLAN.FGLANGUAGE = KBALAN.FGLANGUAGE)
INNER JOIN SERICHTEXT SERTXT ON (KBALAN.OIDCONTENT = SERTXT.OID)
INNER JOIN SETEXT SETXT ON ( SERTXT.OIDTEXTCONTENT = SETXT.OID)
WHERE
KB.IDKNOWLEDGEBASE = 'ITSM'/*NOTE 1*/
AND KBLAN.FGLANGUAGE = 1 /*NOTE 2*/
|
Notes
▪OBS1: Knowledge base ID #; ▪OBS2: Available languages will vary according to the compatibility with the charset of the used database.
Fields used on the view screen
#
|
Field ID
|
Type
|
Description
|
1
|
IDKNOWLEDGEBASE
|
VARCHAR(50)
|
Field referring to the knowledge base ID #
|
2
|
NMKNOWLEDGEBASE
|
VARCHAR(255)
|
Field referring to the knowledge base name in a specific language
|
3
|
IDARTICLE
|
VARCHAR(50)
|
Field referring to the article ID #
|
|