Warning: The features and instructions outlined in the document are intended for use by advanced Aeries users who have access to the SQL database. Should you wish to enable these features for your district, please contact your district Aeries Administrator.

Items in the Aeries Navigation tree (pages and reports) can be customized with the following features:

  • Adding new custom links to the navigation tree which can point to any URL
  • Modifying the title of any existing item in the navigation tree
  • Hiding any existing item in the navigation tree
  • New categories can be created containing items which are already displayed in other categories
  • Attributes can be set to allow displaying of navigation items to only certain users based on school, security area, and other criteria.
  • Custom URLs can include dynamic placeholders to include values for the current student from any student-related table or the current user from a session variable

Note: Making any changes to the navigation via these methods may require waiting up to 5 minutes for the server cache to refresh

Care should be taken when altering the navigation tree. Keep in mind that altering attributes such as school codes or security groups associated with existing pages does not alter the underlying security of that page. For example, if a user normally has access to the Contacts page, and you decide to hide this page from the navigation, then that user will still technically have access to that report if they have the URL bookmarked or in their favorites. Hiding items from the navigation should not be done in lieu of proper security permissions.

Sorting of custom navigation items is done similarly to custom tables. New navigation items will appear at the bottom of the specified categories in alphabetical order with other new items. Additional sorting options may be added in the future.

Currently, the navigation customization only applies to regular users. Not parents or students.

Customizing the navigation is accomplished by editing the NAV table in SQL. A simple to accomplish this is by right-clicking on the table in SQL Management Studio and click Edit Top 200 Rows.

The following fields are available within the NAV table. Please see explanations of each field and their purpose:

  • [SC] - School Code. This specifies the school code which this link will display. Enter 0 to display to all schools and district level. If a link should display only at the District level, SC=0 and DST=Y.
  • [TYP] - Type. Valid values are "R" for Reports/View All Reports, or "P" for Pages/View All Forms.
  • [CAT] - Category. Enter the category in which to display. For example "Student Data". This will follow multiple grandchildren down if you add pipe separated categories such as "Supplemental Attendance|Configurations". New categories or sub-categories may also be created here for example "District Tools|Lookups"
  • [NM] - Name. This is the title of the link, and what will be displayed to end users in the navigation.
  • [URL] - The URL
    • URL can contain "Mail Merge" items within brackets []. Any student related field can be used and will always reflect the current student you are on. Example: setting a URL of "https://yourwebsite.com/?q=[STU].[FN]" will result in https://yourwebsite.com/?q=Pete. Other tables besides STU may also be specified. Any custom URL will first go through a redirect page, that checks for user logged in and url is valid, then redirects.
      URL can be an external URL, but can also be an internal aeries page
    • Session Variables can also be specified in the URL instead of a table/field value. Here are some example session variables that may be useful:
      • [Session].[SC] - current student's school code
      • [Session].[SN] - current student's student number
      • [Session].[Connection_Database] - database name
      • [Session].[Connection_Server] - server name
      • [Session].[Connection_DatabaseGroup] - current database group (from Aeries connections config)
      • [Session].[Connection_DatabaseYear] - current database year (from Aeries connections config)
      • [Session].[DateCreated] - date the session was created
      • [Session].[IPAddress] - IP address (as seen by the web server)
      • [Session].[LastPageHit] - last page hit date/timestamp
      • [Session].[SchoolCode] - currently logged in school
      • [Session].[UID] - current user's UID value from the UGN table
      • [Session].[UserName] - current username
    • The URL may be any existing aeries page, i.e. "Supplemental.aspx", or may also include any external url beginning with http://, https://, mailto:, javascript:, etc.
    • This may be a URL to a custom report designed with SQL Server Reporting Services
  • [DAC] - Data Content. This may be a comma separated list of security areas the link should apply to. For example "ATT" or "STU,IDN". Multiple security areas are separated by commas. Use "ADMIN" to display to admin type accounts only.
  • [DAP] - Data Permissions. Links will be displayed to users who have these permissions to the data content areas. Valid values are "Read", "Update", "Insert", "Delete", "MassUpdate", or  "Admin" (which means Administer).
  • [MTD] - Metadata. This can be some additional text used for filtering.
  • [NWN] - New Window. Valid values are Y or N.
  • [TCR] - Teacher. Valid values are Y or N or blank. Behavior is different depending on if this link is a page or report:
    • For Pages: Y = shows only to teachers and does not show to any other type of user, N = do not show to teachers, Blank = show to all
    • For Reports: Y = show to teachers and everyone else.  N or Blank = Shows to everyone except teachers
  • [DST] - District. Valid values are N or blank. N = will hide from District level. Blank = show to all
  • [SCT] - School Type Valid values are "Elementary" (which includes Elem W/ MST) or "Secondary". Blank will show to all school types.
  • [ATT] - Attendance Type. Valid Values are "Daily" or "Period". Blank will show for all attendance types.
  • [SSV] - Session Variable. Show only to session variables matching this criteria. See AeriesNavigation.config for examples.
  • [HID] - Hide. This is used to hide an existing page. To hide an existing page, the URL must be the URL used in Aeries. Example: Query.aspx. Valid values are Y = Hide the page in navigation. Blank or N = Don't hide. Note: Category must be specified to use the hide feature. Since the name field is not applicable when hiding, that field can be used as a notes field.