SQL-020: Retrieve all favorites for all users¶
This statement is the RetrieveSQL implementation of clsMenuFavoriteCollection.Criteria, executed from BeforeRetrieve against MENU_FAVORITE. Retrieve all favorites for all users.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-020 |
| Operation type | Read |
| Execution method | Inline SQL |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | clsMenuFavoriteCollection |
| Criteria property | RetrieveSQL |
| Lifecycle method | BeforeRetrieve |
Parameters¶
This statement takes no bind parameters.
Tables¶
| Table | Access | Columns used |
|---|---|---|
| MENU_FAVORITE | SELECT | MENU_FAVORITE_SEQ_NUM, MENU_USER, MENU_USER_EMPLID, MENU_ITEM_SEQ_NUM, MENU_ORDER_NUM, ITEM_INACTIVE_DATE |
Sample SQL¶
-- Retrieve all favorites for all users
Select
MENU_FAVORITE.MENU_FAVORITE_SEQ_NUM as MenuFavoriteSeqNum,
MENU_FAVORITE.MENU_USER as UserID,
MENU_FAVORITE.MENU_USER_EMPLID as UserEmplID,
MENU_FAVORITE.MENU_ITEM_SEQ_NUM as MenuItemSeqNum,
MENU_FAVORITE.MENU_ORDER_NUM as MenuOrder,
MENU_FAVORITE.ITEM_INACTIVE_DATE as ItemInactiveDate
From
MENU_FAVORITE
Operations and processes¶
Business rules¶
- BR-MENU-001: Scoped vs. unfiltered retrieval
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
- SAIF.Business.Menu/clsMenuFavoriteCollection.vb