business logic query StoredSearchPrim

Description

StoredSearchPrim

Parameters

iiStoredSearchID	integer
icName	character
icLookupReference	character	ref
iiUsrId	integer	user
iiCompanyId	integer	Company id

query condition

each StoredSearch where

StoredSearch.Company_Id = iiCompanyId AND
StoredSearch.StoredSearch_ID = iiStoredSearchID AND
StoredSearch.StoredSearchName = icName AND
StoredSearch.StoredSearchLookupRef = icLookupReference AND
StoredSearch.Usr_ID = iiUsrId AND
(StoredSearch.Company_ID = iiCompanyId OR
StoredSearch.Company_ID = 0 )

query resultset tqStoredSearchPrim

field name	data type	db field	description
tcLastModifiedUser	character	StoredSearch.LastModifiedUser	Last Modified User
tiRole_ID	integer	StoredSearch.Role_ID	Role
tiStoredSearch_ID	integer	StoredSearch.StoredSearch_ID	Record ID
tcStoredSearchLookupRef	character	StoredSearch.StoredSearchLookupRef	reference to the browse window
tcStoredSearchName	character	StoredSearch.StoredSearchName	reference to the stored search
tiUsr_ID	integer	StoredSearch.Usr_ID	User

Internal usage

BLF

method database.GetBusinessFields
method database.ValidateCustomFields
method BControlProperty.GetCustomisedLevels
method BStoredSearch.apiSaveStoredSearch
method query.GetBusinessFields
read related business field(s) on tCustomField.StoredSearch_ID
ApiGetAlternateKeyValues

QadFinancials

method Session.GetBusinessFieldsExtended