This is a migrated thread and some comments may be shown as answers.

Best practices for handling a big user-sorted list?

4 Answers 73 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Chris
Top achievements
Rank 1
Chris asked on 07 Feb 2018, 08:15 PM

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

4 Answers, 1 is accepted

Sort by
0
Eyup
Telerik team
answered on 12 Feb 2018, 08:47 AM
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.
0
Chris
Top achievements
Rank 1
answered on 06 Mar 2018, 09:31 PM

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

 

Chris

0
Eyup
Telerik team
answered on 08 Mar 2018, 02:34 PM
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 . 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.
0
Rosa66
Top achievements
Rank 1
answered on 13 Feb 2019, 04:24 AM

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.

 

Tags
General Discussions
Asked by
Chris
Top achievements
Rank 1
Answers by
Eyup
Telerik team
Chris
Top achievements
Rank 1
Rosa66
Top achievements
Rank 1
Share this question
or