Jasper showing duplicate Global Collections
Article ID: 8238
Updated On:
Products
Issue/Introduction
Jasper is showing duplicate global collections in the parameters page of the group reports.
Environment
Cause
The query for Global Collections misses if there is a model destroy time on the Global Collections.
For instance, A Global Collection named test is created and summarily deleted at a later date.
Some time after a new Global Collection named test is created. In the Report Manager database
there will be two instances of the Global Collection named test. The original that was destroyed
will have a model destroy time assigned to it for when the original collection was destroyed. The
new Global Collection will have a model destroy time of NULL. Currently the query pulling the
Global Collection list does not evaluate the model destroy time field so it will pull both instances
of the test Global Collection.
Resolution
1. Login to Jasper as the user superuser with a password of superuser
2. Navigate to the folder View -> Repository -> Organizations -> spectrum -> capability -> inputcontrols -> queries
3. Right click on q_group_name and select edit
4.Click next twice to go to "Define the Query"
5.Remove the content under Query String and paste the below query:
select distinct entity_group_name, group_id from entitygroup
inner join groupentitygroups on groupentitygroups.entity_group_id=entitygroup.entity_group_ID
inner join entitygroupentity on entitygroupentity.entity_group_ID = groupentitygroups.entity_group_id
inner join entity e on e.entity_id = entitygroupentity.entity_ID
inner join model m on e.current_model_key = m.model_key
where $X{EQUAL,entitygroup.entity_group_type,p_group_type}
5.click save and rerun the group report the duplicate collections should be removed.
Additional Information
This fix will be included in Spectrum 10.2.2 and Spectrum 10.3 upon release.
Feedback
