Navigation:  Knowledge base >

Evaluations of an article

 Previous  Top  Next

Overview

This command will list the positive and negative evaluations of an article.

 

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

KBARTICLEEVALUATION

Stores the article evaluation information.

OID

ADALLUSERS

ADUSEREXTERNALDATA

KBARTICLEREVLANGUAGE

ADALLUSERS

Table that stores user information

CDUSER

ADUSEREXTERNALDATA

ADALLUSERS

GNFAVORITE

 

Oracle/Postgres/SQL Server

SELECT
    KBAR.IDARTICLE,
    KBAE.FGUSEFUL,
    ADU.NMUSER 
FROM
    KBARTICLEREVISION KBAR 
INNER JOIN
    KBARTICLEREVLANGUAGE KBARL ON (KBAR.OID = KBARL.OIDREVISIONARTICLE) 
INNER JOIN
    KBARTICLEEVALUATION KBAE ON (KBARL.OID = KBAE.OIDARTICLELANGUAGE) 
INNER JOIN
    ADALLUSERS ADU ON (KBAE.CDUSER = ADU.CDUSER) 
WHERE
   KBAR.IDARTICLE = '000001' /*NOTE 1*/

 

Notes

▪1: Article ID #.

 

Fields used on the view screen

 

knowledgebase-03

 

knowledgebase-04

 

#

Field ID

Type

Description

1

IDARTICLE

VARCHAR(50)

Field referring to the article ID #

2

FGUSEFUL

NUMERIC(5)

1: Yes

2: No