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

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Correct Answer
March 28, 2018 - 11:07am

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

Comments

Keep up to date on this post and subscribe to comments

Pega
March 28, 2018 - 11:07am

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