Eclipse Community Forums: BIRT

Home » Archived » BIRT » Comparators

Mon, 12 November 2007 14:06

Eclipse User

Originally posted by: thomas.cintegrity.com

In our design there is a class which has both a parent association to
the same class and a predecessor association to this class. This
creates an outline type structure like:
1.
1.1
1.2
2.
2.1
2.2
where 1.1 is a predecessor to 1.2, both 1.1 and 1.2 are parented to 1.
and 1.1 has a predecessor of 1. Likewise for the 2* entries and 1. is
the predecessor of 2. Links are navigatible in either direction. In
normal operation, a Comparator for this class provides for sort order
based on these relationships.

Is there any way to utilize this Comparator to provide sort order in a
BIRT report? I'm a bit puzzled as to how to achieve it with straight
SQL on the persisted class.

Re: Comparators [message #261497 is a reply to message #261261]

Thu, 15 November 2007 12:13

Eclipse User

Originally posted by: jasonweathersby.alltel.net

Thomas,

Can you call your class from the sort expression and return a numeric
value for the level? If you can do that the sort expression can be set
to ascending and lower numbers will be presented first. I am not
certain this is really what you are looking for.

Jason

Thomas Mercer-Hursh wrote:
> In our design there is a class which has both a parent association to
> the same class and a predecessor association to this class. This
> creates an outline type structure like:
> 1.
> 1.1
> 1.2
> 2.
> 2.1
> 2.2
> where 1.1 is a predecessor to 1.2, both 1.1 and 1.2 are parented to 1.
> and 1.1 has a predecessor of 1. Likewise for the 2* entries and 1. is
> the predecessor of 2. Links are navigatible in either direction. In
> normal operation, a Comparator for this class provides for sort order
> based on these relationships.
>
> Is there any way to utilize this Comparator to provide sort order in a
> BIRT report? I'm a bit puzzled as to how to achieve it with straight
> SQL on the persisted class.

Previous Topic:	UNSUPPORTED_VERSION exception
Next Topic:	Evaluating Business Intelligence Options for Software developers

Goto Forum:

-=] Back to Top [=-

Current Time: Mon Nov 17 06:23:48 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter