Difference between revisions of "Knowledge:Utilities"
From OpenKM Documentation
| Line 2: | Line 2: | ||
'''HQL''' | '''HQL''' | ||
<source lang="sql"> | <source lang="sql"> | ||
| − | select nd.uuid, nd.textExtracted, nd.text from NodeDocument nd where nd.uuid='document-uuid' | + | select nd.uuid, nd.textExtracted, nd.text from NodeDocument nd where nd.uuid='document-uuid'; |
</source> | </source> | ||
'''SQL''' | '''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> | ||
| Line 13: | Line 13: | ||
'''HQL''' | '''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> | </source> | ||
'''SQL''' | '''SQL''' | ||
<source lang="sql"> | <source lang="sql"> | ||
| − | update OKM_NODE_DOCUMENT set NDC_TEXT_EXTRACTED='F' where NBS_UUID='document-uuid' | + | update OKM_NODE_DOCUMENT set NDC_TEXT_EXTRACTED='F' where NBS_UUID='document-uuid'; |
| + | </source> | ||
| + | |||
| + | == Force document text extraction of child documents == | ||
| + | '''SQL''' | ||
| + | <source lang="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'); | ||
</source> | </source> | ||
Revision as of 10:06, 5 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';
Force document text extraction of child 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');
