Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Decimal Property truncating Scale when used with a Qualifier

SA-31857

Summary



Decimal Property Truncating Scale when used with a Qualifier for ja_JP locale.

When decimal property values are retrieved directly from DB using RDB-list method in an activity.


Error Messages



Not applicable


Steps to Reproduce



1.Set user locale to ja_JP
2.Launch SI Manager portal.
3.Click on Search Portal
4.Select Payments from Select Table drop-down.
5.Select Payment Details from Select List drop-down.
6.Select LON from Branch drop-down and then click Find.
7.Observe the Debit amount Column. (Here multiple results are shown in a repeat grid).
8.Double Click on any row to detailed single result in a modal dialog.(Here,Property values retrieved directly from DB using RDB-list method in an activity).


Root Cause



Each property qualifier provides additional information at runtime about the property, and may alter the behavior in computations or presentation of the property.

Hence, in cases where Qualifier is used, Qualifier value(for example, MSGCCY/.DBTCCY) should be provided at first than the Property value(.MSGAMT/.DBTAMT).

Here, Order is important and it matters, if qualifier value is not provided first,it is not taken into consideration.

So,while retrieving the values through a RDB-List method using Connect-SQL rule,order of retrieving values through SQL query becomes important.

Resolution



Modify the SQL query.

In particular here, the SQL query in the Custom Connect-SQL rule should be as below:

SELECT
DBTCCY AS "DBTCCY", DBTAMT AS "DBTAMT",  <other columns>  FROM DATA.AMOUNT WHERE <clause>.

 

Published January 12, 2017 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us