Navigation:  Knowledge base >

Articles of a category in a knowledge base

 Previous  Top  Next

Overview

This command will list the articles in a category of a knowledge base.

 

Related tables

TABLE

Description

Primary key (PK)

Connection tables

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

KBCATEGORY

Stores the knowledge base categories.

OID

GNGENTYPE

KBKNOWLEDGEBASE

GNTRANSLATION

GNGENTYPE

Stores the generic types.

CDGENTYPE

GNTYPEROLE

GNACTIVITYTIMECFG

GNSECURITY

 

Oracle/Postgres/SQL Server

SELECT
    KBAR.IDARTICLE,
    KBARL.NMARTICLE
FROM
    KBARTICLEREVISION KBAR 
INNER JOIN
    KBARTICLEREVLANGUAGE KBARL ON (KBAR.OID = KBARL.OIDREVISIONARTICLE) 
INNER JOIN
    KBCATEGORY KBC ON (KBAR.OIDCATEGORY = KBC.OID) 
INNER JOIN
    GNGENTYPE GN ON (KBC.CDGENTYPE = GN.CDGENTYPE) 
WHERE
    GN.IDGENTYPE = 'category 1' /*NOTE 1*/
 and KBARL.FGLANGUAGE = 2 /*NOTE 2*/

 

Notes

▪NOTE1: Article category ID #.

▪OBS2: Available languages will vary according to the compatibility with the charset of the used database.

 

Fields used on the view screen

 

knowledgebase-02

 

#

Field ID

Type

Description

1

IDARTICLE

VARCHAR(50)

Field referring to the article ID #

2

NMARTICLE

VARCHAR(255)

Field referring to the article name in a specific language

3

IDGENTYPE

VARCHAR(50)

Field referring to the category ID #

4

FGLANGUAGE

NUMERIC(5)

Language code:

1 =  en-us => English (USA)

2 =  pt-br => Portuguese (Brazil)

3 =  es => Spanish

4 =  pt => Portuguese (Portugal)

5 =  de => German

6 =  fr => French

7 =  ro => Romanian

8 =  zh => Chinese

9 =  it => Italian

10 =  sk => Slovak

11 =  en-gb => English (United Kingdom)

12 =  tr => Turkish

13 =  fr-ca => French (Canada)

14 =  ru => Russian

15 =  pl => Polish

16 =  ca => Catalan

17 =  da => Danish

18 =  fi => Finnish

19 =  ja => Japanese

20 =  cs => Czech