Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » [Ecore ODA Driver] - Joint data set?
[Ecore ODA Driver] - Joint data set? [message #44406] Wed, 07 May 2008 08:02 Go to next message
Henrik  önsson is currently offline Henrik önsson
Messages: 53
Registered: July 2009
Member
Hi,

I managed to get Birt and the new Ecore ODA driver to work. Great work!
Retrieving simple attributes from objects are dead easy.

I have a EClass called Track that has a EReference to a SpeedProfile
EClass. The relationship between Track and SpeedProfile is 0 to many.
I would like to create a report that displays a table with alll my Tracks
and their associated SpeedProfiles. Is this possible? If so how?

I'm new to Birt and OCL but it's akind of joint data set I suppose.

Regards
Henrik
Re: [Ecore ODA Driver] - Joint data set? [message #44438 is a reply to message #44406] Wed, 07 May 2008 12:46 Go to previous messageGo to next message
Jeff Ramsdale is currently offline Jeff Ramsdale
Messages: 122
Registered: July 2009
Senior Member
Great! Glad you're seeing some success...

The problem you're seeing is that the Ecore ODA Driver doesn't yet walk
the tree of references. We don't think it will be hard to implement, but
haven't gotten to it yet. Keep watching CVS and I'll try to post here
in the newsgroup when this feature is implemented.

Speaking of Joint Data Sets, you might be able to use one if you create
a Data Set for each dimension of your data--that is, create an Ecore
Data Set for Track and another for SpeedProfile and use a Joint Data Set
to join them. I haven't tried this, but I think that's the purpose of
the Joint Data Set. If you try it, let us know how it works...

-jeff

Henrik wrote:
> Hi,
>
> I managed to get Birt and the new Ecore ODA driver to work. Great work!
> Retrieving simple attributes from objects are dead easy.
>
> I have a EClass called Track that has a EReference to a SpeedProfile
> EClass. The relationship between Track and SpeedProfile is 0 to many. I
> would like to create a report that displays a table with alll my Tracks
> and their associated SpeedProfiles. Is this possible? If so how?
>
> I'm new to Birt and OCL but it's akind of joint data set I suppose.
> Regards
> Henrik
>
>
>
Re: [Ecore ODA Driver] - Joint data set? [message #44471 is a reply to message #44438] Wed, 07 May 2008 15:30 Go to previous messageGo to next message
Henrik  önsson is currently offline Henrik önsson
Messages: 53
Registered: July 2009
Member
Hi,

Thanks for the info.

Do you have any plans when to start working on this functionality? I need
to create a report for a client that must be completed in about a month
from now. I don't know if I should wait for you to implement this or I
should investigate doing a scripted data source.

Can I do something to help you implement this?

Regards

Henrik
Re: [Ecore ODA Driver] - Joint data set? [message #44496 is a reply to message #44471] Wed, 07 May 2008 18:24 Go to previous messageGo to next message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
Hi Henrik,
Thank you for the offer and for your interest in this plug-in. This
item is at the top of our backlog, so we should be implementing it
within the time period that you have indicated. We will let you know
as soon as we have made progress on it.
Feature suggestions, bug reports and exercising of the plug-ins are a
great help!
------Tim------

Henrik wrote:
> Hi,
>
> Thanks for the info.
> Do you have any plans when to start working on this functionality? I
> need to create a report for a client that must be completed in about a
> month from now. I don't know if I should wait for you to implement this
> or I should investigate doing a scripted data source.
>
> Can I do something to help you implement this?
>
> Regards
> Henrik
>
Re: [Ecore ODA Driver] - Joint data set? [message #44589 is a reply to message #44496] Tue, 13 May 2008 08:14 Go to previous messageGo to next message
Henrik  önsson is currently offline Henrik önsson
Messages: 53
Registered: July 2009
Member
Tim Myer wrote:

> Thank you for the offer and for your interest in this plug-in. This
> item is at the top of our backlog, so we should be implementing it
> within the time period that you have indicated. We will let you know
> as soon as we have made progress on it.
> Feature suggestions, bug reports and exercising of the plug-ins are a
> great help!

Great!
I'll be happy to test your code. How much work do you think it is to
implement this functionality?

Regards
Henrik
Re: [Ecore ODA Driver] - Joint data set? [message #44620 is a reply to message #44589] Tue, 13 May 2008 16:46 Go to previous messageGo to next message
Jeff Ramsdale is currently offline Jeff Ramsdale
Messages: 122
Registered: July 2009
Senior Member
Hey Henrik,

We think we've worked out how this needs to be implemented and we'll be
looking at it this week. No promises on delivery, but we had some other
work in process that has now been checked in (e.g. easier selection of
model as data source), freeing us up to look at it.

-jeff

Henrik wrote:
> Tim Myer wrote:
>
>> Thank you for the offer and for your interest in this plug-in. This
>> item is at the top of our backlog, so we should be implementing it
>> within the time period that you have indicated. We will let you know
>> as soon as we have made progress on it.
>> Feature suggestions, bug reports and exercising of the plug-ins are a
>> great help!
>
> Great! I'll be happy to test your code. How much work do you think it is
> to implement this functionality?
>
> Regards
> Henrik
>
Re: [Ecore ODA Driver] - Joint data set? [message #44681 is a reply to message #44620] Thu, 22 May 2008 05:11 Go to previous messageGo to next message
Henrik  önsson is currently offline Henrik önsson
Messages: 53
Registered: July 2009
Member
Hi,

Any news about this?

Regards

Henrik
Re: [Ecore ODA Driver] - Joint data set? [message #44837 is a reply to message #44681] Wed, 28 May 2008 12:36 Go to previous messageGo to next message
Jeff Ramsdale is currently offline Jeff Ramsdale
Messages: 122
Registered: July 2009
Senior Member
Hey Henrik,

We've worked on it some but don't have anything to check in yet. Will
keep at it! Maybe check back in a week if you don't see anything in CVS?

-jeff

Henrik wrote:
> Hi,
>
> Any news about this?
>
> Regards
>
> Henrik
>
Re: [Ecore ODA Driver] - Joint data set? [message #44937 is a reply to message #44837] Wed, 04 June 2008 10:52 Go to previous messageGo to next message
Eclipse User
Originally posted by: d4_g0m3z.hotmail.com

Hi,

just reading this. I'm also new to this, but I'm trying to printing out
the EReference books from the Library example.

I do manage to print it out. But the output is not that pretty :
Charles Dickens
[org.eclipse.emf.examples.extlibrary.impl.BookImpl@5af153
(publicationDate: null) (copies: 0) (title: Nicholas Nickleby, pages: 100,
category: Biography),
org.eclipse.emf.examples.extlibrary.impl.BookImpl@99a74e (publicationDate:
null) (copies: 0) (title: The Pickwick Papers, pages: 100, category:
<unset>), org.eclipse.emf.examples.extlibrary.impl.BookImpl@1b72681
(publicationDate: null) (copies: 0) (title: David Copperfield, pages: 100,
category: Biography)]
04.06.2008 16:44

I read that you're trying to do a run through the tree of EReference.

It would be nice if you could do it, so we could do
self.books->collect(Title) to show only the books Title from the Writer.

Like this:
Charles Dickens - Nicholas Nickleby
- Pickwick Papers
- David Copperfield

Thanks,
Eduard.
Re: [Ecore ODA Driver] - Joint data set? [message #44965 is a reply to message #44937] Thu, 05 June 2008 11:32 Go to previous messageGo to next message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
Hi Eduard and Henrik,
A quick update on this. We have an initial stab at the implementation
written but are performing a review before checking it into CVS, so it
should show up in CVS very soon. If you are really itching to get your
hands on the feature, the Eclipse 3.2 backport of these plugins (in the
datatools incubator attic) has this feature in place. Just be aware
that the backport has no guarantee of support going forward....
Thanks for your patience.
-----Tim------

Eduard wrote:
> Hi,
>
> just reading this. I'm also new to this, but I'm trying to printing out
> the EReference books from the Library example.
>
> I do manage to print it out. But the output is not that pretty :
> Charles Dickens
> [org.eclipse.emf.examples.extlibrary.impl.BookImpl@5af153
> (publicationDate: null) (copies: 0) (title: Nicholas Nickleby, pages:
> 100, category: Biography),
> org.eclipse.emf.examples.extlibrary.impl.BookImpl@99a74e
> (publicationDate: null) (copies: 0) (title: The Pickwick Papers, pages:
> 100, category: <unset>),
> org.eclipse.emf.examples.extlibrary.impl.BookImpl@1b72681
> (publicationDate: null) (copies: 0) (title: David Copperfield, pages:
> 100, category: Biography)] 04.06.2008 16:44
> I read that you're trying to do a run through the tree of EReference.
> It would be nice if you could do it, so we could do
> self.books->collect(Title) to show only the books Title from the Writer.
>
> Like this:
> Charles Dickens - Nicholas Nickleby
> - Pickwick Papers
> - David Copperfield
>
> Thanks,
> Eduard.
>
Re: [Ecore ODA Driver] - Joint data set? [message #45153 is a reply to message #44681] Tue, 10 June 2008 18:58 Go to previous messageGo to next message
Jeff Ramsdale is currently offline Jeff Ramsdale
Messages: 122
Registered: July 2009
Senior Member
Hey Henrik,

Appreciate your patience...

New code for the Ecore ODA Driver has been posted that supports walking
the EReference tree. Take a look! Any feedback appreciated...

-jeff

Henrik wrote:
> Hi,
>
> Any news about this?
>
> Regards
>
> Henrik
>
Re: [Ecore ODA Driver] - Joint data set? [message #45181 is a reply to message #44937] Tue, 10 June 2008 19:14 Go to previous messageGo to next message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
Hi Eduard,
New code has been uploaded to CVS that allows users to walk the tree of
EReferences. We will be updating the Getting Started Guide soon to show
how to use this feature, but please feel free to experiment in the
meanwhile.
To get the result that you are looking for (below), your boolean ocl
query on the query wizard page would be "self.oclIsKindOf(Writer)", and
on the column selection wizard page, you would select Writer->name and
Writer->books->name in the tree.
Let us know what you think! We appreciate your patience.
-----Tim-----


Eduard wrote:
> Hi,
>
> just reading this. I'm also new to this, but I'm trying to printing out
> the EReference books from the Library example.
>
> I do manage to print it out. But the output is not that pretty :
> Charles Dickens
> [org.eclipse.emf.examples.extlibrary.impl.BookImpl@5af153
> (publicationDate: null) (copies: 0) (title: Nicholas Nickleby, pages:
> 100, category: Biography),
> org.eclipse.emf.examples.extlibrary.impl.BookImpl@99a74e
> (publicationDate: null) (copies: 0) (title: The Pickwick Papers, pages:
> 100, category: <unset>),
> org.eclipse.emf.examples.extlibrary.impl.BookImpl@1b72681
> (publicationDate: null) (copies: 0) (title: David Copperfield, pages:
> 100, category: Biography)] 04.06.2008 16:44
> I read that you're trying to do a run through the tree of EReference.
> It would be nice if you could do it, so we could do
> self.books->collect(Title) to show only the books Title from the Writer.
>
> Like this:
> Charles Dickens - Nicholas Nickleby
> - Pickwick Papers
> - David Copperfield
>
> Thanks,
> Eduard.
>
Re: [Ecore ODA Driver] - Joint data set? [message #45245 is a reply to message #45181] Wed, 11 June 2008 03:38 Go to previous messageGo to next message
Henrik  önsson is currently offline Henrik önsson
Messages: 53
Registered: July 2009
Member
Hi,

Good work! I really appreciate what you are doing.

This might be more of a BIRT question, but I'll give it a try here.
I have a EClass called Track that contains EReferences to
SpeedProfiles(0..n aggregate). Now I would like to create a master detail
report of this.
E.g.
Track1
SpeedProfile1
SpeedProfile2
SpeedProfile3
Track2
SpeedProfile4
SpeedProfile5
SpeedProfile6

This is quite simple when you are dealing with database tables with
primary keys as links between the datasets. But how does this works with
EReferences?
Can you give me a hint on this?

Regards

Henrik
Re: [Ecore ODA Driver] - Joint data set? [message #45276 is a reply to message #45181] Wed, 11 June 2008 09:13 Go to previous messageGo to next message
Eclipse User
Originally posted by: d4_g0m3z.hotmail.com

Hi Tim,

just tried it once:) Working great! Thanks! Will keep using it:)

Eduard.
Re: [Ecore ODA Driver] - Joint data set? [message #45312 is a reply to message #45245] Wed, 11 June 2008 12:40 Go to previous messageGo to next message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
This is a multi-part message in MIME format.
--------------020602020703030306040404
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit


Hi Henrik,
Very interesting question. I'll propose one solution using nested
tables in the BIRT report layout and hope this fulfills your requirements.
Since I do not have the code for your data model, I will use the EMF
library example. I believe this should translate:
Suppose I want to report on all the Writers (the EClass) and their Books
(the EReference) in a model.
Each Writer's name should appear in the Master part of the report.
Each of the Writer's Books should appear as a Detail and should display
the Title, Number of Pages and the Category (EAttributes) for the Book.
So, the Master-Details report for the EXTLibrary File from the Getting
Started Guide should look something like this:
James Fenimore Cooper
The Deerslayer 100 Mystery
Jules Verne
Around the World in 80 Days 100 Mystery
Charles Dickens
Great Expectations 100 Mystery

From the Query Wizard Page, select Writer as the Invariant.
As your Boolean Query, use "oclIsKindOf(Writer)".
From the Columns Wizard Page, select
Writer -> name
Writer -> books -> title
Writer -> books -> pages
Writer -> books -> category

Now in your BIRT report, insert a new table with 1 columns and 2
details. The first details row will be the Master part, the second will
be the Details part.
In column 1 of the first detail row, drag Writer::name from the Data Set.
In the second detail row, insert a new table with 2 columns and 1
detail. The first column is for spacing, the second will contain the
EAttribute values (for the Details part).
In the detail row of the second column of the nested table, insert
another table with 3 columns and 1 detail row.
Finally, into these 3 columns, drag Writer::books::title,
Writer::books::pages and Writer::books::category from the Data Set.
You might also want to remove the header information and re-space the
columns to get the layout of the information that you want.
I have attached screenshots of the BIRT report layout with the 3 nested
tables and the Preview of the BIRT report.

For this solution, getting the results we are looking for is just a
matter of playing with BIRT table layouts. I would be interested in
hearing about any other / simpler solutions you might find to the problem.

Let me know if this solution meets your requirements. And please keep
up the feedback and the questions -- it is all good fodder for the
Getting Started Guide and the eventual Help documentation.
Thanks again.
-----Tim-----



Henrik J
Re: [Ecore ODA Driver] - Joint data set? [message #45336 is a reply to message #45312] Thu, 12 June 2008 12:10 Go to previous messageGo to next message
Eclipse User
Originally posted by: d4_g0m3z.hotmail.com

Hi,

i'm also thinking of doing this. But the problem is i want to do it in a
list.

And after some trying i couldn't find the solutions for this, maybe you
could give me some inputs on how can i have a report like this?

-----------------------------------
Charles Dickens
Books:
1) Bleak House
info : 100 pages, genre mystery
2) Oliver Twist
info : 100 pages, genre mystery
3) A Christmas Carol
info : 100 pages, genre mystery

...and so on
-----------------------------------

The first problem is i can't do a numbering/alphabeting on the items(ex.
I.Charles Dickens II.Jules Verne or A.Charles Dickens B.Jules Verne).

Secondly i want to do it so that the book's info come directly after every
book's name. Until now i only manage to make it, so that books come first
and than the infos.....

Appreciate your help, i'll also post this on the newsgroup from BIRT.

Thanks,
Eduard.
Re: [Ecore ODA Driver] - Joint data set? [message #45570 is a reply to message #45336] Wed, 18 June 2008 10:25 Go to previous messageGo to next message
Eclipse User
Originally posted by: d4_g0m3z.hotmail.com

Hi all,

is there any way to sort the data set(in the list element), i get? For
instance in the library example, i'm querying the Writer, everytime i
click on the preview, the 1st person i get is always different.

And the 2nd question do you guys manage to find out how to do an output
like this:

-----------------------------------
Charles Dickens
Books:
1) Bleak House
info : 100 pages, genre mystery
2) Oliver Twist
info : 100 pages, genre mystery
3) A Christmas Carol
info : 100 pages, genre mystery

..and so on
-----------------------------------

I started to think that this is not possible....... I tried using a table
inside the list, but it's not working that great... And if for example i
have more text beside the "info", it will make the output worse....

I posted this question also on BIRT newsgroup, and still not getting the
answer i want.

Thanks anyway!:)

Eduard.


Eduard wrote:

> Hi,

> i'm also thinking of doing this. But the problem is i want to do it in a
> list.

> And after some trying i couldn't find the solutions for this, maybe you
> could give me some inputs on how can i have a report like this?

> -----------------------------------
> Charles Dickens
> Books:
> 1) Bleak House
> info : 100 pages, genre mystery
> 2) Oliver Twist
> info : 100 pages, genre mystery
> 3) A Christmas Carol
> info : 100 pages, genre mystery

> ...and so on
> -----------------------------------

> The first problem is i can't do a numbering/alphabeting on the items(ex.
> I.Charles Dickens II.Jules Verne or A.Charles Dickens B.Jules Verne).

> Secondly i want to do it so that the book's info come directly after every
> book's name. Until now i only manage to make it, so that books come first
> and than the infos.....

> Appreciate your help, i'll also post this on the newsgroup from BIRT.

> Thanks,
> Eduard.
Re: [Ecore ODA Driver] - Joint data set? [message #45630 is a reply to message #45570] Wed, 18 June 2008 12:20 Go to previous message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
Hi Eduard,
Thanks for your patience with this, and I apologize for not getting back
sooner on it. I think your analysis might be correct, that it may not
be possible to get the results you want by doing a single query with the
current implementation. I was hoping it might be solvable through BIRT,
but that might not be an option either. I am not exactly familiar with
joining data sets, as Jeff had alluded to previously in the thread --
that might be the solution you are looking for.
-----Tim-----

Eduard wrote:
> Hi all,
>
> is there any way to sort the data set(in the list element), i get? For
> instance in the library example, i'm querying the Writer, everytime i
> click on the preview, the 1st person i get is always different.
>
> And the 2nd question do you guys manage to find out how to do an output
> like this:
>
> -----------------------------------
> Charles Dickens
> Books: 1) Bleak House
> info : 100 pages, genre mystery
> 2) Oliver Twist
> info : 100 pages, genre mystery
> 3) A Christmas Carol
> info : 100 pages, genre mystery
>
> .and so on
> -----------------------------------
>
> I started to think that this is not possible....... I tried using a
> table inside the list, but it's not working that great... And if for
> example i have more text beside the "info", it will make the output
> worse....
>
> I posted this question also on BIRT newsgroup, and still not getting the
> answer i want.
> Thanks anyway!:)
>
> Eduard.
>
>
> Eduard wrote:
>
>> Hi,
>
>> i'm also thinking of doing this. But the problem is i want to do it in
>> a list.
>
>> And after some trying i couldn't find the solutions for this, maybe
>> you could give me some inputs on how can i have a report like this?
>
>> -----------------------------------
>> Charles Dickens
>> Books: 1) Bleak House
>> info : 100 pages, genre mystery
>> 2) Oliver Twist
>> info : 100 pages, genre mystery
>> 3) A Christmas Carol
>> info : 100 pages, genre mystery
>
>> ...and so on
>> -----------------------------------
>
>> The first problem is i can't do a numbering/alphabeting on the
>> items(ex. I.Charles Dickens II.Jules Verne or A.Charles Dickens
>> B.Jules Verne).
>
>> Secondly i want to do it so that the book's info come directly after
>> every book's name. Until now i only manage to make it, so that books
>> come first and than the infos.....
>
>> Appreciate your help, i'll also post this on the newsgroup from BIRT.
>
>> Thanks,
>> Eduard.
>
>
Re: [Ecore ODA Driver] - Joint data set? [message #591131 is a reply to message #44406] Wed, 07 May 2008 12:46 Go to previous message
Jeff Ramsdale is currently offline Jeff Ramsdale
Messages: 122
Registered: July 2009
Senior Member
Great! Glad you're seeing some success...

The problem you're seeing is that the Ecore ODA Driver doesn't yet walk
the tree of references. We don't think it will be hard to implement, but
haven't gotten to it yet. Keep watching CVS and I'll try to post here
in the newsgroup when this feature is implemented.

Speaking of Joint Data Sets, you might be able to use one if you create
a Data Set for each dimension of your data--that is, create an Ecore
Data Set for Track and another for SpeedProfile and use a Joint Data Set
to join them. I haven't tried this, but I think that's the purpose of
the Joint Data Set. If you try it, let us know how it works...

-jeff

Henrik wrote:
> Hi,
>
> I managed to get Birt and the new Ecore ODA driver to work. Great work!
> Retrieving simple attributes from objects are dead easy.
>
> I have a EClass called Track that has a EReference to a SpeedProfile
> EClass. The relationship between Track and SpeedProfile is 0 to many. I
> would like to create a report that displays a table with alll my Tracks
> and their associated SpeedProfiles. Is this possible? If so how?
>
> I'm new to Birt and OCL but it's akind of joint data set I suppose.
> Regards
> Henrik
>
>
>
Re: [Ecore ODA Driver] - Joint data set? [message #591142 is a reply to message #44438] Wed, 07 May 2008 15:30 Go to previous message
Henrik  önsson is currently offline Henrik önsson
Messages: 53
Registered: July 2009
Member
Hi,

Thanks for the info.

Do you have any plans when to start working on this functionality? I need
to create a report for a client that must be completed in about a month
from now. I don't know if I should wait for you to implement this or I
should investigate doing a scripted data source.

Can I do something to help you implement this?

Regards

Henrik
Re: [Ecore ODA Driver] - Joint data set? [message #591148 is a reply to message #44471] Wed, 07 May 2008 18:24 Go to previous message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
Hi Henrik,
Thank you for the offer and for your interest in this plug-in. This
item is at the top of our backlog, so we should be implementing it
within the time period that you have indicated. We will let you know
as soon as we have made progress on it.
Feature suggestions, bug reports and exercising of the plug-ins are a
great help!
------Tim------

Henrik wrote:
> Hi,
>
> Thanks for the info.
> Do you have any plans when to start working on this functionality? I
> need to create a report for a client that must be completed in about a
> month from now. I don't know if I should wait for you to implement this
> or I should investigate doing a scripted data source.
>
> Can I do something to help you implement this?
>
> Regards
> Henrik
>
Re: [Ecore ODA Driver] - Joint data set? [message #591175 is a reply to message #44496] Tue, 13 May 2008 08:14 Go to previous message
Henrik  önsson is currently offline Henrik önsson
Messages: 53
Registered: July 2009
Member
Tim Myer wrote:

> Thank you for the offer and for your interest in this plug-in. This
> item is at the top of our backlog, so we should be implementing it
> within the time period that you have indicated. We will let you know
> as soon as we have made progress on it.
> Feature suggestions, bug reports and exercising of the plug-ins are a
> great help!

Great!
I'll be happy to test your code. How much work do you think it is to
implement this functionality?

Regards
Henrik
Re: [Ecore ODA Driver] - Joint data set? [message #591185 is a reply to message #44589] Tue, 13 May 2008 16:46 Go to previous message
Jeff Ramsdale is currently offline Jeff Ramsdale
Messages: 122
Registered: July 2009
Senior Member
Hey Henrik,

We think we've worked out how this needs to be implemented and we'll be
looking at it this week. No promises on delivery, but we had some other
work in process that has now been checked in (e.g. easier selection of
model as data source), freeing us up to look at it.

-jeff

Henrik wrote:
> Tim Myer wrote:
>
>> Thank you for the offer and for your interest in this plug-in. This
>> item is at the top of our backlog, so we should be implementing it
>> within the time period that you have indicated. We will let you know
>> as soon as we have made progress on it.
>> Feature suggestions, bug reports and exercising of the plug-ins are a
>> great help!
>
> Great! I'll be happy to test your code. How much work do you think it is
> to implement this functionality?
>
> Regards
> Henrik
>
Re: [Ecore ODA Driver] - Joint data set? [message #591206 is a reply to message #44620] Thu, 22 May 2008 05:11 Go to previous message
Henrik  önsson is currently offline Henrik önsson
Messages: 53
Registered: July 2009
Member
Hi,

Any news about this?

Regards

Henrik
Re: [Ecore ODA Driver] - Joint data set? [message #591245 is a reply to message #44681] Wed, 28 May 2008 12:36 Go to previous message
Jeff Ramsdale is currently offline Jeff Ramsdale
Messages: 122
Registered: July 2009
Senior Member
Hey Henrik,

We've worked on it some but don't have anything to check in yet. Will
keep at it! Maybe check back in a week if you don't see anything in CVS?

-jeff

Henrik wrote:
> Hi,
>
> Any news about this?
>
> Regards
>
> Henrik
>
Re: [Ecore ODA Driver] - Joint data set? [message #591276 is a reply to message #44837] Wed, 04 June 2008 10:52 Go to previous message
Eduard  is currently offline Eduard
Messages: 29
Registered: September 2009
Junior Member
Hi,

just reading this. I'm also new to this, but I'm trying to printing out
the EReference books from the Library example.

I do manage to print it out. But the output is not that pretty :
Charles Dickens
[org.eclipse.emf.examples.extlibrary.impl.BookImpl@5af153
(publicationDate: null) (copies: 0) (title: Nicholas Nickleby, pages: 100,
category: Biography),
org.eclipse.emf.examples.extlibrary.impl.BookImpl@99a74e (publicationDate:
null) (copies: 0) (title: The Pickwick Papers, pages: 100, category:
<unset>), org.eclipse.emf.examples.extlibrary.impl.BookImpl@1b72681
(publicationDate: null) (copies: 0) (title: David Copperfield, pages: 100,
category: Biography)]
04.06.2008 16:44

I read that you're trying to do a run through the tree of EReference.

It would be nice if you could do it, so we could do
self.books->collect(Title) to show only the books Title from the Writer.

Like this:
Charles Dickens - Nicholas Nickleby
- Pickwick Papers
- David Copperfield

Thanks,
Eduard.
Re: [Ecore ODA Driver] - Joint data set? [message #591286 is a reply to message #44937] Thu, 05 June 2008 11:32 Go to previous message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
Hi Eduard and Henrik,
A quick update on this. We have an initial stab at the implementation
written but are performing a review before checking it into CVS, so it
should show up in CVS very soon. If you are really itching to get your
hands on the feature, the Eclipse 3.2 backport of these plugins (in the
datatools incubator attic) has this feature in place. Just be aware
that the backport has no guarantee of support going forward....
Thanks for your patience.
-----Tim------

Eduard wrote:
> Hi,
>
> just reading this. I'm also new to this, but I'm trying to printing out
> the EReference books from the Library example.
>
> I do manage to print it out. But the output is not that pretty :
> Charles Dickens
> [org.eclipse.emf.examples.extlibrary.impl.BookImpl@5af153
> (publicationDate: null) (copies: 0) (title: Nicholas Nickleby, pages:
> 100, category: Biography),
> org.eclipse.emf.examples.extlibrary.impl.BookImpl@99a74e
> (publicationDate: null) (copies: 0) (title: The Pickwick Papers, pages:
> 100, category: <unset>),
> org.eclipse.emf.examples.extlibrary.impl.BookImpl@1b72681
> (publicationDate: null) (copies: 0) (title: David Copperfield, pages:
> 100, category: Biography)] 04.06.2008 16:44
> I read that you're trying to do a run through the tree of EReference.
> It would be nice if you could do it, so we could do
> self.books->collect(Title) to show only the books Title from the Writer.
>
> Like this:
> Charles Dickens - Nicholas Nickleby
> - Pickwick Papers
> - David Copperfield
>
> Thanks,
> Eduard.
>
Re: [Ecore ODA Driver] - Joint data set? [message #591343 is a reply to message #44681] Tue, 10 June 2008 18:58 Go to previous message
Jeff Ramsdale is currently offline Jeff Ramsdale
Messages: 122
Registered: July 2009
Senior Member
Hey Henrik,

Appreciate your patience...

New code for the Ecore ODA Driver has been posted that supports walking
the EReference tree. Take a look! Any feedback appreciated...

-jeff

Henrik wrote:
> Hi,
>
> Any news about this?
>
> Regards
>
> Henrik
>
Re: [Ecore ODA Driver] - Joint data set? [message #591350 is a reply to message #44937] Tue, 10 June 2008 19:14 Go to previous message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
Hi Eduard,
New code has been uploaded to CVS that allows users to walk the tree of
EReferences. We will be updating the Getting Started Guide soon to show
how to use this feature, but please feel free to experiment in the
meanwhile.
To get the result that you are looking for (below), your boolean ocl
query on the query wizard page would be "self.oclIsKindOf(Writer)", and
on the column selection wizard page, you would select Writer->name and
Writer->books->name in the tree.
Let us know what you think! We appreciate your patience.
-----Tim-----


Eduard wrote:
> Hi,
>
> just reading this. I'm also new to this, but I'm trying to printing out
> the EReference books from the Library example.
>
> I do manage to print it out. But the output is not that pretty :
> Charles Dickens
> [org.eclipse.emf.examples.extlibrary.impl.BookImpl@5af153
> (publicationDate: null) (copies: 0) (title: Nicholas Nickleby, pages:
> 100, category: Biography),
> org.eclipse.emf.examples.extlibrary.impl.BookImpl@99a74e
> (publicationDate: null) (copies: 0) (title: The Pickwick Papers, pages:
> 100, category: <unset>),
> org.eclipse.emf.examples.extlibrary.impl.BookImpl@1b72681
> (publicationDate: null) (copies: 0) (title: David Copperfield, pages:
> 100, category: Biography)] 04.06.2008 16:44
> I read that you're trying to do a run through the tree of EReference.
> It would be nice if you could do it, so we could do
> self.books->collect(Title) to show only the books Title from the Writer.
>
> Like this:
> Charles Dickens - Nicholas Nickleby
> - Pickwick Papers
> - David Copperfield
>
> Thanks,
> Eduard.
>
Re: [Ecore ODA Driver] - Joint data set? [message #591378 is a reply to message #45181] Wed, 11 June 2008 03:38 Go to previous message
Henrik  önsson is currently offline Henrik önsson
Messages: 53
Registered: July 2009
Member
Hi,

Good work! I really appreciate what you are doing.

This might be more of a BIRT question, but I'll give it a try here.
I have a EClass called Track that contains EReferences to
SpeedProfiles(0..n aggregate). Now I would like to create a master detail
report of this.
E.g.
Track1
SpeedProfile1
SpeedProfile2
SpeedProfile3
Track2
SpeedProfile4
SpeedProfile5
SpeedProfile6

This is quite simple when you are dealing with database tables with
primary keys as links between the datasets. But how does this works with
EReferences?
Can you give me a hint on this?

Regards

Henrik
Re: [Ecore ODA Driver] - Joint data set? [message #591389 is a reply to message #45181] Wed, 11 June 2008 09:13 Go to previous message
Eduard  is currently offline Eduard
Messages: 29
Registered: September 2009
Junior Member
Hi Tim,

just tried it once:) Working great! Thanks! Will keep using it:)

Eduard.
Re: [Ecore ODA Driver] - Joint data set? [message #591399 is a reply to message #45245] Wed, 11 June 2008 12:40 Go to previous message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
This is a multi-part message in MIME format.
--------------020602020703030306040404
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit


Hi Henrik,
Very interesting question. I'll propose one solution using nested
tables in the BIRT report layout and hope this fulfills your requirements.
Since I do not have the code for your data model, I will use the EMF
library example. I believe this should translate:
Suppose I want to report on all the Writers (the EClass) and their Books
(the EReference) in a model.
Each Writer's name should appear in the Master part of the report.
Each of the Writer's Books should appear as a Detail and should display
the Title, Number of Pages and the Category (EAttributes) for the Book.
So, the Master-Details report for the EXTLibrary File from the Getting
Started Guide should look something like this:
James Fenimore Cooper
The Deerslayer 100 Mystery
Jules Verne
Around the World in 80 Days 100 Mystery
Charles Dickens
Great Expectations 100 Mystery

From the Query Wizard Page, select Writer as the Invariant.
As your Boolean Query, use "oclIsKindOf(Writer)".
From the Columns Wizard Page, select
Writer -> name
Writer -> books -> title
Writer -> books -> pages
Writer -> books -> category

Now in your BIRT report, insert a new table with 1 columns and 2
details. The first details row will be the Master part, the second will
be the Details part.
In column 1 of the first detail row, drag Writer::name from the Data Set.
In the second detail row, insert a new table with 2 columns and 1
detail. The first column is for spacing, the second will contain the
EAttribute values (for the Details part).
In the detail row of the second column of the nested table, insert
another table with 3 columns and 1 detail row.
Finally, into these 3 columns, drag Writer::books::title,
Writer::books::pages and Writer::books::category from the Data Set.
You might also want to remove the header information and re-space the
columns to get the layout of the information that you want.
I have attached screenshots of the BIRT report layout with the 3 nested
tables and the Preview of the BIRT report.

For this solution, getting the results we are looking for is just a
matter of playing with BIRT table layouts. I would be interested in
hearing about any other / simpler solutions you might find to the problem.

Let me know if this solution meets your requirements. And please keep
up the feedback and the questions -- it is all good fodder for the
Getting Started Guide and the eventual Help documentation.
Thanks again.
-----Tim-----



Henrik J
Re: [Ecore ODA Driver] - Joint data set? [message #591411 is a reply to message #45312] Thu, 12 June 2008 12:10 Go to previous message
Eduard  is currently offline Eduard
Messages: 29
Registered: September 2009
Junior Member
Hi,

i'm also thinking of doing this. But the problem is i want to do it in a
list.

And after some trying i couldn't find the solutions for this, maybe you
could give me some inputs on how can i have a report like this?

-----------------------------------
Charles Dickens
Books:
1) Bleak House
info : 100 pages, genre mystery
2) Oliver Twist
info : 100 pages, genre mystery
3) A Christmas Carol
info : 100 pages, genre mystery

...and so on
-----------------------------------

The first problem is i can't do a numbering/alphabeting on the items(ex.
I.Charles Dickens II.Jules Verne or A.Charles Dickens B.Jules Verne).

Secondly i want to do it so that the book's info come directly after every
book's name. Until now i only manage to make it, so that books come first
and than the infos.....

Appreciate your help, i'll also post this on the newsgroup from BIRT.

Thanks,
Eduard.
Re: [Ecore ODA Driver] - Joint data set? [message #591506 is a reply to message #45336] Wed, 18 June 2008 10:25 Go to previous message
Eduard  is currently offline Eduard
Messages: 29
Registered: September 2009
Junior Member
Hi all,

is there any way to sort the data set(in the list element), i get? For
instance in the library example, i'm querying the Writer, everytime i
click on the preview, the 1st person i get is always different.

And the 2nd question do you guys manage to find out how to do an output
like this:

-----------------------------------
Charles Dickens
Books:
1) Bleak House
info : 100 pages, genre mystery
2) Oliver Twist
info : 100 pages, genre mystery
3) A Christmas Carol
info : 100 pages, genre mystery

..and so on
-----------------------------------

I started to think that this is not possible....... I tried using a table
inside the list, but it's not working that great... And if for example i
have more text beside the "info", it will make the output worse....

I posted this question also on BIRT newsgroup, and still not getting the
answer i want.

Thanks anyway!:)

Eduard.


Eduard wrote:

> Hi,

> i'm also thinking of doing this. But the problem is i want to do it in a
> list.

> And after some trying i couldn't find the solutions for this, maybe you
> could give me some inputs on how can i have a report like this?

> -----------------------------------
> Charles Dickens
> Books:
> 1) Bleak House
> info : 100 pages, genre mystery
> 2) Oliver Twist
> info : 100 pages, genre mystery
> 3) A Christmas Carol
> info : 100 pages, genre mystery

> ...and so on
> -----------------------------------

> The first problem is i can't do a numbering/alphabeting on the items(ex.
> I.Charles Dickens II.Jules Verne or A.Charles Dickens B.Jules Verne).

> Secondly i want to do it so that the book's info come directly after every
> book's name. Until now i only manage to make it, so that books come first
> and than the infos.....

> Appreciate your help, i'll also post this on the newsgroup from BIRT.

> Thanks,
> Eduard.
Re: [Ecore ODA Driver] - Joint data set? [message #591525 is a reply to message #45570] Wed, 18 June 2008 12:20 Go to previous message
Tim Myer is currently offline Tim Myer
Messages: 81
Registered: July 2009
Member
Hi Eduard,
Thanks for your patience with this, and I apologize for not getting back
sooner on it. I think your analysis might be correct, that it may not
be possible to get the results you want by doing a single query with the
current implementation. I was hoping it might be solvable through BIRT,
but that might not be an option either. I am not exactly familiar with
joining data sets, as Jeff had alluded to previously in the thread --
that might be the solution you are looking for.
-----Tim-----

Eduard wrote:
> Hi all,
>
> is there any way to sort the data set(in the list element), i get? For
> instance in the library example, i'm querying the Writer, everytime i
> click on the preview, the 1st person i get is always different.
>
> And the 2nd question do you guys manage to find out how to do an output
> like this:
>
> -----------------------------------
> Charles Dickens
> Books: 1) Bleak House
> info : 100 pages, genre mystery
> 2) Oliver Twist
> info : 100 pages, genre mystery
> 3) A Christmas Carol
> info : 100 pages, genre mystery
>
> .and so on
> -----------------------------------
>
> I started to think that this is not possible....... I tried using a
> table inside the list, but it's not working that great... And if for
> example i have more text beside the "info", it will make the output
> worse....
>
> I posted this question also on BIRT newsgroup, and still not getting the
> answer i want.
> Thanks anyway!:)
>
> Eduard.
>
>
> Eduard wrote:
>
>> Hi,
>
>> i'm also thinking of doing this. But the problem is i want to do it in
>> a list.
>
>> And after some trying i couldn't find the solutions for this, maybe
>> you could give me some inputs on how can i have a report like this?
>
>> -----------------------------------
>> Charles Dickens
>> Books: 1) Bleak House
>> info : 100 pages, genre mystery
>> 2) Oliver Twist
>> info : 100 pages, genre mystery
>> 3) A Christmas Carol
>> info : 100 pages, genre mystery
>
>> ...and so on
>> -----------------------------------
>
>> The first problem is i can't do a numbering/alphabeting on the
>> items(ex. I.Charles Dickens II.Jules Verne or A.Charles Dickens
>> B.Jules Verne).
>
>> Secondly i want to do it so that the book's info come directly after
>> every book's name. Until now i only manage to make it, so that books
>> come first and than the infos.....
>
>> Appreciate your help, i'll also post this on the newsgroup from BIRT.
>
>> Thanks,
>> Eduard.
>
>
Previous Topic:SQL Editor multiple select statements
Next Topic:Remove the ODA DataSource properties dialog from the wizard
Goto Forum:
  


Current Time: Thu Jul 24 16:10:50 EDT 2014

Powered by FUDForum. Page generated in 0.03781 seconds