Question

3
Replies
90
Views
Sateesh Kumar Vanapalli (SatishVanapalli)
Synechron
Lead Architect - Technology
Synechron
US
SatishVanapalli Member since 2012 8 posts
Synechron
Posted: May 11, 2020
Last activity: June 1, 2020
Posted: 11 May 2020 18:06 EDT
Last activity: 1 Jun 2020 13:58 EDT
Closed
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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.