Advanced Lists Update Needed

This is a basic idea that Advanced Lists are necessary and need a facelift.

The simple fact that the recent very useful "Group Contact Tracing" list BB implemented had to be implemented using Adv. Lists illustrates this. It also illustrates that inherent limitations in SKY lists is not enough.

Some changes needed to Adv. Lists:

  • Add all tables and fields. [newer stuff is missing]

  • Put together a searchable data model diagram so one can find a particular field and how it would fit into a list

  • Make editing more useful:

    • Allow drag and drop of filters and objects

    • Put in a Save As

    • Where there are enumerated values, put up a selection box instead of requiring one to type in a value

  • Document Better

    • Explain the difference betw. filtering by 'Where' clause vice in 'Join'. (Examples!)

  • john ronan
  • Jul 28 2021
  • Under consideration
  • Attach files
  • Neil MacDonald commented
    17 Jan 07:03pm

    Yes, some of the fields are missing. For instance, in onCampus you can indicate (by checkbox) an assignment as Incomplete, Missing, Exempt, Collected or Late but in Advanced List there are only fields for Incomplete, Exempt or Late.

  • Bob Raymond commented
    7 Dec, 2023 12:51pm

    please add ability to get form entry data from advanced list - not just the form meta data.

  • Brian Gray commented
    29 Oct, 2021 12:17pm

    I agree with John Ronan - I would also like to see the addition of class meeting times for a section - one row per meeting.


    • I would also like to see the equivalent of the "Ask" option in an EE query. That allowed me to create a query that filters on a field, but prompted me for the search value at run-time. This would eliminate the need for maintaining several lists that are identical except for the value of one item in the filters.

    • After that, I would like the ability to specify the value for the "Ask" field via the API (V1ListsAdvancedByList_idGet). (The EE API did this 15 years ago.)

    • I would like to be able to create a URL to run each list. Of course, the user would have to be signed in and have appropriate permissions. If that URL also allowed me tos specify the value of the Ask field, it would make it much easier for me to give teachers access to a roster of students in a grade level or a division.

    • Add an option to run the list and automatically initiate an export to a CSV file (instead of making in a multi-step process, I could give users a URL that will create and download a CSV data file with one click.

    • I would like to have any list of values in a drop-down list for selection appear in alphabetical order. There doesn't appear to be any consistent or predictable order for some current lists. Ideally, any currently selected value(s) would be listed first, followed by unselected values.

    • In cases where the filter field allows for multiple items to be selected, consider changing to a checkbox format. That will make it less likely that I accidentally unselect all of the currently selected values while selecting another one.

    • When the filter field's list of values has many, many entries (such as the list of roles), please show me more than 9 at a time. I have a large screen on my computer. Make the selection list fill it up if needed to show more options.

  • john ronan commented
    14 Oct, 2021 03:25pm

    When displaying fields for display or for adding to filter, display them in a predictable order. [alphabetical?].

    E.g. things like custom fields seem to be displayed in random and , since we use many , it's often hard to find the one I need.

  • john ronan commented
    13 Oct, 2021 05:32pm

    re John Simpson's "ability to join objects at will

    • selecting 1 object dictates which objects can be selected next"

    I get that more flexibility is needed, but I kinda like the fact that only the inclusion of certain [parent] objects allows the inclusion of child objects. [e.g. what comes to mind is only seeing 'academic department' after including 'course department' ].

    Perhaps we could have both:, where, e.g. you'only see 'Academic Department' displayed in unselectable gray if you haven't included course department.

    I think what'd be needed here is a tree display, showing the hierarchy. [hmmm smacks of EE queries....]

  • john ronan commented
    13 Oct, 2021 05:26pm

    I'd like to see meeting times of classes on (day, time)

    Also, some of the newer features are not there. [e.g. student checklists? official notes?]

  • Alex Mendiola commented
    13 Oct, 2021 04:37pm

    John and Morgan, this is great! I hope others will comment their needs as well. This is a great start. Thank you so much!

  • john simpson commented
    13 Oct, 2021 04:25pm

    my wish list:

    • updated data map of objects with descriptions

    • ability to join objects at will

      • selecting 1 object dictates which objects can be selected next

      • unable to join 2 instances of the same object

    • ability to have multiple group by fields

    • ability to edit SQL code

    • ability to access our data using, for example, Crystal Reports, Oracle SQL Developer, etc.

  • Morgan Kunze commented
    12 Oct, 2021 09:07pm

    My biggest request here would be a table of info from the CBE module. I would appreciate being able to pull a list of ALL sub-skills currently entered, and have output options include what classes they're associated with, category, content-area skill, active/inactive status, etc. Fondest hopes would also allow me to see whether/how often they've been assessed or at least most recent date of use. This would be so helpful in auditing our skills lists and assessing how teachers are using this tool.

  • Alex Mendiola commented
    12 Oct, 2021 03:04pm

    Hi John,

    We are currently looking into Advanced lists functionality and we were wondering if the community could post what fields and tables you would like to see in Advanced Lists that are currently missing.

    Thanks so much,

    Alex Mendiola

    K-12 Product Manager