Example of filtering document access based on search keywords - Support

Example of filtering document access based on search keywords

From Support

Jump to: navigation, search

Some WebDocs - iSeries Edition 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.
Retrieved from "http://wiki.rjssoftware.com/wiki/index.php/Example_of_filtering_document_access_based_on_search_keywords"
Personal tools