dataset BStoredSearch

class dataset

object identification

primary key
StoredSearch_ID
object identity
StoredSearch_ID

table tStoredSearch

Description

settings on the browse window

field name	data type	mnd.	description
StoredSearch_ID	integer	yes	Record ID
Usr_ID	integer	no	User
Role_ID	integer	no	Role
Company_ID	integer	no	Entity
StoredSearchName	character(80)	yes	reference to the stored search
StoredSearchLookupRef	character(255)	no	reference to the browse window
StoredSearchRowsToRetrieve	integer	no	maximum number of rows in the browse grid
StoredSearchSortColumn	character(80)	no	business field name of a column in the result set to sort on
StoredSearchFilterMinimize	logical	no	When true, the filter panel will be closed by default.
StoredSearchFreezeFirstCol	logical	no	When true, leftmost column in the browse grid will remain fixed when scrolling left to right in the browse grid.
StoredSearchUseGridLayout	logical	no	Use Grid Layout
StoredSearchLayoutXML	character(4000)	no	XML Layout
StoredSearchClassVersion	integer	no	When this version is different from the current version of the business component on which the browse is based, filter fields and resultset fields in the stored search will be updated to current version (new fields added, old fields removed).
StoredSearchAutoApply	logical	no	When true, default filter values will be applied automatically. When false, the browse grid is empty when opening the window.
StoredSearchViewMode	character(8)	no	View Mode
tcAccessCompanyCode	character(20)	no
tcAccessRoleName	character(20)	no
tcAccessUserLogin	character(20)	no
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	no	empty string
tc_Status	character	no	update status

table tSSearchFilterField

Description

settings on individual filter fields

field name	data type	mnd.	description
SSearchFilterField_ID	integer	yes	Record ID
StoredSearch_ID	integer	no	Stored Search
SSearchFilterFieldBusField	character(80)	no	business field name (as it is returned by GetBusinessFields)
SSearchFilterFieldSequence	integer	no	display sequence
SSearchFilterFieldOperator	character(8)	no	filter operator possible values: = >= > < <= <> begins matches can-do
SSearchFilterFieldIniVal1	character(80)	no	filter value filter value from when range is true
SSearchFilterFieldIniVal2	character(80)	no	filter value to when range is true
SSearchFilterFieldIsRange	logical	no	Range
SSearchFilterFieldIsVisibl	logical	no	Visible
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	yes	= tStoredSearch.tc_Rowid
tc_Status	character	no	update status

table tSSearchResultField

Description

settings on individual columns in the browse grid

field name	data type	mnd.	description
SSearchResultField_ID	integer	yes	Record ID
StoredSearch_ID	integer	no	Stored Search
SSearchResultFieldBusField	character(80)	no	business field name (as it is returned by GetBusinessFields)
SSearchResultFieldSequence	integer	no	display sequence
SSearchResultFieldColSize	integer	no	Column Size
SSearchResultFieldIsVisibl	logical	no	Visible
SSearchResultFieldAggregat	character(40)	no	Aggregate
SSearchResultFieldGroupSeq	integer	no	sequence of aggregation
SSearchResultFieldCBF	character(80)	no	Custom Field
LastModifiedDate	date	no	Last Modified Date
LastModifiedTime	integer	no	Last Modified Time
LastModifiedUser	character(20)	no	Last Modified User
QADC01	character(40)	no	unused QAD reserved field
QADC02	character	no	unused QAD reserved field
QADT01	date	no	unused QAD reserved field
QADD01	decimal(10)	no	unused QAD reserved field
tc_Rowid	character	yes	primary index
tc_ParentRowid	character	yes	= tStoredSearch.tc_Rowid
tc_Status	character	no	update status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field name	data type	description
tcCustomShort0	character
tcCustomShort1	character
tcCustomShort2	character
tcCustomShort3	character
tcCustomShort4	character
tcCustomShort5	character
tcCustomShort6	character
tcCustomShort7	character
tcCustomShort8	character
tcCustomShort9	character
tcCustomCombo0	character
tcCustomCombo1	character
tcCustomCombo2	character
tcCustomCombo3	character
tcCustomCombo4	character
tcCustomCombo5	character
tcCustomCombo6	character
tcCustomCombo7	character
tcCustomCombo8	character
tcCustomCombo9	character
tcCustomLong0	character
tcCustomLong1	character
tcCustomNote	character
ttCustomDate0	date
ttCustomDate1	date
ttCustomDate2	date
ttCustomDate3	date
ttCustomDate4	date
tiCustomInteger0	integer
tiCustomInteger1	integer
tiCustomInteger2	integer
tiCustomInteger3	integer
tiCustomInteger4	integer
tdCustomDecimal0	decimal(4)
tdCustomDecimal1	decimal(4)
tdCustomDecimal2	decimal(4)
tdCustomDecimal3	decimal(4)
tdCustomDecimal4	decimal(4)
tc_Rowid	character	Use this data item to add as a field in public temp-tables (with index).
tc_ParentRowid	character
tc_Status	character