Property on clipboard can't be referenced when DBMS is PostgreSQL
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)
- Connect SQL
- Clipboard (Note it is loaded as "pzinskey", not "pzInsKey".. this is why Log-Message does not work)
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.
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)
- Connect SQL
- Clipboard (Note it is loaded as "pzinskey", not "pzInsKey".. this is why Log-Message does not work)
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?
Thanks,