Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

OrderBy Type (Print Format Item View)

Description

The objective is to possibilite to order by row desc too ( preview format item)

Environment

None

Attachments

3
  • 18 Feb 2012, 08:48 PM
  • 18 Feb 2012, 07:34 AM
  • 16 Feb 2012, 07:06 AM

Activity

Show:

Carlos Ruiz February 19, 2012 at 7:36 AM

https://bitbucket.org/idempiere/idempiere/changeset/b400265ed8c7

Thanks Fernando, tested and integrated.

Heng Sin, I think it was my fault as I advised wrongly to Fernando to explore that option - you're right, this solution is better.

Regards,

Carlos Ruiz

Fernando Moraes February 18, 2012 at 8:48 PM

Heng... I agree with you, this was the first thing that I have done, but I'm trying to avoid create a new column, and the sort tab just will be ok if we add a abs function on sql because of line (DateEnfine Line 259).

I'm putting here a patch to this and a packOut (contains table and window modification)

Heng Sin Low February 18, 2012 at 10:41 AM

How about the sort tab at the web and swing client ? Will it still work correctly if SortNo can be negative ?

I would prefer we implement this using a new IsDesc column and it should be relatively straightforward to add a descending check box to the sort tab to support it. It is much more intuitive too that the user doesn't have to remember to use -ve sort no for descending sorting.

Fernando Moraes February 18, 2012 at 7:34 AM

New Patch to.:

ColumnA -> SortNo = 1
ColumnB -> SortNo = -2
ColumnC -> SortNo = 3

In this scenario the resulting query must be -> ORDER BY ColumnA, ColumnB DESC, ColumnC

Carlos Ruiz February 17, 2012 at 6:48 AM

Math.abs -> yep

pfi.SortNo <> 0 -> sounds right

Fixed

Details

Assignee

Reporter

Labels

Components

Affects versions

Priority

Created February 16, 2012 at 6:49 AM
Updated March 13, 2014 at 2:20 PM
Resolved February 19, 2012 at 7:36 AM