Property on clipboard can't be referenced when DBMS is PostgreSQL

Blueprint and App Design
,
1

Hi,

I am using RDB-List method to load data from table but I can’t reference data in the activity because in Pega, properties are defined in combination of upper case and lower case while on clipboard properties are loaded by all lower case.

  • Activity (I am trying to log “pzInsKey” but it doesn’t work)

activity.png
activity.png739×687 34.4 KB

  • Connect SQL

Connect SQL.png
Connect SQL.png506×241 13.9 KB

  • Clipboard (Note it is loaded as “pzinskey”, not “pzInsKey”.. this is why Log-Message does not work)

Clipboard.png
Clipboard.png429×179 9.09 KB

If I try to access “pzinskey” instead of “pzInsKey” in the activity, it doesn’t even let me save the rule. System only recognizes “pzInsKey” as it is defined as such in PRPC.

According to https://collaborate.pega.com/question/upper-case-and-lower-case-issue-postgresql-database, I updated External Mapping to map PRPC property name (upper case / lower case) and PostgreSQL column name (lower case) as below but the result was the same. How can I resolve this issue?

External Mapping.png
External Mapping.png524×234 12 KB

Thanks,

2

Hi,

There are two approaches.

  • Use “AS” to load property name as upper case and lower case in the Connect SQL. This way you should be able to reference “pzInsKey” in the activity.

    select pzinskey as "pzInsKey"...

  • Use an OOTB RUF “@pxRuleManagement.pxGetPropertyValue” to reference a property that doesn’t actually exist in PRPC but loaded on clipboard. In your example, syntax would be:

    @pxRuleManagement.pxGetPropertyValue(<CURRENT>, "pzinskey")

Thanks,