Difference between revisions of "Knowledge:Utilities"
From OpenKM Documentation
(Created page with '== Show text extracted from document (SQL) == <source lang="sql"> select NBS_UUID, NDC_TEXT_EXTRACTED, NDC_TEXT from OKM_NODE_DOCUMENT where NBS_UUID='document-uuid' </source> =…') |
|||
| Line 1: | Line 1: | ||
| − | == Show text extracted from document | + | == Show text extracted from document == |
| + | '''HQL''' | ||
| + | <source lang="sql"> | ||
| + | select nd.uuid, nd.textExtracted, nd.text from NodeDocument nd where nd.uuid='document-uuid' | ||
| + | </source> | ||
| + | |||
| + | '''SQL''' | ||
<source lang="sql"> | <source lang="sql"> | ||
select NBS_UUID, NDC_TEXT_EXTRACTED, NDC_TEXT from OKM_NODE_DOCUMENT where NBS_UUID='document-uuid' | select NBS_UUID, NDC_TEXT_EXTRACTED, NDC_TEXT from OKM_NODE_DOCUMENT where NBS_UUID='document-uuid' | ||
</source> | </source> | ||
| − | == Force document text extraction | + | == Force document text extraction == |
| + | '''HQL''' | ||
<source lang="sql"> | <source lang="sql"> | ||
update NodeDocument nd set nd.textExtracted=false where nd.uuid='document-uuid' | update NodeDocument nd set nd.textExtracted=false where nd.uuid='document-uuid' | ||
| + | </source> | ||
| + | |||
| + | '''SQL''' | ||
| + | <source lang="sql"> | ||
| + | update OKM_NODE_DOCUMENT set NDC_TEXT_EXTRACTED='F' where NBS_UUID='document-uuid' | ||
</source> | </source> | ||
Revision as of 10:05, 4 October 2012
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'
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'
