business logic query GetStoredSearchDeletion

Parameters

icName	character
icReference	character
iiCompanyId	integer	Company id
icLogin	character

query condition

each StoredSearch where

StoredSearch.Company_Id = iiCompanyId AND
StoredSearch.StoredSearchName matches icName AND
StoredSearch.StoredSearchLookupRef matches icReference AND
StoredSearch.LastModifiedUser = icLogin AND
(StoredSearch.Company_ID = iiCompanyId OR
StoredSearch.Company_ID = 0 )

query sort order

StoredSearch.StoredSearchName (ascending)
StoredSearch.StoredSearchLookupRef (ascending)

query resultset tqGetStoredSearchDeletion

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 BStoredSearch.ApiGetStoredSearchDeletion