project BLF > class BStoredSearch > business logic query GetStoredSearchDeletion


Parameters


icNamecharacter
icReferencecharacter
iiCompanyIdintegerCompany id
icLogincharacter


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