AVG_RATING

AVG_RATING

DOUBLE

document_state

ACTIVE_STATE

INTEGER

document_state_date

ACTIVE_STATE_ DATE

LOCAL_TIME

assignee_id

ASSIGNEE_ID

UUID

ca_contact uuid

author_ID

AUTHOR_ID

UUID

ca_contact uuid

Classificazione FAQ

BU_RESULT

REAL

created_via

CREATED_VIA

INTEGER

Data di creazione

CREATION_DATE

LOCAL_TIME

task_id

CURRENT_ACTION_ID

INTEGER

CI_ACTIONS id

custom_1

CUSTOM1

STRING

custom_2

CUSTOM2

STRING

custom_3

CUSTOM3

STRING

custom_4

CUSTOM4

STRING

custom_5

CUSTOM5

STRING

custom_num_1

CUSTOM_NUM1

REAL

custom_num_2

CUSTOM_NUM2

REAL

document_template_id

DOC_TEMPLATE_ ID

INTEGER

CI_DOC_ TEMPLATES id

document_type_id

DOC_TYPE_ID

INTEGER

CI_DOC_ TYPES id

document_version

DOC_VERSION

STRING

Data scadenza

EXPIRATION_DATE

LOCAL_TIME

EXPIRE_ NOTIFICATION_ SENT

EXPIRE_ NOTIFICATION_ SENT

INTEGER

decision_tree_root_ID

EXT_DOC_ID

INTEGER

ebr_search_text

ebr_search_text

STRING

ebr_min_relevance

ebr_min_relevance

STRING

ebr_fuzziness

ebr_fuzziness

STRING

ebr_search_type

ebr_search_type

STRING

ebr_match_type

ebr_match_type

STRING

ebr_search_in

ebr_search_in

STRING

ebr_primary_order

ebr_primary_order

STRING

ebr_secondary_ order

ebr_secondary_ order

STRING

ebr_order_direction

ebr_order_direction

STRING

ebr_custom_filter

ebr_custom_filter

STRING

ebr_sd_persid

ebr_sd_persid

STRING

ebr_filter_data

ebr_flter_data

STRING

ebr_url_text

ebr_url_text

STRING

ebr_ks_source

ebr_ks_source

STRING

ebr_kcat_id

ebr_kcat_id

STRING

ebr_ad_blc

ebr_ad_blc

STRING

ebr_serial_num

ebr_serial_num

STRING

ebr_relevance

ebr_relevance

STRING

ebr_ks_teaser

ebr_ks_teaser

STRING

ebr_ks_concepts

ebr_ks_concepts

STRING

FLG_COUNT

FLG_COUNT

QREL

PAROLE INTERE

PAROLE INTERE

STRING

Accessi

HITS

INTEGER

id

ID

INTEGER

KEY

INDICIZZATO

INDICIZZATO

INTEGER

inherit_permissions_flag

INHERIT_ PERMISSION

INTEGER

Iniziatore

INITIATOR

STRING

initiator_id

INITIATOR_ID

UUID

ca_contact uuid

inherit_permissions_from_category_id

KD_PERMISSION_ INDEX_ID

INTEGER

O_INDEXES id

KS_TYPE

KS_TYPE

INTEGER

Data ultima accettazione

LAST_ACCEPTED_DATE

LOCAL_TIME

Data ultima modifica

LAST_MOD_DT

LOCAL_TIME

Indica la data/ora di sistema dell'ultima modifica del record corrente.

locked_by_id

LOCKED_BY_ID

UUID

ca_contact uuid

Data modifica

MODIFY_DATE

LOCAL_TIME

Note

NOTES

STRING

owner_id

OWNER_ID

UUID

ca_contact uuid

Richiesta padre

PARENT_CR

STRING

call_req persid

Questione padre

PARENT_ISS

STRING

issue persistent_id

persistent_id

persid

STRING

Categoria primaria

PRIMARY_INDEX

INTEGER

O_INDEXES id

workflow_priority_id

PRIORITY_ID

INTEGER

CI_PRIORITIES id

Problema

PROBLEM

STRING

producer_id

producer_id

STRING

Data pubblicazione

PUBLISHED_DATE

LOCAL_TIME

READ_PGROUP

READ_PGROUP

INTEGER

P_GROUPS id

PGROUP TYPE

PGROUP_TYPE

INTEGER

Indica se la tabella P Groups è basata su Ruoli o Gruppi:

1—Gruppi (impostazione predefinita)

2—Ruoli

QA_STATUS

QA_STATUS

SREL

kt_qa_status.id

resolution_text

RESOLUTION

STRING

resolution_length

RESOLUTION_ LENGTH

INTEGER

short_resolution

RESOLUTION_ SHORT

STRING

Data revisione

REVIEW_DATE

LOCAL_TIME

Conteggio soluzioni

SD_ACCEPTED_ HITS

INTEGER

ID asset

SD_ASSET_ID

UUID

ca_owned_ resource uuid

impact_id

SD_IMPACT_ID

INTEGER

impact enum

PRIMARY_KCAT_ CHANGE_ONKCAT_ DELETE

PRIMARY_KCAT_ CHANGE_ONKCAT_ DELETE

INTEGER

priority_id

SD_PRIORITY_ID

INTEGER

pri enum

PROBLEM_SHORT

PROBLEM_SHORT

STRING 255

ID prodotto

SD_PRODUCT_ID

INTEGER

product id

RESOLUTION_ TEXT

RESOLUTION_ TEXT

STRING

root_cause_id

SD_ROOTCAUSE_ ID

INTEGER

rootcause id

severity_id

SD_SEVERITY_ID

INTEGER

sevrty enum

urgency_id

SD_URGENCY_ID

INTEGER

urgncy enum

USER_SLV_CNT

USER_SLV_CNT

INTEGER

PAROLE BREVI

PAROLE BREVI

STRING

Data inizio

START_DATE

LOCAL_TIME

status_id

STATUS_ID

INTEGER

CI_STATUSES id

subject_expert_id

SUBJECT_EXPERT_ID

UUID

ca_contact uuid

SUBMIT_ KNOWLEDGE_ GUEST_USER_ NAME

SUBMIT_ KNOWLEDGE_ GUEST_USER_ NAME

STRING

SUBMIT_ KNOWLEDGE_ GUEST_MAIL

SUBMIT_ KNOWLEDGE_ GUEST_MAIL

STRING

Summary

SUMMARY

STRING

ticket_avoided_cnt

ticket_avoided_cnt

INTEGER

Titolo

TITLE

STRING

ID definito dall'utente

USER_DEF_ID

STRING

version_comment

VER_COMMENT

STRING

version_count

VER_COUNT

INTEGER

version_cross_reference_id

VER_CROSS_REF_ ID

INTEGER

workflow_template

WF_TEMPLATE

INTEGER

CI_WF_ TEMPLATES id

WORD_COUNT_ TOTAL

WORD_COUNT_ TOTAL

INTEGER

CONTEGGIO PAROLE

CONTEGGIO PAROLE

INTEGER

CONTEGGI PAROLE

CONTEGGI PAROLE

STRING

ORDINI PAROLE

ORDINI PAROLE

STRING

POSIZIONI PAROLE

POSIZIONI PAROLE

STRING

PERIODI PAROLE

PERIODI PAROLE

STRING

WRITE_PGROUP

WRITE_PGROUP

INTEGER

P_GROUPS id