We are using Pega 8.4.1. I dont see pxSQLStatementPre and pxSQLStatementPost properties on the clipboard after executing a report definition which I remember seeing in earlier versions of pega making it easy to debug any issues related to report definition behaviour.
Any reason why these are not available and how we can make them available?
Any suggestions or thoughts are appreciated.
***Edited by Moderator: Pooja Gadige to add platform capability tag***
@AmarGajananW - Thanks for the response. I have observed pre and post sql in earlier versions of Pega. However in the current version that we are using 8.4.1 below is the snapshot of pyreportcontentpage where I dont see the generated SQL. So want to check how the generated SQL can be made available on clipboard.
@SatishKumarL5551 Pega is not maintaining these properties (pxSQLStatementPre and pxSQLStatementPost) in pyReportContentPage from Pega 8 version. To check the Pre and Post execution queries of report definition, enable DB Query option in Tracer settings and execute the report definition.
Once report is executed switch back to tracer and navigate to SQL Query step :
For Pre SQL: Navigate to the step where Even Type is SQL: Click on the step, the query that is present in SQL attribute is Pre SQL
For post SQL : Navigate to the step where Even Type is Package Results: Click on the step, the query that is present in SQL attribute is Post SQL