Skip to content

SAIF.Business.Menu SQL catalog

This page indexes all 44 SQL statements executed by this library's business objects and collections, grouped by CRUD type. Every statement is inline SQL (or SQL assembled with a StringBuilder) issued through the SAIF BOF data portal — this library calls no stored procedures.

Create operations

SQL ID Description Type Tables Business object
SQL-005 Insert a new application code Inline BUSONLINE_APPS_CODE clsApplicationCode
SQL-006 Insert a new menu category code Inline MENU_CATEGORY_CODE clsMenuCategoryCode
SQL-007 Insert a new user favorite Inline MENU_FAVORITE clsMenuFavorite
SQL-008 Insert a new menu item Inline MENU_ITEM clsMenuItem
SQL-009 Insert a new menu page StringBuilder-assembled MENU_PAGE clsMenuPage
SQL-010 Insert a new security-group grant Inline MENU_SECURITY clsMenuSecurity
SQL-011 Insert a new group membership Inline MENU_SECURITY_USER clsMenuSecurityUser

Read operations

SQL ID Description Type Tables Business object
SQL-012 Retrieve one application code by code Inline BUSONLINE_APPS_CODE clsApplicationCode
SQL-013 Retrieve all application codes Inline BUSONLINE_APPS_CODE clsApplicationCodeCollection
SQL-014 Retrieve only active application codes Inline BUSONLINE_APPS_CODE clsApplicationCodeCollection
SQL-015 Retrieve a user's authorized menu items StringBuilder-assembled MENU_ITEM, MENU_SECURITY, MENU_SECURITY_USER, MENU_PAGE, BUSONLINE_APPS_CODE, MENU_CATEGORY_CODE, MENU_FAVORITE clsMenuAuthorizedItemCollection
SQL-016 Retrieve authorized menu items for all users StringBuilder-assembled MENU_ITEM, MENU_SECURITY, MENU_SECURITY_USER, MENU_PAGE, BUSONLINE_APPS_CODE, MENU_CATEGORY_CODE clsMenuAuthorizedItemCollection
SQL-017 Retrieve one menu category code Inline MENU_CATEGORY_CODE clsMenuCategoryCode
SQL-018 Retrieve all menu category codes Inline MENU_CATEGORY_CODE clsMenuCategoryCodeCollection
SQL-019 Retrieve one favorite by sequence number Inline MENU_FAVORITE clsMenuFavorite
SQL-020 Retrieve all favorites for all users Inline MENU_FAVORITE clsMenuFavoriteCollection
SQL-021 Retrieve favorites for one user Inline MENU_FAVORITE clsMenuFavoriteCollection
SQL-022 Retrieve one menu item by sequence number Inline MENU_ITEM clsMenuItem
SQL-023 Retrieve all menu items Inline MENU_ITEM clsMenuItemCollection
SQL-024 Retrieve one menu page by sequence number Inline MENU_PAGE clsMenuPage
SQL-025 Retrieve all menu pages Inline MENU_PAGE clsMenuPageCollection
SQL-026 Retrieve one security grant by sequence number Inline MENU_SECURITY clsMenuSecurity
SQL-027 Retrieve all security grants Inline MENU_SECURITY clsMenuSecurityCollection
SQL-028 Retrieve security grants for one menu item Inline MENU_SECURITY clsMenuSecurityCollection
SQL-029 Retrieve all group memberships Inline MENU_SECURITY_USER clsMenuSecurityUserCollection
SQL-030 Retrieve group memberships for one user Inline MENU_SECURITY_USER clsMenuSecurityUserCollection

Update operations

SQL ID Description Type Tables Business object
SQL-031 Update an application code Inline BUSONLINE_APPS_CODE clsApplicationCode
SQL-032 Update a menu category code Inline MENU_CATEGORY_CODE clsMenuCategoryCode
SQL-033 Update a user favorite Inline MENU_FAVORITE clsMenuFavorite
SQL-034 Update a menu item Inline MENU_ITEM clsMenuItem
SQL-035 Update a menu page StringBuilder-assembled MENU_PAGE clsMenuPage
SQL-036 Update a security-group grant Inline MENU_SECURITY clsMenuSecurity
SQL-037 Update a group membership Inline MENU_SECURITY_USER clsMenuSecurityUser

Delete operations

SQL ID Description Type Tables Business object
SQL-038 Delete an application code Inline BUSONLINE_APPS_CODE clsApplicationCode
SQL-039 Delete a menu category code Inline MENU_CATEGORY_CODE clsMenuCategoryCode
SQL-040 Delete a user favorite Inline MENU_FAVORITE clsMenuFavorite
SQL-041 Delete a menu item Inline MENU_ITEM clsMenuItem
SQL-042 Delete a menu page Inline MENU_PAGE clsMenuPage
SQL-043 Delete a security-group grant Inline MENU_SECURITY clsMenuSecurity
SQL-044 Delete a group membership Inline MENU_SECURITY_USER clsMenuSecurityUser

Sequence operations

SQL ID Description Sequence Tables Business object
SQL-001 Fetch next MENU_FAVORITE sequence value MENU_FAVORITE_SEQ DUAL clsMenuFavorite
SQL-002 Fetch next MENU_ITEM sequence value MENU_ITEM_SEQ DUAL clsMenuItem
SQL-003 Fetch next MENU_PAGE sequence value MENU_PAGE_SEQ DUAL clsMenuPage
SQL-004 Fetch next MENU_SECURITY sequence value MENU_SECURITY_SEQ DUAL clsMenuSecurity

Sources

  • SAIF.Business.Menu/SAIF.Business.Menu.vbproj