Knowledge:Utilities

From OpenKM Documentation
Jump to: navigation, search

Show text extracted from document

HQL

select nd.uuid, nd.textExtracted, nd.text from NodeDocument nd where nd.uuid='document-uuid';

SQL

select NBS_UUID, NDC_TEXT_EXTRACTED, NDC_TEXT from OKM_NODE_DOCUMENT where NBS_UUID='document-uuid';

Show text extracted of folder children documents

SQL

select NBS_UUID, NDC_TEXT_EXTRACTED, NDC_TEXT from OKM_NODE_DOCUMENT where NBS_UUID in (select NBS_UUID from OKM_NODE_BASE where NBS_PARENT='folder-uuid');

Force document text extraction

HQL

update NodeDocument nd set nd.textExtracted=false where nd.uuid='document-uuid';

SQL

update OKM_NODE_DOCUMENT set NDC_TEXT_EXTRACTED='F' where NBS_UUID='document-uuid';

Force document text extraction of folder children documents

SQL

update OKM_NODE_DOCUMENT set NDC_TEXT_EXTRACTED='F' where NBS_UUID in (select NBS_UUID from OKM_NODE_BASE where NBS_PARENT='folder-uuid');

See table description in Oracle

select t1.column_name, substr(data_type||'('||data_length||')', 0, 20) as data_type, decode(nullable,'N','NOT NULL', '') as null_status, comments
from all_tab_columns t1, all_col_comments t2 where t1.table_name = t2.table_name
and t1.column_name = t2.column_name and t1.table_name = 'OKM_NODE_DOCUMENT' ORDER BY COLUMN_ID;