BIRT How to set the EnumerationList at Dataset Parameters
For example if it is registered as follows,
How setting can I and you want to create a Dataset of the case, including some?
What to do Parameters on how to set up?
We do not understand.
Example:
Dataset
WI_ID MEDIUM_STRING_VALUE
11111 |enum1|enum2|enum3|
11112 |enum1|enum3|enum4|
11113 |enum2|enum3|enum5|
Set
Parameter
enum1,enum2
RESULT:
WI_ID MEDIUM_STRING_VALUE
11111 |enum1|enum2|enum3|
Please.
How setting can I and you want to create a Dataset of the case, including some?
What to do Parameters on how to set up?
We do not understand.
Example:
Dataset
WI_ID MEDIUM_STRING_VALUE
11111 |enum1|enum2|enum3|
11112 |enum1|enum3|enum4|
11113 |enum2|enum3|enum5|
Set
Parameter
enum1,enum2
RESULT:
WI_ID MEDIUM_STRING_VALUE
11111 |enum1|enum2|enum3|
Please.
Accepted answer
Hi Josako-san,
I am trying to figure out how to do what you want to do, but I haven't found it. Would it be possible for you to separate enum list into multiple rows and query it? If so, the post below would be helpful.
https://jazz.net/forum/questions/115288/how-to-create-a-birt-report-with-enumeration-list
2 other answers
Hi Josako-san
As Donald-san mentioned, I also think using advanced data set and filters is needed.
In addition, I think JavaScript is also needed to build parameter string.
For implementing JavaScript , please see this page
Integrating BIRT
In below pages, some reports design files have JavaScript Implementation.
please refer it.
Reports Central
https://jazz.net/wiki/bin/view/Main/ReportsCentral
As Donald-san mentioned, I also think using advanced data set and filters is needed.
In addition, I think JavaScript is also needed to build parameter string.
For implementing JavaScript , please see this page
Integrating BIRT
http://www.eclipse.org/birt/documentation/integrating/scripting.php
In below pages, some reports design files have JavaScript Implementation.
please refer it.
Reports Central
https://jazz.net/wiki/bin/view/Main/ReportsCentral
Comments
Donald Nong
Apr 06 '16, 12:16 a.m.You can easily do this with filters, but I know that you're strongly against using filters. Do you "have to" use parameters?
HIROAKI JOSAKO
Apr 06 '16, 8:24 p.m.Hi Donald
as much as possible, to use parameters
Workitem Type, you are using the choices often Enumeration is often the more the number of WI.
Example： Release Version of model+grade
firstmodel_base_0102
firstmodel_deluxedition_0204
firstmodel_miniedition_0204
secondemodel_base_1204
pre_release_base_2016_01
.
.
.
Donald Nong
Apr 11 '16, 2:52 a.m.By "use parameters", I assume that you expect that BIRT can construct an SQL with the given condition so that the query only returns the result you want? To be honest, I cannot construct such SQL in a simple way with the "LIKE" operator. I think you need to use filters.
HIROAKI JOSAKO
May 10 '16, 1:22 a.m.Hi Donald
Idea of Osawa-san might solve.
To prepare a dummy text that created the function to extract only the data necessary for the data set once array variable(Java map.object) .
I think that I can by re-setting the object to the Script Dataset.
Have you ever made in this way until now.
Standard report "cumlative report" has been created in this way.
But, it is very difficult, low scalability.
We decided to develop only when it becomes really necessary.
Donald Nong
May 10 '16, 2:12 a.m.Are you referring to my answer in the post that Ohsawa san linked? If so, I only went as far as what I wrote in the post. I did not develop any actual reports - I only found a way to solve a problem when I saw it.