Question

3
Replies
327
Views
Krishnakanth T (KrishnakanthT)
TCS

TCS
IN
KrishnakanthT Member since 2015 3 posts
TCS
Posted: January 17, 2017
Last activity: January 25, 2017
Posted: 17 Jan 2017 22:19 EST
Last activity: 25 Jan 2017 23:16 EST
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, 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.