Question
Synechron
US
Last activity: 1 Jun 2020 13:58 EDT
BIX sql query formation where pzInsKey like or pzInskey equal to
I see when work level extracts rules execution, the sql query forms with pzInskey like
SQL SELECT pzPVStream FROM Schema.TableName WHERE pzInsKey like ? AND pxUpdateDateTime >= ? AND pxUpdateDateTime <= ? ORDER BY pzInsKey
SQL Inserts <XXX-XX-XXX-WORK%> <2020-05-11 16:46:58.0> <2020-05-11 16:57:43.394>
But when ever the specific class level extract rule execution, the sql query forms with pxObjClass equals
SQL SELECT pzPVStream FROM Schema.TableName WHERE pxObjClass = ? AND pxUpdateDateTime >= ? AND pxUpdateDateTime <= ? ORDER BY pzInsKey
SQL Inserts <XXX-XX-XXXX-Work-BR-Auto> <2020-05-11 16:46:58.0> <2020-05-11 16:57:43.394>
Please suggest where to modify, so that my specific class level extract should take pzInsKey like instead of pxObjClass equals to.
***Edited by Moderator Marissa to update Content Type from Discussion to Question***
Accepted Solution
Updated: 1 Jun 2020 13:58 EDT
Pegasystems Inc.
US
In general whether the extract query is filtered on pzInskey or pxObjclass will depend on whether the class is a classgroup or not. The pzInskey like will be when the extract is based on a class group. The pxObjclass is for when a class is not a class group. I am not sure what version of BIX you are running but in later versions the "pzInskey like" may be gone entirely and instead is a series of "pxObjclass =" for each member of the classgroup. In later versions you can remove these standard filters and instead just add whatever filter you want so you would be able to specify a "pzInskey like" if you wanted but in general the like is going to make the query perform poorly compared to the = operation.
Accepted Solution
Updated: 1 Jun 2020 13:58 EDT
Pegasystems Inc.
US
In general whether the extract query is filtered on pzInskey or pxObjclass will depend on whether the class is a classgroup or not. The pzInskey like will be when the extract is based on a class group. The pxObjclass is for when a class is not a class group. I am not sure what version of BIX you are running but in later versions the "pzInskey like" may be gone entirely and instead is a series of "pxObjclass =" for each member of the classgroup. In later versions you can remove these standard filters and instead just add whatever filter you want so you would be able to specify a "pzInskey like" if you wanted but in general the like is going to make the query perform poorly compared to the = operation.
Synechron
US
Thank you @CelesteDufresne_GCS