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.

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

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

Also:

• 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.

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.

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....]

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?]

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

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.

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.

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