C# Sort by multiple value

Question

I need to sort a list on multiple values. Data comes from a MongoDb database and I load its from C#.

SAMPLE

Unsorted            
OwnerId     Status      Date
123         New         2016-01-01
456         New         2016-01-01
789         New         2016-01-06
123         New         2016-01-05
456         Qualified   2016-01-05
789         Converted   2016-01-01
123         Qualified   2016-01-02

Expected
OwnerId     Status      Date
123         New         2016-01-05
123         New         2016-01-01
123         Qualified   2016-01-02
789         New         2016-01-06
456         New         2016-01-01
456         Qualified   2016-01-05
789         Converted   2016-01-01

I need to show OwnerId 456 first, then New status first, then Date descending.

OwnerId is a dynamic value : it's my current authenticated user in my app. I can't access this value from anywhere. OwnerId value type is a GUID in real case.

I try this without success : c# How to sort a sorted list by its value column1

C# List<> Sort by x then y2

I hope my problem is enough understandable. Do not hesitate to ask more details. Thanks in advance.

Edited :

I can't achieve this with mongo directly. I need a C# solution.

Answer 1

You can sort using this query:

db.<people>.sort( { OwnerId : 0, Date : 1 })

Do you need to translate this query in C# using MongoDB client?

Answer 2

Try this query which may help you getting your desired result:-

db.collName.find({findQuery}).sort({ 'OwnerId' : 1, 'Status':1, 'Date' : -1 })

The query will first sort your records in ascending order for OwnerId. Then it will sort based on value of status and in the end it will sort in descending order for Date field.

Now you should get your desired result with all the sorting

See sort-example for more idea on how you can use it in various ways. See the last example which is similar to your requirement.

Hope this will help you.

NOTE :- If there are lots of records, use .limit() as well with your query. See doc.

Answer 3

I copied your data set, but your projected sort outcome is a little off specifically the OwnerId property. However, run this code inside of a Console application (or whatever template you prefer), and let me know if these are the results you are seeking:

public class GonnaSortThisData
{
    public GonnaSortThisData()
    {
        User currentUser = new User
        {
            UserId = 123,
            UserName = "UserMan"
        };

        List<Data> dataValues = new List<Data>
        {
            new Data {OwnerId = 123, Status = Status.New, Date = DateTime.Parse(@"2016-01-01")},
            new Data {OwnerId = 456, Status = Status.New, Date = DateTime.Parse(@"2016-01-01")},
            new Data {OwnerId = 789, Status = Status.New, Date = DateTime.Parse(@"2016-01-06")},
            new Data {OwnerId = 123, Status = Status.New, Date = DateTime.Parse(@"2016-01-05")},
            new Data {OwnerId = 456, Status = Status.Qualified, Date = DateTime.Parse(@"2016-01-05")},
            new Data {OwnerId = 789, Status = Status.Converted, Date = DateTime.Parse(@"2016-01-01")},
            new Data {OwnerId = 123, Status = Status.Qualified, Date = DateTime.Parse(@"2016-01-02")}
        };

        //var = List<Data>
        var sortedValues = dataValues
            .OrderByDescending(list => list.OwnerId == currentUser.UserId)
            .ThenBy(list => list.Status)
            .ThenByDescending(list => list.Date).ToList();
    }
}

public class User
{
    public int UserId { get; set; }
    public string UserName { get; set; }
}

public class Data
{
    public dynamic OwnerId { get; set; }
    public Status Status { get; set; }
    public DateTime Date { get; set; }
}

public enum Status
{
    New, Qualified, Converted
}

Please ignore the Enum and Data class as they were merely to represent the records that stem from the MongoDB database table. The dynamic property will be resolved by LINQ on the fly at runtime. Look carefully at the calls to ThenBy(). This is one of my most favorite LINQ extensions, and please note you have the ability to do this in query syntax, but I simply chose to use method syntax.

Answer 4

Example of multiple sort

  return await Collection()
       .Find(_ => true)
       .Sort(Builders<SomeEntity>.Sort.Descending(x => x.SomeValueToSort1).Descending(x => x.SomeValueToSort2))
       .ToListAsync();