Views:

Question:
How can the fulltext status of a document be checked?

Answer:

1. Check the actual fulltext status in a file cabinet
With following statement you can request the actual state in the [file cabinet]_PAGE table of the file cabinet in the DWData database (Fulltext state of all document pages in the file cabinet):

select ftstatus, count(ftstatus) as Number_DocumentPages
from [file cabinet]_PAGE
group by ftstatus;

Additional info - Overview on FTSTATUS (Fulltext status) in the _PAGE table:

  • FTSTATUS 0: Write fulltext data new into the _PAGE table
  • FTSTATUS 1: Textshot created
  • FTSTATUS 2: Error during creation of the textshot
  • FTSTATUS 3: Document page completely transferred to SOLR and fulltext index path

2. Get the fulltext status of a document page
Obtain the DocID (document ID) of the document first. Then you can get the SECTIONID (section number) in the [file cabinet]_SECT table by filtering using the DOCID.
Finally you can get the FTSTATUS of the document page using the SECTIONID as a filter.

2.1 Find out the DOCID
In the Web Client, open a document in the viewer and then select "Show index entries" from the Tools menu.
Choose the option "system entries" on the pop-up dialog to display the document-ID (see screenshot down below).

2.2 Find the SECTIONID
With the following statement you can display the SECTIONID (section number) of a document using the DOCID asa filter (see screenshot below):

select *
from [file_cabinet]_SECT
where DWDOCID = DocID;

2.3 Find out the fulltext status of the document page
After retrieving the  SECTIONID you can get the FTSTATUS of a document page with another query:

select *
from [file_cabinet]_PAGE
where SECTIONID = SectionID;

If you want to display the FTSTATUS of a document with several pages at the same time this statement can be used (see screenshot below):

select *
from [file_cabinet]_PAGE
where SECTIONID between [FirstSectionID] and [LastSectionID];

See also:
Fulltext processing overview: KBA-35309
Fulltext and SOLR: KBA-35311
Check Fulltext textshot of a document: KBA-34944

This article is valid for DocuWare versions: 6 6.1 6.5 6.6 6.7 6.8 6.9 6.10 6.11 6.12 7 | ftstatus fulltext status section #FAQID_3828