Question

3
Replies
54
Views
SatishVanapalli Member since 2012 8 posts
Synechron
Posted: 4 months ago
Last activity: 3 months 2 weeks ago
Solved

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***

Pega Platform 7.1.8 Data Integration Java and Activities Financial Services Lead System Architect
Share this page LinkedIn