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; } } }

How to modify queryText if using a Data Object

grather

When creating a report
 
I want to make my report editable in Report Studio
And I want to be able to use Dynamic Filters.
 
I also want to modify the queryText in the beforeOpen of the Dataset
 
So If I don't use a Data Object in beforeOpen of the dataset
So to add some more sql
this.queryText = this.queryText + "AND something = 'one';
 
But the same does not work if using a Data Object.
 
How can I modify the the query before running.
 
I really want to do something depending on the user.
 
Gary

Find more posts tagged with

Comments

micajblock

Gary,
Can you please provide more detail on the user requirements?

grather

User Requirements.
At runtime i want to modify the queryText before the query is executed.
 
Depending on the the User there are some additional sql I want to add.
 
The problem that I am having is being able to modify the queryText when using a DataObject.
 
The actual change depending on the User is a separate issue.
Just the changing of the queryText when using a DataObject is not able to do

micajblock

<blockquote class="ipsBlockquote" data-author="grather" data-cid="129873" data-time="1407167797">
<div>
At runtime i want to modify the queryText before the query is executed.
</div>
</blockquote>
This is your technical solution to a user requirement. I would like to understand better the business use case so I can supply the best answer.

grather

Mica
 
The user requirement is the user must only see the data he is allowed to see.
In our application we call this the span of control.
A user is assigned a location in a hierarchy (Think directory structure)
 
This assignment is defined by a set of ATTRIBUTE1 - ATTRIBUTE10 ((again think directory) a user will be assigned at some level.
anywhere from the top level where everything is available (No ATTRIBUTES ASSIGNED)
 
for a leaf node where all 10 ATTRIBUTES are assigned.
 
When actually running the report we pass in these attributes where the user as selected what level he want. But it is at or below his assignment.
But the problem I was running into is when in Report Studio the preview did not include these dynamic Filters so the preview was
returning the first of the complete data it was not filtering by what the user could see.
 
Hope that helps understand what I was trying to do from a high point of abstraction.

The answer to my question "Thank You Clement Wong"
 
Was I was using a Birt Data Object and then in the rptdesign I was using the beforeOpen of the dataset as seen in the rptdesign.
I was incorrectly using the rptdesign - dataset beforeOpen.
 
The correct answer is do this in the dataseign file (DataObject)
Modify the queryText in the datadesign - datest beforeOpen
 
No when running the report this get fired I can do the needed mods depending on the User as needed.
And this solves my issue.

Mica I would also be interested in other ways of limiting my Preview in ReportStudio to my users alolowed data.
 
I am certainly looking for the Best Practices to show up now in my work.
 
Gary

micajblock

Have you considered using security on the data object?

grather

Mica
 
No I have not. Because I have no idea what security on the data object even means.
Much less how I would implement it.
 
Care to aim me to some documentation or provide a simple example what this would take.
 
The term is very much what I want. But how to do it ?
 
Gary

micajblock

Look at chapter 12 of this manual
 
<a data-ipb='nomediaparse' href='http://developer.actuate.com/be/documentation/Manualsihub3/application-developer-guide.pdf'>http://developer.actuate.com/be/documentation/Manualsihub3/application-developer-guide.pdf</a>

grather

Mica
 
I just spent a few moments.
And I want to do the filtering at query time. The reports almost always return data from several tables.
And without the filter at query time millions of rows may be returned.
 
If I can apply the filter at query time only the appropiate data is reurned not a bunch where it must then be filtered.
 
These are all real time actual data so performance is a priority
So how to do that with security on the data object is great.
 
Gary

micajblock

There are numerous ways to tackle this. I would need to know much more about your application before I can give a best practice. Possible solutions are:
<ol><li>adding a script to modify the query in the data object based on the user.</li>
<li>use an instantiated data object with security (this would depend on how frequently the data is updated). This will be the fastest option.</li>
</ol>

grather

Mica
 
I did just look at the Data Security
 
In this chaper they are talking about using a .data object and filtering the data.
Like I said in my previous post This data is dynamic and must report on live data no caching.
 
So my technical solution of adding the appropiate attributes to the query still seems like the best bet.
We have been doing this in our existing BIRT open source reports. (About 5 years worth)
 
But what I am trying to do is now take advantage of having the iHub server involved.
 So my challenge is modifying my reports to do it the iHub way.
 
In the BIRT open source every one of my reports was using a scripted data source. Under our servlet context where I had a connection pool available. And these attributes were done in dynamic sql using a java scripted dataset.

Now we want to take advantge of the iHub to move our load off the application server itself, the scheduling and the ReportStudio.
 
That how I ended up asking such a defined technical question. Which I was close just not in the right place.
Which is adding the script to modify the queryText You #1
 
Still up for sugesstion though.
 
Gary

grather

So on to my next stumbling block.
Provided I am trying to use a script to update the queryText depending on the User.
 
How can I tell iHub what these parameters are.
 
I know in my application. I have those know when the user call the ReportStudio .
 
But how to make the available.
 
Should I pass these as report parameters. I have struggled trying to add report parameters in a dataobject then using that databoject in a report.
 
Are there some type of properties (Attributes) I could assign a user when logging in?
In my world the general user will never have access to the iHub console directly. Everything goes through our application.
 
Can I set some session variables for this user?
 
I know how to get the user. But not sure about how to set and get the needed info.
I just figured out I can do it.
 
Gary

grather

Mica
 
I thank you so much for all the responses.
This is one of the few times where I have actually gotten a quick response from my question here on the forum.
 
Thank you for taking the time to make me ask the proper question and I did recieve the proper answer.
 
Again thank you
 
Gary Rather

micajblock

Gary,
I would highly recommend for you to discuss this with our Professional Services organization. They can help you with designing the best way to implement your application with the Actuate products. PM me with your company and location and I can put you in touch with the right people.