project BLF > class BStoredSearch > business logic query GetStoredSearch

Description

GetStoredSearch


Parameters


icReferencecharacterLookup reference for the stored search
iiCompanyIdintegerCompany id
iiRoleIDinteger
iiUserIDinteger
icNamecharacter


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 namedata typedb fielddescription
tiCompany_IDintegerStoredSearch.Company_IDEntity
tiRole_IDintegerStoredSearch.Role_IDRole
tiStoredSearch_IDintegerStoredSearch.StoredSearch_IDRecord ID
tcStoredSearchLookupRefcharacterStoredSearch.StoredSearchLookupRefreference to the browse window
tcStoredSearchNamecharacterStoredSearch.StoredSearchNamereference to the stored search
tiUsr_IDintegerStoredSearch.Usr_IDUser


Internal usage


BLF
method BCustomField.ValidateComponent
method BStoredSearch.apiGetLookupInformation
method BStoredSearch.CreateAndDeleteStoredSearches