sort number column in ngx-datatable in ascending and descending order. Angular 2/4





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







2















I need to sort an ID number column in a ngx-datatable. I also have null values in the table, how do i get the column in ascending order and get the null in the end. It sorts from fine from the server but when i try to sort desc and back to ascending the nulls always come first. I need then to bein the end when sorting ascending order. Here are some of my codes



Template

<ngx-datatable-column prop="ID" name="ID">
<template let-column="column" let-sort="sortFn" ngx-datatable-header-template>
<span (click)="sort()" class="sort-fullwidth">ID</span>
</template>
</ngx-datatable-column>


I have no clue where that sort method goes. I tried the [sorts]= " [{ prop : 'ID', dir : 'asc' ] ", [comparator] (but not sure i did it correct).



Thank you










share|improve this question





























    2















    I need to sort an ID number column in a ngx-datatable. I also have null values in the table, how do i get the column in ascending order and get the null in the end. It sorts from fine from the server but when i try to sort desc and back to ascending the nulls always come first. I need then to bein the end when sorting ascending order. Here are some of my codes



    Template

    <ngx-datatable-column prop="ID" name="ID">
    <template let-column="column" let-sort="sortFn" ngx-datatable-header-template>
    <span (click)="sort()" class="sort-fullwidth">ID</span>
    </template>
    </ngx-datatable-column>


    I have no clue where that sort method goes. I tried the [sorts]= " [{ prop : 'ID', dir : 'asc' ] ", [comparator] (but not sure i did it correct).



    Thank you










    share|improve this question

























      2












      2








      2








      I need to sort an ID number column in a ngx-datatable. I also have null values in the table, how do i get the column in ascending order and get the null in the end. It sorts from fine from the server but when i try to sort desc and back to ascending the nulls always come first. I need then to bein the end when sorting ascending order. Here are some of my codes



      Template

      <ngx-datatable-column prop="ID" name="ID">
      <template let-column="column" let-sort="sortFn" ngx-datatable-header-template>
      <span (click)="sort()" class="sort-fullwidth">ID</span>
      </template>
      </ngx-datatable-column>


      I have no clue where that sort method goes. I tried the [sorts]= " [{ prop : 'ID', dir : 'asc' ] ", [comparator] (but not sure i did it correct).



      Thank you










      share|improve this question














      I need to sort an ID number column in a ngx-datatable. I also have null values in the table, how do i get the column in ascending order and get the null in the end. It sorts from fine from the server but when i try to sort desc and back to ascending the nulls always come first. I need then to bein the end when sorting ascending order. Here are some of my codes



      Template

      <ngx-datatable-column prop="ID" name="ID">
      <template let-column="column" let-sort="sortFn" ngx-datatable-header-template>
      <span (click)="sort()" class="sort-fullwidth">ID</span>
      </template>
      </ngx-datatable-column>


      I have no clue where that sort method goes. I tried the [sorts]= " [{ prop : 'ID', dir : 'asc' ] ", [comparator] (but not sure i did it correct).



      Thank you







      angular ngx-datatable






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Oct 19 '17 at 21:34









      hangManhangMan

      316




      316
























          2 Answers
          2






          active

          oldest

          votes


















          4














          It will look something like this:



          <ngx-datatable class='material' [columns]="columns" [rows]="rows" [columnMode]="'force'" [headerHeight]="50" [footerHeight]="50" [rowHeight]="'auto'" [limit]="100" [sortType]="'multi'" [reorderable]="true" [sorts]="[{prop: 'ID', dir: 'asc'}]">





          share|improve this answer



















          • 1





            Could you provide a more detailed answer/explanation. See here

            – Mathieu de Lorimier
            Nov 6 '17 at 19:34



















          0














          The following link describes default sorting but ilyaoverflow is right. The only line you need to add to your HTML is this:

          [sorts]="[{prop: 'approvalStatus', dir: 'asc'}]"

          https://github.com/swimlane/ngx-datatable/blob/master/demo/sorting/sorting-default.component.ts






          share|improve this answer
























            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f46839248%2fsort-number-column-in-ngx-datatable-in-ascending-and-descending-order-angular-2%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            4














            It will look something like this:



            <ngx-datatable class='material' [columns]="columns" [rows]="rows" [columnMode]="'force'" [headerHeight]="50" [footerHeight]="50" [rowHeight]="'auto'" [limit]="100" [sortType]="'multi'" [reorderable]="true" [sorts]="[{prop: 'ID', dir: 'asc'}]">





            share|improve this answer



















            • 1





              Could you provide a more detailed answer/explanation. See here

              – Mathieu de Lorimier
              Nov 6 '17 at 19:34
















            4














            It will look something like this:



            <ngx-datatable class='material' [columns]="columns" [rows]="rows" [columnMode]="'force'" [headerHeight]="50" [footerHeight]="50" [rowHeight]="'auto'" [limit]="100" [sortType]="'multi'" [reorderable]="true" [sorts]="[{prop: 'ID', dir: 'asc'}]">





            share|improve this answer



















            • 1





              Could you provide a more detailed answer/explanation. See here

              – Mathieu de Lorimier
              Nov 6 '17 at 19:34














            4












            4








            4







            It will look something like this:



            <ngx-datatable class='material' [columns]="columns" [rows]="rows" [columnMode]="'force'" [headerHeight]="50" [footerHeight]="50" [rowHeight]="'auto'" [limit]="100" [sortType]="'multi'" [reorderable]="true" [sorts]="[{prop: 'ID', dir: 'asc'}]">





            share|improve this answer













            It will look something like this:



            <ngx-datatable class='material' [columns]="columns" [rows]="rows" [columnMode]="'force'" [headerHeight]="50" [footerHeight]="50" [rowHeight]="'auto'" [limit]="100" [sortType]="'multi'" [reorderable]="true" [sorts]="[{prop: 'ID', dir: 'asc'}]">






            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Nov 6 '17 at 19:16









            ilyaoverflowilyaoverflow

            411




            411








            • 1





              Could you provide a more detailed answer/explanation. See here

              – Mathieu de Lorimier
              Nov 6 '17 at 19:34














            • 1





              Could you provide a more detailed answer/explanation. See here

              – Mathieu de Lorimier
              Nov 6 '17 at 19:34








            1




            1





            Could you provide a more detailed answer/explanation. See here

            – Mathieu de Lorimier
            Nov 6 '17 at 19:34





            Could you provide a more detailed answer/explanation. See here

            – Mathieu de Lorimier
            Nov 6 '17 at 19:34













            0














            The following link describes default sorting but ilyaoverflow is right. The only line you need to add to your HTML is this:

            [sorts]="[{prop: 'approvalStatus', dir: 'asc'}]"

            https://github.com/swimlane/ngx-datatable/blob/master/demo/sorting/sorting-default.component.ts






            share|improve this answer




























              0














              The following link describes default sorting but ilyaoverflow is right. The only line you need to add to your HTML is this:

              [sorts]="[{prop: 'approvalStatus', dir: 'asc'}]"

              https://github.com/swimlane/ngx-datatable/blob/master/demo/sorting/sorting-default.component.ts






              share|improve this answer


























                0












                0








                0







                The following link describes default sorting but ilyaoverflow is right. The only line you need to add to your HTML is this:

                [sorts]="[{prop: 'approvalStatus', dir: 'asc'}]"

                https://github.com/swimlane/ngx-datatable/blob/master/demo/sorting/sorting-default.component.ts






                share|improve this answer













                The following link describes default sorting but ilyaoverflow is right. The only line you need to add to your HTML is this:

                [sorts]="[{prop: 'approvalStatus', dir: 'asc'}]"

                https://github.com/swimlane/ngx-datatable/blob/master/demo/sorting/sorting-default.component.ts







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 16 '18 at 18:50









                Stephen KuehlStephen Kuehl

                34112




                34112






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f46839248%2fsort-number-column-in-ngx-datatable-in-ascending-and-descending-order-angular-2%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Florida Star v. B. J. F.

                    Error while running script in elastic search , gateway timeout

                    Adding quotations to stringified JSON object values