Skip to content

SAIF.Business.Menu SQL catalog

This page indexes all inline SQL statements used by SAIF.Business.Menu, grouped by CRUD type.

Create operations

SQL ID Description Type Tables Business object
SQL-MENU-002 Insert a new application-code lookup entry Inline BUSONLINE_APPS_CODE clsApplicationCode
SQL-MENU-008 Insert a new menu category code Inline MENU_CATEGORY_CODE clsMenuCategoryCode
SQL-MENU-014 Insert a new menu item Inline MENU_ITEM clsMenuItem
SQL-MENU-020 Insert a new menu page Inline MENU_PAGE clsMenuPage
SQL-MENU-026 Insert a menu-item security-group assignment Inline MENU_SECURITY clsMenuSecurity
SQL-MENU-032 Insert a user-to-security-group membership Inline MENU_SECURITY_USER clsMenuSecurityUser
SQL-MENU-038 Insert a menu favorite row Inline MENU_FAVORITE clsMenuFavorite

Read operations

SQL ID Description Type Tables Business object
SQL-MENU-003 Retrieve an application code by its lookup key Inline BUSONLINE_APPS_CODE clsApplicationCode
SQL-MENU-005 Retrieve all application code rows Inline BUSONLINE_APPS_CODE clsApplicationCodeCollection
SQL-MENU-006 Retrieve active application code rows Inline BUSONLINE_APPS_CODE clsApplicationCodeCollection
SQL-MENU-009 Retrieve a menu category code by its key Inline MENU_CATEGORY_CODE clsMenuCategoryCode
SQL-MENU-011 Retrieve all menu category code rows Inline MENU_CATEGORY_CODE clsMenuCategoryCodeCollection
SQL-MENU-015 Retrieve a menu item by its sequence key Inline MENU_ITEM clsMenuItem
SQL-MENU-017 Retrieve all menu items for maintenance Inline MENU_ITEM clsMenuItemCollection
SQL-MENU-021 Retrieve a menu page row Inline MENU_PAGE clsMenuPage
SQL-MENU-023 Retrieve all menu page rows Inline MENU_PAGE clsMenuPageCollection
SQL-MENU-027 Retrieve a menu-item security-group assignment Inline MENU_SECURITY clsMenuSecurity
SQL-MENU-029 Retrieve all menu-item security-group assignments Inline MENU_SECURITY clsMenuSecurityCollection
SQL-MENU-030 Retrieve security groups for a menu item Inline MENU_SECURITY clsMenuSecurityCollection
SQL-MENU-034 Retrieve all user-to-security-group memberships Inline MENU_SECURITY_USER clsMenuSecurityUserCollection
SQL-MENU-035 Retrieve security groups for a user Inline MENU_SECURITY_USER clsMenuSecurityUserCollection
SQL-MENU-039 Retrieve a menu favorite row Inline MENU_FAVORITE clsMenuFavorite
SQL-MENU-041 Retrieve all menu favorite rows Inline MENU_FAVORITE clsMenuFavoriteCollection
SQL-MENU-042 Retrieve menu favorites for a user Inline MENU_FAVORITE clsMenuFavoriteCollection
SQL-MENU-043 Retrieve authorized menu items for a user Inline BUSONLINE_APPS_CODE
MENU_CATEGORY_CODE
MENU_PAGE
MENU_ITEM
MENU_SECURITY
MENU_SECURITY_USER
MENU_FAVORITE		 clsMenuAuthorizedItemCollection
SQL-MENU-044 Retrieve the full authorized menu snapshot Inline BUSONLINE_APPS_CODE
MENU_CATEGORY_CODE
MENU_PAGE
MENU_ITEM
MENU_SECURITY
MENU_SECURITY_USER		 clsMenuAuthorizedItemCollection

Update operations

SQL ID Description Type Tables Business object
SQL-MENU-004 Update an application-code mapping Inline BUSONLINE_APPS_CODE clsApplicationCode
SQL-MENU-010 Update a menu category code's description Inline MENU_CATEGORY_CODE clsMenuCategoryCode
SQL-MENU-016 Update a menu item's placement and display attributes Inline MENU_ITEM clsMenuItem
SQL-MENU-022 Update a menu page's attributes Inline MENU_PAGE clsMenuPage
SQL-MENU-028 Update a menu-item security-group assignment Inline MENU_SECURITY clsMenuSecurity
SQL-MENU-033 Update a user-to-security-group membership Inline MENU_SECURITY_USER clsMenuSecurityUser
SQL-MENU-040 Update a menu favorite row Inline MENU_FAVORITE clsMenuFavorite

Delete operations

SQL ID Description Type Tables Business object
SQL-MENU-001 Delete an application-code lookup entry Inline BUSONLINE_APPS_CODE clsApplicationCode
SQL-MENU-007 Delete a menu category code Inline MENU_CATEGORY_CODE clsMenuCategoryCode
SQL-MENU-013 Delete a menu item Inline MENU_ITEM clsMenuItem
SQL-MENU-019 Delete a menu page Inline MENU_PAGE clsMenuPage
SQL-MENU-025 Delete a menu-item security-group assignment Inline MENU_SECURITY clsMenuSecurity
SQL-MENU-031 Delete a user-to-security-group membership Inline MENU_SECURITY_USER clsMenuSecurityUser
SQL-MENU-037 Delete a menu favorite row Inline MENU_FAVORITE clsMenuFavorite

Sequence operations

SQL ID Description Sequence Tables Business object
SQL-MENU-012 Fetch the next menu item key MENU_ITEM_SEQ MENU_ITEM clsMenuItem
SQL-MENU-018 Fetch the next menu page key MENU_PAGE_SEQ MENU_PAGE clsMenuPage
SQL-MENU-024 Fetch the next menu security key MENU_SECURITY_SEQ MENU_SECURITY clsMenuSecurity
SQL-MENU-036 Fetch the next menu favorite key MENU_FAVORITE_SEQ MENU_FAVORITE clsMenuFavorite

Sources

  • SAIF.Business.Menu\clsApplicationCode.vb
  • SAIF.Business.Menu\clsApplicationCodeCollection.vb
  • SAIF.Business.Menu\clsMenuAuthorizedItemCollection.vb
  • SAIF.Business.Menu\clsMenuCategoryCode.vb
  • SAIF.Business.Menu\clsMenuFavorite.vb
  • SAIF.Business.Menu\clsMenuFavoriteCollection.vb
  • SAIF.Business.Menu\clsMenuItem.vb
  • SAIF.Business.Menu\clsMenuItemCollection.vb
  • SAIF.Business.Menu\clsMenuPage.vb
  • SAIF.Business.Menu\clsMenuPageCollection.vb
  • SAIF.Business.Menu\clsMenuSecurity.vb
  • SAIF.Business.Menu\clsMenuSecurityCollection.vb
  • SAIF.Business.Menu\clsMenuSecurityUser.vb
  • SAIF.Business.Menu\clsMenuSecurityUserCollection.vb