Joined: 08/07/2010 18:07:07
I have a document (jasper report) with 3 parameters, where the last one is related to the previous ones. e.g.
parameter1= DATE (input type string)
parameter2= PROJECT (LOV with PROJECT_ID)
parameter3= ISSUE (LOV with ISSUE_ID,PROJECT_ID,DATE)
parameter3 relations: DATE=ISSUE.DATE AND PROJECT.PROJECT_ID = ISSUE.PROJECT_ID
When I start the execution of this document, a lot of time is spent on "Loading Parameters..." phase because, I suppose, the query for ISSUE's LOV is very low (milions of rows inside database table).
Is it possible for related parameters to simulate a lazy loading and execute the LOV query only after father parameters have been selected, and using directly the where conditions in order to reduce the query cost?
In my opinion, the behavior should be:
- father or standalone parameters loading (LOV query execution) on document execution (in my case DATE and PROJECT)
- child parameters not loaded at document execution but only after father parameters have been selected and using directly where conditions (in my case: select * from issue where date = xxx and project_id = yyy)
This should avoid the loading of useless data from db in order to apply after the where conditions.
Any idea about how to do it?
Thanks a lot..