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