nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Global js function used by dataset parameter seems not working

Stefan734

Hi experts,
I've created some birt reports, but I'm far away from expert status. Hope anyone here can help me to solve this "basic task"...
 
I want to use a global js function or global js variable to set a dataset parameter. Therefore I've created an external js file and linked it with my report. Alternatively, I added this function in the initialize event of report and don't use the external file
<pre class="_prettyXprint">
// Example external js function
function myString( str )
{
return str + 'globaltest';
}
</pre>
When using myString ( 'test' ) as a default value expression for dataset parameter I got always following error message: "myString" is not defined.
 
I've checked it with an report parameter instead of the default expression but the behavior is similar.
In addition I added reportContext.setPersistentGlobalVariable( "myString", myString) and would like to get the information by reportContext.GetPersistentGlobalVariable( "myString") but report parameters and dataset parameters seems no reportContext or can't use global js functions/variables.
 
I've no more idea but I'm sure some basic is missing :unsure: I'm on birt 2.5.1
Thanks in advance

Find more posts tagged with

Comments

JFreeman

How are you wanting to use this global variable and dataset parameter?
Are you trying to modify the database query?
Use it to set a filter on the data set?

Matthew L.

The function works for me in 2.5.1, when adding it to the initialize method (See example).
I wonder if it could be the order of operations which are causing the error.
Could you post an example that replicates the issue?

Stefan734

It should be a parameter for queries and more, therefore a global Variable and the use of dataset parameters
<pre class="_prettyXprint _lang-sql">
select FIELD_1, FIELD_2 from VIEW_1
where LOGIN_ID = ?
</pre>

JFreeman

Take a look at the sample report upload by Matthew.
 
It successfully uses your function in initialize of the report design with a parameter in the data set.

Stefan734

Hi Matthew,
thanks for your example...
I added a report parameter and your example shows the same error message 'myString is not defined'
 
edit 
Attachment not attached

Matthew L.

Without an example its hard to tell exactly how you are setting up the report design that causes this issue.
However, if you are attempting to call a function from a reports initialize method in a Report Parameter's value then this will not work.
Per the order of operations, the parameter's run before the report's initialize method which is why you see the undefined error.
 
Depending on what you are wanting to do, you could use the value from your parameter as the input parameter to the function for your Data Set input parameter.
 
ex: myString(params["NewParameter"]);
 
Edit:
Per your newly attached example, I do not see where you are actually using parameter value however hopefully this attached example is helpful.

Stefan734

OK, let explain the use case but be aware that English is not my core competence

Szenario
First the report user should be able to choose one or more for him possible record classes (field based information in database).
After selection the report shows all detailed informations for the selected groups from other sql join dataset.
 
The first sql for the dynamic report parameter depence on userID from report user in the where clause.
The second sgl use the selected values from report parameter as IN clause.
 
Because userID is used more times I think a global variable instead of report paramter is a good idea. But "parameter's run before the report's initialize method" is the end for my idea

.

Matthew L.

I think the solution you are looking for is is similar to another issue <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/36152-filters-not-adequate-for-large-data-what-then/?p=133966'>http://developer.actuate.com/community/forum/index.php?/topic/36152-filters-not-adequate-for-large-data-what-then/?p=133966</a>
 
Attached is an example that passes multiple values selected from a parameter into the query.
I have 1 for an Integer type and one for String type depending on the values you are passing.

Stefan734

Passing multiple values to a sql isn't a problem for me.
 
First I need a dynamic report parameter with a subset of records based on current report user ID. I can get it in two ways (2. for testing in designer)
 
1. reportContext.getHttpServletRequest().getSession().getAttribute( "AppContextValue" ).get( "user" )
2. reportContext.getDesignHandle().findDataSource( "****" ).getProperty( "user" )
 
The challange seems that 'initialize event' fires after report parameter and for report parameters I've no access to this objects/information.

Matthew L.

Try the following in the parameter's Expression Builder:
<pre class="_prettyXprint _lang-js">
this['user.name'];
</pre>

Stefan734

Thanks for your well support. Unfortunately I had no system access today, I will try it tomorrow...

Stefan734

We use Birt in conjunction with our main application BMC Remedy. In this context this shows the system user and not the current birt user. I can't use it...
 
However, you solve my problem. I've to add the code in parameter expression and can't use global variables was the important hint.
 
Thanks again.