Database listings provide your patrons/users a place where they can search, filter, and browse through a list of external databases. Users with the Moderator or Administrator role have the ability to create, edit and delete database listings as needed.

Considerations

Before creating new database listings consider how your users/patrons will be using this information. You have the ability to update the labels associated with the database listings to ensure field names and other terminology matches what they expect to see. As well, you can create a custom list of Categories that can be used for filtering and grouping these listings.  

Labels

Almost all field names and labels can be changed in Stacks, this allows you to customize label sets to ensure the terminology used matches what your users or patrons would expect to see when viewing the database listings. To update the site labels:

1. From the Dashboard, click the Database Listings tile
2. Click the Labels tab near the top of the screen
3. Review the labels in the Fields and Listing View sections from the tabs on the left, change any values as needed
4. Scroll to the bottom of the page and click Submit when finished

Filter Vocabularies

Filter Vocabularies are lists of values that can be used by your users/patrons to filter and group information in Stacks, with regards to database listings, this is a Category field. There are no default values populating this lists, so create and/or edit as needed. 

1. From the Dashboard, click the Database Listings tile
2. Click the Filter Vocabularies tab near the top of the screen
3. Click the List Terms link to the right of Category
   1. To Add new values:
      1. Click +Add Term
      2. Enter a Name for the new term
      3. Click one of the two save options
         1. Save, to save the value and stay in this screen to add another; OR
         2. Save and go to list, to save the value and return to the list term view
   2. To Edit a value:
      1. Click the Edit button to the right of the value
      2. Update the name
      3. Click Save

Creating Database Listings

1. From the Dashboard, click the Database Listings tile
2. Click + Add Database Listing
3. Fill out the form with the following information:
   
   1. Title - enter the name of the database being added
   2. Language - select the most appropriate language, if applicable
   3. Description - enter description of the database, including any relevant context or instructions for users
   4. Category - select the most appropriate category value
      1. This is a filter vocabulary, as described in the Considerations section of this article
   5. Upload/Select File - click to upload an image/logo for the database
      1. If the database is selected as "Featured" this image/logo will appear in the mini-slider at the top of the database listing page
      2. See the Recommended Image Sizes article for guidance when uploading/selecting images
   6. URL - enter or paste the URL of the database
   7. Featured checkbox, when checked this will add the listing to the Featured Databases box typically seen on the left side of the screen (this layout can be changed from the Style Editor)
      1. If an image was added, this will be added to a mini slider that will appear at the top of the database listing page
   8. Links section
      1. Add up to 5 additional links for the database listing by adding
         1. URL(s) -  link associated with the database
         2. Link text - to be displayed to the user/patron
   9. Review and modify the Publishing workflow options if needed
   10. Click Save to finish creating the database listing

Settings for Database Listings

Once you have added databases to the listing, additional settings can be configured to control how the list of databases is displayed to your users/patrons. 

• Listing View - this is the initial list of directory listing entries users/patrons will see when they navigate to the /databases page

To update the view settings:

1. From the Dashboard, click the Database Listings tile
2. Click the Settings tab at the top of the screen
3. Click the Listing View sub-tab
   1. Enable Listing View, when checked this enables access to the listing view for the content type
      1. If disabled, when a user attempts to load the URL for this content, they will be redirected to the homepage
   2. Title, edit the title for the page if desired, the default value is Database Listing
   3. Description, enter a description for the page if desired, this will be visible to users/patrons
   4. Display section
      1. Expand First Group by Default, check this box to expand the items, when they are grouped
      2. Display search form, check this box to display a search bar for entries
      3. Display A-Z Link Index, check this box to display a link on the list view when "Group by None" is selected
      4. Enable Add to saved list button, check this box to enable a save to list button
   5. Defaults section
      1. Default Page Limit, select the number of entries to be displayed before pagination is enforced
      2. Default Grouping, select the default value entries should be grouped by
         1. Note: users/patrons can change this when viewing the list of entries
      3. Default Sort Field, select the default value entries should be sorted by
      4. Default Sort Order, select the default order in which entries should be sorted
         1. Note: users/patrons can change this when viewing the list of entries
   6. Field Visibility section
      1. Check the box beside each field that should be made visible to users/patrons when viewing the list of directory entries
   7. Click Save configuration when finished