Question
Year Number, Month Number and Right Trim SQL functions not working on RD in Postgres
Hi Team
I have migrated from Oracle to Postgres DB and now the Year Number, Month Number and Right Trim SQL functions on my Report Definition have stopped working.
I noticed these function aliases are circumstanced with condition - pyProductType = ORACLE. Do we have any corresponding function aliases for Postgres.
Regards
Saurabh
***Updated by moderator: Lochan to add Categories***
Hi Saurabh,
Thanks for posting on PSC.
Year Number:-
There is a circumstanced rule available for POSTGRES - RS: Pega-RulesEngine:07-10-19 ID:pxYearNumber
pxMonthNumber:-
There is a circumstanced rule available for POSTGRES - RS: Pega-RulesEngine:07-10-15 ID:pxMonthNumber
pxRightTrim:
It doesn't have circumstanced version for POSTGRES.
You could view all the circumstanced version:
- Click on "Actions" button on top-right corner of the rule.
- Select "View versions"
- Open version and verify the circumstanced property by clicking on "Circumstanced" link inside the bracket.
Hope it answers your query, kindly notify by marking this post as answered for larger Pega audience.
Regards,
Asif