project BLF > class BStoredSearch > business logic query StoredSearchById
Parameters
| iiCompanyId | integer | Company id |
| iiStoredSearchId | integer | |
query condition
each StoredSearch where
StoredSearch.Company_Id = iiCompanyId AND
StoredSearch.StoredSearch_ID = iiStoredSearchId
each CustomField (inner-join) where
CustomField.StoredSearch_ID = StoredSearch.StoredSearch_ID AND
query resultset tqStoredSearchById
| field name | data type | db field | description |
|---|
| tiStoredSearch_ID | integer | StoredSearch.StoredSearch_ID | Record ID |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(StoredSearch),rowid(CustomField) |
Internal usage
BLF