Question

3
Replies
45
Views
Close popover
Satya Kanth (Satyakanth)
Infosys
Satya Kanth
Infosys
AU
Satyakanth Member since 2012 47 posts
Infosys
Posted: March 2, 2020
Last activity: 3 weeks 2 days ago

how to mention logs for debugging in SQL function alias

All,

We are using Pega 7.2.2 and I have got a functional alias(SQL). I'm calling this from a report definition and it is getting called as well. The problem is I have got few conditions in the functional alias and I don't know which condition is getting executed. Is there any way to have log statements or console logs which would be useful to debug. Below is the code which I have -

(Case When ({2} IS NOT NULL AND {4} IS NULL AND {3} IS NOT NULL) Then 'Completed' When ({2} IS NOT NULL AND {4} IS NULL AND {3} IS NULL) Then 'Not Completed' When ({2} IS NOT NULL AND {4} IS NOT NULL) Then 'Not Completed' When {2} IS NULL Then 'Not Completed' End)

Any pointers would be much appreciated.

Cheers

Pega Platform 7.2.2 Low-Code App Development Dev/Designer Studio Government Senior System Architect