SA-35781

Summary

Child classes instances are not picked when user execute Business Intelligence Exchange (BIX) extracts which are present in the parent class.

Error Messages

Not Applicable

Steps to Reproduce

1.Open a BIX extract rule which is present in parent class.
2.Execute it.

Root Cause

A defect or configuration issue in the operating environment.

Issue is that in earlier version of BIX were taking advantage of the bug that would use a "like" in the where clause instead of an "=" even when the class was not a classgroup.

Extracts are specified at the class level, not at the application level.

For example, if there are three case types in the application and would like to extract data for each, one must define an extract rule for each of the three case types.

Note: When extracting from a class group, the extract will include all classes in the class group. If the class is not a class group, the extract will only include instances of that class.

Similar to other areas of the product (like List Views, Report Definitions etc.), when a rule is defined at the classgroup level, BIX will include its subclasses by using a LIKE query.

But for classes which themselves are not a classgroup but belong to one, then BIX does not generate a LIKE query.

There was a bug in Extract rule executions which have been fixed to keep the behavior consistent with other rules.

Resolution

In BIX 7.2.2 there is a new feature which will allow the standard filters to be removed from the extraction query.

There is a secondary option to also remove the order by clause from the query. The feature has been backported to Pega 7.2.1

With this feature one can mimic the same behavior user was seeing in previous release of BIX.

This feature involves both code and rule changes. These are the installation instructions.

1. Using Hot Fix Manager install DL item containing HFix-33290 and its dependent hot fixes

2. Import HFix-33295.jar using Import Utility

3. Restart all nodes

After this when you open your Extract rule on the "Filter Criteria" tab, see a checkbox to "Skip Standard Filters".

With this checked the standard "pzInsKey like" for a classgroup or the "pxObjClass =" for a class will not be included in the generated extraction query.

There is a second checkbox "Skip standard order by clause".

​ With this checked the standard order by pzInskey clause to the generated extraction query.