Best practices for handling a big user-sorted list?

5 posts, 0 answers
  1. Chris
    Chris avatar
    23 posts
    Member since:
    Mar 2012

    Posted 07 Feb 2018 Link to this post

    My website is focused on the NFL and its most engaged fans. These people enjoy following the NFL Draft, which is the annual selection process that determines what pro football teams graduating college players will play for. Our audience is very opinionated on the Draft, and we give them the ability to put the players in their own sort order based on their own opinions.

    You do not need an account to see what this looks like: http://football.powerhousegm.com/DraftRoom/BigBoard2.aspx?v=s

    There are about 1,200 players in this list; 100 per page. Each player has a specific slot in the overall order ("Rank") and users can put them in broader tiers by assigning a "Grade" (if you look at the page, the pink "R1+/R1" is the highest Grade.) Click on the pink button to see how a user would change the Grade.

    We've run into trouble with this process (which does not use Telerik controls... yet.) Changing a Grade should move the player into the range in the overall order where similarly Graded players sit. But, where specifically in that order? At the top of that group if the player is being downgraded, and at the bottom of the higher tier if the user is changing his Grade to a higher one? In short, it's a messy process that I haven't solved logically, and thus haven't solved technically.

    Does anyone have a good idea how we could handle this that would provide the best user experience?

    The idea I'm toying with right now is to have tabs across the top of the list for each possible Grade, and grabber handles or something to allow the user to drag/drop prospects up/down in the list on each particular tab... or up/down buttons to move them one slot at a time. The user could still change the Grade, which would move the player to another tab.

    Thanks in advance for any ideas/guidance!

     

    Chris Barry

  2. Eyup
    Admin
    Eyup avatar
    3866 posts

    Posted 12 Feb 2018 Link to this post

    Hello Chris,

    I will give you some suggestions which can prove helpful to clarify the technical approach you gonna take:

    1. Sorting - you can make this column a GridTemplateColumn with two fields in your database - one to hold the name of the Grade and the second one to hold some numeric representation. Then, you will set the DataField and SortExpression of the column to the numeric field which will automatically sort the grades.

    2. Multi-column sorting - this will enable you to sort the grid by multiple fields. For example, the primary field may be the Grade and the secondary, which will determine where the changed prospect is placed, may be his name, Ht or Wt:
    https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/sorting/basic-sorting/defaultcs.aspx 

    3. Grouping - you can group by the Grade and apply additional sorting within the group:
    https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/grouping/group-footers/defaultcs.aspx

    4. Custom sorting - the grid also provides custom sorting. You can check the second grid in the following live sample:
    https://demos.telerik.com/aspnet-ajax/grid/examples/functionality/sorting/custom-sorting/defaultcs.aspx

    I hope this will prove helpful.

    Regards,
    Eyup
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Chris
    Chris avatar
    23 posts
    Member since:
    Mar 2012

    Posted 06 Mar 2018 in reply to Eyup Link to this post

    Thanks so much, Eyup. Your response got us started on the right path, and we're moving forward. Much-appreciated!

     

    Chris

  4. Eyup
    Admin
    Eyup avatar
    3866 posts

    Posted 08 Mar 2018 Link to this post

    Hi Chris,

    I'm glad the provided directions have proven helpful. Thank you for choosing Telerik as your default .NET development tools provider. There might be some minor issues at first, but after some time when you get used to Telerik UI Controls, they will become your favorite and irreplaceable software and web development assistants. We, the Telerik support team, will be here to assist you when necessary.

    Regards,
    Eyup
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  5. Rosa66
    Rosa66 avatar
    1 posts
    Member since:
    Feb 2019

    Posted 12 Feb Link to this post

    I am really happy to say it’s an interesting post to read.

    I learn new information from your article , you are doing a great job. Keep it up.

     

Back to Top