Some WebDocs iSeries users have the need to pre-filter document search lists at the user based on fields in the DOCS00 file. 

Available filter fields:
  • TITLE - Document Title
  • DOCTYPE2 - Document type
  • FOLDER1 - Folder Level 1
  • FOLDER2 - Folder Level 2
  • FOLDER3 - Folder Level 3
  • KEYWORD1 - KEYWORD10 -  Document search keywords
 
AS/400 - iSeries Report Filter Fields:
  • DCSPOOL - Spool file name
  • DCUSERID - User ID
  • DCUSRDTA - User Data
  • DCFORM - Form Type
  • DCJOB - Job Name
  • DCOUTQ - Output Queue

Additionally any field in the DOCS00 file in library RJSIMAGE can be used for filtering.  

The following AS/400 command can be used to list the field names:
DSPFFD RJSIMAGE/DOCS00
 
Example for filtering on KEYWORD1
 
KEYWORD1 =  '123456'
 
Example for filtering on KEYWORD1 and KEYWORD2
 
KEYWORD1 =  '123456' and KEYWORD1 =  '45678'
 
Note: Any standard SQL expression can be entered in the criteria. The WHERE statement is already implied.
 

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: December 10, 2016