Search Criteria Table
Data Entry applications can store search criteria that the users set for finding records in tables. These saved search criteria serve as macros, accelerating the process of finding the desired information by STEPforward. The search criteria are personalized, with each user creating his/her own macros; they are stored in SF_SYSSearchCriteria table of the following structure:
Column | Generalized data type | Use |
SF_UserId | VARCHAR(255) | Login account of the owner of search criteria |
SF_Master | VARCHAR(255) | Codified name of table to which search criteria are set |
SF_Type | CHAR(1) | Type of search criteria |
SF_CriteriaSet | BLOB | Archived NSArray of SFCriteriaSet objects |
SF_TimeStamp | SMALLINT | Version of the row (incremented with each update) |
Notes:
SF_Master is the name of the Template for Global and Subledger data, or TXDetail for the Transaction data.
SF_Type is set to M for the Global and Subledger search criteria, or T for the Transaction search criteria. SF_Type may also be '@' for the setup of File Import Inspector of Global and Subledger data entry applications.
SF_CriteriaSet is an archived NSArray that carries SFCriteriaSet objects for the search criteria, or SFImportCriteriaSet for the file import setup.
The following is a partial sample of contents of SF_SYSSearchCriteria table:
SF_UserId SF_Master SF_Type
--------------- -------------------- -------
wr TXDetail T
wr Customer M
wr CardFile M
tim CardFile M
tim Customer M
tim PCodes M
paul TXDetail T
tim BankRec M
tim Names M
amy BankRec M
tim Vendors M
tim TXDetail T
Administrator Area M