Optiva database tables

These tables are used for the Search <Object> pages.

Table	Description
FsSearch	Contains the basic information, such as the name and description of the search object. No criteria values are stored in this table.
FsSearchSimple	Holds the Simple criteria values for a search in one row per field. Fields that have multiple criteria values are saved in a semi-colon delimited list. Numeric and Date criteria fields are saved in the server’s locale.
FsSearchAdvanced	Holds the Advanced criteria values for a search in one row per detail (like Context, Status, References).
FsSearchDetail	Holds information about whether a particular detail is currently using Simple or Advanced criteria. A search can hold both Simple and Advanced criteria for a given section; this table indicates which is active and visible on the browser. This table also holds the 'Not A Member' check box for each section's Simple criteria.