Sky list data fields are unavailable to choose as a column or as a filter

Sky lists are great, but it seems all to frequently find that fields are unavailable to choose as a column or as a filter. 

For example, I'm attempting to pull a list of Student IDs for the incoming students and I'm able to pull the first, middle and last names, the year of graduation but not the student id field.

Another example would be in onBoard you can not access the middle name field for candidates as this year we had two students with the same first and last name (not related) that was difficult to tell them apart without access to the middle name in the list.

User Lists is a great example of filters not available.  Say I would like to review my incoming students data to ensure completeness.  I use a sky list to create a list filtered by role "has any of these specific ones" and selected "incoming students".  I now have all of my incoming students in a list, but my only other filtering option is "Persona Criteria" which is not overly helpful.

It would be best to allow people "query" all the fields of a table (withing access constraints of that persons role), allow selection of all the fields along with the ability to sort and filter by those fields.

  • Gregg
  • May 8 2017
  • Attach files
  • john ronan commented
    January 14, 2021 14:48

    Well, it's been three years since this original "idea" was posted.

    Is there ANY movement toward a more general approach to lists that exposes ALL aspects of an object instead of just those [few] some developer decide are important?

    Education Edge did this 15 years ago!

  • john ronan commented
    December 11, 2020 18:31

    We need FINANCIAL AID amount and type.

    The right solution is to generalize these lists so we can choose whatever fields we want for filters [or for columns].

    The information is there in the database [metadata]. EE was doing this 15 years ago.

    PLEASE!

  • Mary Zieten commented
    March 25, 2019 16:02

    And after a call to support, I can't even pull this using advanced lists because they don't pull GPA.  So what I'm trying to do is literally impossible, and it really shouldn't be that way.

  • Mary Zieten commented
    March 25, 2019 15:27

    I realized today that we can't pull a list of students by the group they're in.  For me, this means that I'll be pulling my hair out trying to build an advanced list because I can't filter a SKY list on the members of the baseball team...  I realize that we're trying to keep things simpler, but it's very frustrating to work with, especially because the alternative is so hard to work with.

  • Guest commented
    June 22, 2018 14:05

    Gregg mentioned the middle name field for onBoard lists which had been requested multiple times by clients 

  • Gregg commented
    October 04, 2017 14:43

    Janet

    We've noticed some additional items showing up.  Please keep it coming!  Medical could use a lot of help in this area.  The ability to track "physical exam" dates and "pre-participation concussion form" dates and the ability to query those dates, in particular to identify which students have not had one submitted.

    Thank you

  • Janet Wittenberg commented
    August 23, 2017 13:27

    I hope you have noticed we have added Student ID as a column on the Student List.  We have added a few more filters on the User List but more is to come.  Thanks for the specific example of Middle Name missing on Candidate List - it will help us fix those important problems more quickly.  We have more work to do in this area!

  • Guest commented
    July 12, 2017 19:34

    Agreed! Any decent reporting tool should be able to pull *every* field that exists.