scottw02 Member since 2013 9 posts
Wells Fargo
Posted: 2 years ago
Last activity: 2 years 7 months ago

Force left padding of 0's for integer


I've got a report definition, pega 7.2.2. In the query section, I need to specify a value which is integer, and left padded with zeros. However, Every time I try to save the RD to test with something like "001" (without the quotes because it's an integer), on save, the RD wipes out my leading zeros. I've tried to create a parameter and set the default value to 001, and I've tried to pass in a parameter of 001. However, none of that works and I get no results because my field in the DB is padded with zeros.

It seems to me, that this is bad behavior and that I need to open an SR, but I figured I'd check with support community to see if there is an easy way to do it that I don't know about prior to submitting the SR.



Low-Code App Development Dev/Designer Studio Reporting
Moderation Team has archived post
Share this page LinkedIn