Parameter Mapping [message #533297] |
Thu, 13 May 2010 05:36 |
Jason Messages: 1 Registered: May 2010 |
Junior Member |
|
|
This is not a bug report but a improvement suggestion about the mapping of the parameters.I think the birt team can learn some thing from other teams.
In birt As we known,first we declare the parameters,and then we map the parameters to the ? in the sql statement.If there
are only several ? in the statement,we can handle it easily; but if there are more than 10 parameters used in a complex statement and each of them repeats more than 10 times and appears not regularly,then we have to map them carefully(mapping more than 100 times),which is not convenience at all.
In Reporting Service,if the datasource's db is oracle,we can use ":Parameter" ,if it is a ms-sqlserver we can use "@Parameter" ,in iBatis,the parameter in statement are marked with "#parameter#",what I want to say is that whether can we use the symbol like those in statement instead of ? and omited the mapping step.
May this suggestion being adopted and hoping birt being better and better.
|
|
|
Re: Parameter Mapping [message #533364 is a reply to message #533297] |
Thu, 13 May 2010 14:16 |
|
Can you open an enhancement request for this?
On 5/13/2010 1:36 AM, Jason wrote:
> This is not a bug report but a improvement suggestion about the mapping
> of the parameters.I think the birt team can learn some thing from other
> teams.
> In birt As we known,first we declare the parameters,and then we map the
> parameters to the ? in the sql statement.If there
> are only several ? in the statement,we can handle it easily; but if
> there are more than 10 parameters used in a complex statement and each
> of them repeats more than 10 times and appears not regularly,then we
> have to map them carefully(mapping more than 100 times),which is not
> convenience at all.
> In Reporting Service,if the datasource's db is oracle,we can use
> ":Parameter" ,if it is a ms-sqlserver we can use "@Parameter" ,in
> iBatis,the parameter in statement are marked with "#parameter#",what I
> want to say is that whether can we use the symbol like those in
> statement instead of ? and omited the mapping step.
> May this suggestion being adopted and hoping birt being better and better.
>
>
|
|
|
Powered by
FUDForum. Page generated in 0.02684 seconds