Question

3
Replies
252
Views
KrishnakanthT Member since 2015 3 posts
TCS
Posted: 3 years ago
Last activity: 3 years 7 months ago
Closed
Solved

How to retrieve data from DB by passing Month value alone to DATE column (yyyyMMdd)?

Hi, I have a requirement where month value is selected in the dropdown (1 to 12) and on Search I need to retrieve all the records which has the selected month in 'Date' column. The Date column holds date in 'yyyyMMdd' format.

For example if I select month value as '11', I need to get records which has month as '11' in DATE column (20161103, 20101120, xxxx11xx,....).

Report Definition is used to fetch data. I need to pass Month value to DATE column in Filters. Will there be performance issue?

Is there any Pega OOTB function to accomplish this task? 

Thanks in Advance.

***Updated by moderator: Lochan to update Categories***

Case Management Reporting
Moderation Team has archived post
Share this page LinkedIn