Home » Eclipse Projects » DTP » [Ecore ODA Driver] - Joint data set?
| | | | | | | |
| Re: [Ecore ODA Driver] - Joint data set? [message #44937 is a reply to message #44837] |
Wed, 04 June 2008 14:52   |
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 15:32 |
 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 #45181 is a reply to message #44937] |
Tue, 10 June 2008 23:14 |
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 #45312 is a reply to message #45245] |
Wed, 11 June 2008 16:40 |
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 16:10 |
| 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 14:25 |
| 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 16:20 |
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 #591276 is a reply to message #44837] |
Wed, 04 June 2008 14:52 |
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 15:32 |
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 #591350 is a reply to message #44937] |
Tue, 10 June 2008 23:14 |
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 #591399 is a reply to message #45245] |
Wed, 11 June 2008 16:40 |
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 #591506 is a reply to message #45336] |
Wed, 18 June 2008 14:25 |
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 16:20 |
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.
>
>
|
|
|
Goto Forum:
Current Time: Tue Apr 16 08:10:57 GMT 2024
Powered by FUDForum. Page generated in 0.14387 seconds |
] 
Search
Help
Register
Login
Home
