project BLF > class BStoredSearch > business logic query StoredSearchPrim

Description

StoredSearchPrim


Parameters


iiStoredSearchIDinteger
icNamecharacter
icLookupReferencecharacterref
iiUsrIdintegeruser
iiCompanyIdintegerCompany 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 namedata typedb fielddescription
tcLastModifiedUsercharacterStoredSearch.LastModifiedUserLast Modified User
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 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