Eclipse Community Forums: BIRT » Runtime parameter issue

Home » Archived » BIRT » Runtime parameter issue(Runtime parameter issue)

Runtime parameter issue [message #885929]

Wed, 13 June 2012 18:08

Eclipse User

Hi - I have the following query in my dataset.

=====================================================================================
select ASSETID,ASSETURN,ASSETNAME,"ASSET-SOURCE-NAME" from erruser.RPT_CLASSIFIERS_36
WHERE "ASSET-SOURCE-NAME"='COMMON_LIB'
=====================================================================================
And I am using the below scirpt in beforeopen for the same dataset, to pass runtime Library_Id value.
=====================================================================================
//Here I am passing the table name in runtime
var id = new String(params["libraryID"]);
var name = new String(params["ASSET_SOURCE_NAME"]);
var num = id.substr(id.indexOf(':',0)+1,id.length);
query = new String(this.queryText);
query = query.replace(/(RPT_[a-zA-Z_]+)(\d+)/g,"$1"+num);
this.queryText = query;
=====================================================================================

The above script is working fine as it is. But is I try to pass the 'ASSET-SOURCE-NAME' in run time I am facing issue. I tried with the following script ...

=====================================================================================================
//Here I am passing the table name in runtime
var id = new String(params["libraryID"]);
var name = new String(params["ASSET_SOURCE_NAME"]);
var num = id.substr(id.indexOf(':',0)+1,id.length);
query = new String(this.queryText);
query = query.replace((/(RPT_[a-zA-Z_]+)(\d+)/g,"$1"+num),(/'COMMON_LIB'/,'name');
this.queryText = query;
=====================================================================================================

Please help me with your suggestions and inputs.

Thanks,
AR

[Updated on: Wed, 13 June 2012 19:53] by Moderator

Re: Runtime parameter issue [message #885961 is a reply to message #885929]

Wed, 13 June 2012 19:54

Eclipse User

Attached the report design that I am working.

Thanks
AR

Attachment: AssetSourcdeName.rptdesign
(Size: 11.63KB, Downloaded 585 times)

Re: Runtime parameter issue [message #886144 is a reply to message #885961]

Thu, 14 June 2012 06:26

Eclipse User

Hey,

my first Question: What would you like to do with this scripts? Do you need them really, or is there another possibility to achieve the result you wanna have?

Which issues do you get?

Re: Runtime parameter issue [message #886331 is a reply to message #885929]

Thu, 14 June 2012 14:40

Eclipse User

Can you use

var newwhere = "LIBRARY_ID='"+params["libraryID".value]+"'";
this.queryText = this.queryText.replace("LIBRARY_ID='422:36'", newwhere );

Jason

On 6/13/2012 6:08 PM, A R wrote:
> Hi Jason and All - I have the following query in my dataset.
> ============================================================
> SELECT UPPER ("ASSET_SOURCE_NAME") as "ASSET_SOURCE_NAME" FROM
> ERRUSER.RPT_ASSET_SOURCE where LIBRARY_ID='422:36'
> ===========================================================
> And I am using the below scirpt in beforeopen for the same dataset, to
> pass runtime Library_Id value.
> ==============================================================
> var id = new String(params["libraryID"]);
> query = new String(this.queryText);
> query = query.replace(/LIBRARY_ID=+)(\d+)/g,"$1"+id);
> this.queryText = query;
> ==============================================================
>
> I am not able to achieve the required result. Please correct me if I am
> wrong. Attached the report design.
>
> Thanks,
> AR

Re: Runtime parameter issue [message #886337 is a reply to message #886144]

Thu, 14 June 2012 14:51

Eclipse User

Its not necessary with scripts, may be we can achieve through other way. But I need to develope a report design which can work with multiple versions of same tables. For which I need to pass the table name (libraryId in my case) at run time. Which I can achieve through script only, to my knowledge. And the secpond parameter which I am trying to include is depend on the LibraryId.

Does it answer your question. Please let me know if I am missing any info required.

Thanks
AR

Re: Runtime parameter issue [message #886339 is a reply to message #886331]

Thu, 14 June 2012 14:53

Eclipse User

Thanks Jason,

I will try and update you on the same .

-AR

Re: Runtime parameter issue [message #886905 is a reply to message #886331]

Fri, 15 June 2012 16:16

Eclipse User

Thanks a ton Jason.

It worked.

Have a great weekend Smile

Regards
AR

Previous Topic:	Call Javascript From Report Drill Down
Next Topic:	Some text in charts are not anti-aliased

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 04 13:50:07 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter