Re: [pgAdmin4][Patch]: RM1938 - Backgrid sorting not working for Integer/Number types

From: Surinder Kumar <surinder(dot)kumar(at)enterprisedb(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: [pgAdmin4][Patch]: RM1938 - Backgrid sorting not working for Integer/Number types
Date: 2017-01-09 10:12:53
Message-ID: CAM5-9D-L8DRtOKHHFLB4J5MNspb+t4tfpz7rtmEXwrw4tCX6tA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Hi Dave,

I just missed the code for swapping left and right values if order is
descending. It's fixed.
Please find attached patch and review.

On Mon, Jan 9, 2017 at 9:05 AM, Dave Page <dpage(at)pgadmin(dot)org> wrote:

> Hi
>
> On Friday, January 6, 2017, Surinder Kumar <surinder(dot)kumar(at)enterprisedb(dot)
> com> wrote:
>
>> Hi,
>>
>> As the type of data we get from server side is of string type, due to
>> which the sorting for Integer/Number type columns is not working.
>>
>> To fix this issue, we are using BigNumber JS library.
>> We are overriding Backgrid's sort and make_comparator method in
>> backgrid.pgadmin.js.
>>
>> When sorting is performed based on column we identify the column
>> type(integer/number) and then convert its value into BigInteger and the
>> sorts data.
>>
>> This patch is dependent on patch sent for "Adding support for BigNumber
>> JS library".
>>
>> Also, thanks to Murtuza for help.
>>
>> Please find attached patch and review.
>>
>
> This works fine for ascending sorts, but if i click the row header a
> second time for a descending sort, the order isn't reversed as expected.
>
> Thanks, Dave.
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>

Attachment Content-Type Size
RM1938_v1.patch application/octet-stream 6.2 KB

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2017-01-09 10:25:45 pgAdmin 4 commit: Fix sorting of numerics in the statistics grids. Fixe
Previous Message Dave Page 2017-01-09 09:35:59 Re: PATCH: To fix the issue in exclusion constraint (pgAdmin4)