Advanced Lists
A platform manager or list manager (users with the Manage list category task) can create specific, customized queries without the constraints of basic lists. From Reporting, select Manage lists and then select Manage basic and advanced lists.
Since advanced lists are ad hoc queries, each object in an advanced list corresponds to a table and data in your database. You can join objects together to create lists of data from multiple tables of data. You can also choose how to filter the data and which data to show in the output.
Tutorial: For detailed step-by-step instructions, see the Advanced Lists tutorial.
Tip: This advanced feature requires knowledge of how to write and work with SQL statements. You also need a firm understanding of how data in stored in various tables for your school's database. As an alternative, we encourage you to use the newer "Sky" lists. They're designed to be more intuitive, user friendly, and they don't require SQL. Refer to Manage lists.
A platform manager can assign users the list admin role. See roles and tasks for instructions.
A user with the list admin role can access all data in the lists. This includes data which is not controlled by profile access or directory settings. We strongly recommend you only grant employees who need access to this data the list admin role. Likewise, take care when you grant users access to view list results or use the Favorite Lists Portal channels.
All information for your school's 'Blackbaud's Education Management' products is stored in your database. The structure of the database correlates to how your school runs in the real word.
For example, your school may have one or more campuses, each campus has several buildings, and each building has several offices. Typically, buildings have specific purposes. Alums are probably managed from a single building and specific tasks for alums (such as giving and communications) may be managed from specific offices. Admissions, Academics, and Athletics are likely handed in similar ways.
To handle this, the database would include tables of information about the departments, the campuses, the building names, room names, and more.
A query is a request for information from your database. It doesn't change any data; it only shows you the data. Sometimes there are multiple ways to request the same information; there may be multiple ways to create a query which fulfills your need.
-
Objects - the tables or pieces of data in your database; these may be fields or information calculated from other fields; for example: a student record probably includes the student's name, birth date, current age, and more
-
Filters - the criteria used to limit the results
-
Display fields - results and related data about those results
SQL - structured query language
For example, imagine this scenario: If you needed to visit a student at 9:15am, how would you do it?
You might go to the school campus, review the schedule to learn what block is meeting, review the student's schedule to learn what class the student has during that block, find the room where the class meets, go to the room and see him sitting in a row at his desk. Or you might do something different, but still find the student.
In this example, the school is like your database. Information about the class are objects. The filters are the student name and the time. The row and seat where he sits are like display fields.
A platform manager can give users (including users who are not managers) access to lists in your school's database.
-
Select Reporting.
-
Select Manage Lists
-
Select Manage basic and advanced lists.
-
Select List admin.
-
Select Access.
-
Choose:
-
Advanced role access to add or remove advanced lists access by role.
-
Advanced user access to add or remove advanced lists access by user.
-
-
Select Save & exit.
-
Select Reporting.
-
Select Manage lists.
-
Select Manage basic and advanced lists.
-
Tip: List templates can be a great starting point if you don't want to create a list from scratch.
-
Select Add, followed by Create advanced list.
-
Enter a name for the list. The name should remind you or other users of the purpose for the list.
-
Select an existing category or create a new one.
-
Enter a description. Consider describing when to use the list or the information it contains. If other users can access the list, the description gives them context to better understand its purpose.
-
Select the objects of data that you want the list's query to use.
-
Some objects include other objects. Select + on the parent object to view its children.
-
Objects are connected by either inner or outer joins.
-
Inner - the query only finds fields that both objects have in common. For example, all users with "staff role" also have the "user role." It's like the center region of a Venn diagram.
-
Outer - the query find fields from each object. In a Venn diagram, it's like both circular regions.
-
-
-
Filter the objects to only include data that meet your criteria. For example, you many want to only see result from the current school year.
-
For Display fields, select the data that you want to view in the results.
-
For Order by, select how the results should be sorted.
-
Preview the SQL statement. This runs your query based on the objects, display fields, and other criteria you selected.
-
Select the Output options.
When you copy a basic or advanced list, the original list remains unchanged. You create a new list (copy) that only uses the topic that the original list used.
Platform managers, the creator of the list, and anyone who has been granted access or security rights to "copy" the list can do this.
-
Select Reporting.
-
Select Manage lists.
-
Select Manage basic and advanced lists.
-
Select Copy next to the appropriate list.
-
Edit the all desired fields.
-
Select Save & exit.
Use categories to organize basic or advanced lists
Users create categories. You'll assign a list to a category when you create or edit the list.
Alternatively, you create a category and then assign lists to the new category.
-
Select Reporting.
-
Select Manage lists.
-
Select Manage basic and advanced lists.
-
From Options (at the top-right) select Organize.
-
At the top of the screen:
-
Enter a Sort Order (optional).
-
Enter a Category name.
-
Select the Add link.
-
-
Select Save & exit.
You can delete a category you previously used to organize lists.
-
Select Reporting.
-
Select Manage lists.
-
Select Manage basic and advanced lists.
-
From Options (at the top-right) select Organize.
-
Select Delete(next to the list name).
-
Select Save.
-
Select Reporting.
-
Select Manage lists.
-
Select Manage basic and advanced lists.
-
From Options (at the top-right) select Organize.
-
Change the name for the appropriate list in the Category column.
-
Select Save.
Users can assign lists to categories previously created.
-
Select Reporting.
-
Select Manage lists.
-
Select Manage basic and advanced lists.
-
From Options (at the top-right) select Organize.
-
In the Category drop down list next to the list name, select a category.
You can also add lists to categories when you create a category, create a list, or edit a list.
By default, categories appear in alphabetical order. Lists appear alphabetically under each category.
Change the order to group similar items or frequently used items.
-
Select Reporting.
-
Select Manage lists.
-
Select Manage basic and advanced lists.
-
From Options (at the top-right) select Organize.
-
In the Sort order column, enter numbers to use to display the lists on the My lists screen.
-
Select Save.
Tip: Many schools use either SKY API or the ON “Legacy” API to extend the functionality of Education Management, as well as to integrate with third party and custom applications. To send the right data to those extensions, they often first create advanced lists in Education Management. List managers should inform the application or developer of the List ID you want to use to help expand your school’s capabilities. Find it in the details for the list on the My lists screen.