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
Master VARCHAR(255) Codified name of table to which search criteria are set
Type CHAR(1) Type of search criteria
CriteriaSet BLOB Archived NSArray of SFCriteriaSet objects
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

Notes:

Master is the name of the Template for Global and Subledger data, or TXDetail for the Transaction data.

Type is set to M for the Global and Subledger search criteria, or T for the Transaction search criteria. Type may also be '@' for the setup of File Import Inspector of Global and Subledger data entry applications.

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       Master               Type
--------------- -------------------- ----
wr              TXDetail             T
wr              Customer             M
wr              CardFile             M
tim             CardFile             M
tim             Customer             M
tim             PCodes               M
paul            TXDetail             T
Route                @
Names                @
tim             BankRec              M
tim             Names                M
amy             BankRec              M
tim             Vendors              M
tim             TXDetail             T
Administrator   Area                 M
Area                 @
Cities               @