BIRT Dataset parameters set "Datetime" A few days later or ago
Accepted answer
Hi Josako-san.
What kind of dataset ,snapshot and table do you use?
and why don't you want to use filter?
I think there are normally FROM_TIME or TO_TIME as Default Parametar when using simple dataset to select specific time range.
If you use advanced dataset , you can use filter in Fact Information in the dialogue.
(Example) TIMESTAMP > param_1
What kind of dataset ,snapshot and table do you use?
and why don't you want to use filter?
I think there are normally FROM_TIME or TO_TIME as Default Parametar when using simple dataset to select specific time range.
If you use advanced dataset , you can use filter in Fact Information in the dialogue.
(Example) TIMESTAMP > param_1
Comments
Hi Hara-san
Thank you
Well,,Extended Dataset, I had also thought so.
The method whether not the best.
However, the fact that re-create the Dataset is, the influence of the much the same as re-create all
Yes you.
It is best that can be implemented in Simple Dataset.
It's not about the dataset type, rather the table itself. Other users got confused too.
https://jazz.net/forum/questions/106933/birt-why-are-from_time-and-to_time-parameters-missing-in-workitem_chngs
As far as I know, only few tables have the FROM_TIME and TO_TIME parameters. A working sample is shown in the below article.
http://www.ibm.com/developerworks/rational/library/10/creatingcustomreportswithbirtandrtc-part3/
Hi Donald
I'm sorry. Gone misleading
In the introduction
"From_Time" and "To_Time" is a DW summary table shows the Collected date.
"Due Date (Latest)" Ya can not be used on the parameters of the "Custom attribute (type of Datetime)".
I'm sorry. Gone misleading
In the introduction
"From_Time" and "To_Time" is a DW summary table shows the Collected date.
"Due Date (Latest)" Ya can not be used on the parameters of the "Custom attribute (type of Datetime)".
Comments
Donald Nong
Mar 29 '16, 11:06 p.m.I don't quite understand your request. You are trying to use a date range as a filter, but you refuse to use "Filters"? As far as I know, "Parameters" always use the "equal" operator.
HIROAKI JOSAKO
Apr 01 '16, 2:20 a.m.When you set the Filter when the Dataset you set the Parameters in the DataSet has a different number of records retrieved.
ex1. The Parameter is to refine when it select from DB.
ex2. The Filter is to hide from the result ,select from DB.
The results on the look is the same, but the amount of memory and the display speed to consume is quite different.
Donald Nong
Apr 01 '16, 4:24 a.m.The BIRT reports that you can build in RTC have some limitations. Sometimes you just have to use filters.