Question

1
Replies
2848
Views
scott wiemers (scottw)
Not Public Information

Not Public Information
US
scottw Member since 2013 9 posts
Not Public Information
Posted: January 22, 2018
Last activity: January 23, 2018
Posted: 22 Jan 2018 17:19 EST
Last activity: 23 Jan 2018 3:09 EST
Closed

Force left padding of 0's for integer

Hi,

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.

thanks,

scott

Enterprise Application Development Dev/Designer Studio Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.