Skip to content

Files

Latest commit

 

History

History
161 lines (140 loc) · 5.33 KB

DotNetTutorialSorting.md

File metadata and controls

161 lines (140 loc) · 5.33 KB

Popcorn > Documentation > DotNet > Tutorial: Sorting

Table Of Contents

This is a more advanced tutorial - we recommend you read Getting Started and our other tutorials first to familiarize yourself with Popcorn.

Let's say not only do you want to have your response objects from your APIs return only the specific properties you desire, but you'd also like the results to be sorted server side so you can just plug and play with your front end. Popcorn has the answer.

This tutorial will walk you through the two new additions to our query parameters that we've added, "sort" and its related partner "sortDirection", and how they can be leveraged with your APIs.

First let's see an example of a typical response object to the following request from a Cars endpoint

http://localhost:50353/api/example/cars?include=[Make, Model, Color, Owner[FirstName, LastName]]

{
    "Success": true,
    "Data": [
        {
            "Owner": {
                "FirstName": "Liz",
                "LastName": "Lemon"
            },
            "Model": "Firebird",
            "Make": "Pontiac",
            "Color": "Blue"
        },
        {
            "Owner": {
                "FirstName": "Jack",
                "LastName": "Donaghy"
            },
            "Model": "250 GTO",
            "Make": "Ferrari N.V.",
            "Color": "Red"
        },
        {
            "Owner": {
                "FirstName": "Jack",
                "LastName": "Donaghy"
            },
            "Model": "Cayman",
            "Make": "Porsche",
            "Color": "Yellow"
        }
    ]
}

This is a good response as it only includes the information we want, but let's take it a step further and assume this list is 500 results long. We ultimately want to be able to present this list of Cars to a user in a browser, and it may benefit us to push the sorting to our server and minimize the code and load on the front end.

Now show me the sorting! Introducing our query parameter "sort" in action

http://localhost:49695/api/example/cars?include=[Make, Model, Color, Owner[FirstName, LastName]]&sort=Model

{
    "Success": true,
    "Data": [
        {
            "Owner": {
                "FirstName": "Jack",
                "LastName": "Donaghy"
            },
            "Model": "250 GTO",
            "Make": "Ferrari N.V.",
            "Color": "Red"
        },
        {
            "Owner": {
                "FirstName": "Jack",
                "LastName": "Donaghy"
            },
            "Model": "Cayman",
            "Make": "Porsche",
            "Color": "Yellow"
        },
        {
            "Owner": {
                "FirstName": "Liz",
                "LastName": "Lemon"
            },
            "Model": "Firebird",
            "Make": "Pontiac",
            "Color": "Blue"
        }
    ]
}

You now see that the results are sorted in an ascending order by their Model property, easy as that!

Requirements and constraints

We didn't aim to hit all use cases here so if there is something you'd like to see or use, please submit a PR or write an issue and we'd love to work with you!

  • The "sort" parameter passed in may only be one parameter and it is case sensitive.
  • The parameter being targeted for "sort" may only be on the primary response object.
    • i.e. In the example above "Model" works great, but sort=FirstName will not work.
    • Also targeting complex types will not work either because, for example, sorting based on "Owner" is a bit more tricky than a simple sort.
  • An "include" is not required to sort a response.
  • For that matter, neither is a "sortDirection" as it will default to ascending.

"sortDirection" is a far more simple query parameter as it just accepts two values, "Ascending" and "Descending" (case sensitive) and specifies the way the sort target is to be sorted. Just remember, as we mentioned already, the sort direction defaults to "Ascending" should a sort be provided and no "sortDirection".

Here we see it being used in the wild with the same simple Cars example:

http://localhost:49695/api/example/cars?include=[Make, Model, Color, Owner[FirstName, LastName]]&sort=Model&sortDirection=Descending

{
    "Success": true,
    "Data": [
        {
            "Owner": {
                "FirstName": "Liz",
                "LastName": "Lemon"
            },
            "Model": "Firebird",
            "Make": "Pontiac",
            "Color": "Blue"
        },
        {
            "Owner": {
                "FirstName": "Jack",
                "LastName": "Donaghy"
            },
            "Model": "Cayman",
            "Make": "Porsche",
            "Color": "Yellow"
        },
        {
            "Owner": {
                "FirstName": "Jack",
                "LastName": "Donaghy"
            },
            "Model": "250 GTO",
            "Make": "Ferrari N.V.",
            "Color": "Red"
        }
    ]
}

It may go without saying, but if no "sort" is provided, then we don't apply a "sortDirection" by default.

Easy as that! Please don't hesitate to submit a PR or issue with requests for added functionality or updates that will help you in using the sort functionality.