You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2014-03-27 12:08:02

emyritt
Member
From: American University of Paris
Registered: 2012-11-08
Posts: 1
Website

Knowledge Base - SQL Table with Target Field

When generating reports via ACCESS to MYSQL database, where can we find the Knowledge Base field 'Target' .  We are using the English version of GLPI.  The 'Target' field is located in the KB entry in the Target Tab.  When viewing the tables related to the Knowledge Base Articles, there is no field called 'Target' .

Last edited by emyritt (2014-03-27 12:28:41)

Offline

#2 2014-04-04 09:35:44

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Knowledge Base - SQL Table with Target Field

information about target are in differents tables depending of the target selected (glpi_entities_knowbaseitems, glpi_groups_knowbaseitems, glpi_knowbaseitems_profiles, glpi_knowbaseitems_users)


CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

Board footer

Powered by FluxBB