business logic query GetStoredSearch

Description

GetStoredSearch

Parameters

icReference	character	Lookup reference for the stored search
iiCompanyId	integer	Company id
iiRoleID	integer
iiUserID	integer
icName	character

query condition

each StoredSearch where

StoredSearch.Company_Id = iiCompanyId AND
StoredSearch.StoredSearchLookupRef = icReference AND
(StoredSearch.Company_ID = iiCompanyId OR
StoredSearch.Company_ID = 0 ) AND
(StoredSearch.Role_ID = iiRoleID OR
StoredSearch.Role_ID = 0 ) AND
(StoredSearch.Usr_ID = iiUserID OR
StoredSearch.Usr_ID = 0 ) AND
StoredSearch.StoredSearchName = icName

query resultset tqGetStoredSearch

field name	data type	db field	description
tiCompany_ID	integer	StoredSearch.Company_ID	Entity
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 BCustomField.ValidateComponent
method BStoredSearch.apiGetLookupInformation
method BStoredSearch.CreateAndDeleteStoredSearches