Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Madhu Raghavaraju (MadhuR16578287)
Shell India market private limited
IN
MadhuR16578287 Member since 2022 12 posts
Posted: Apr 24, 2023
Last activity: Apr 24, 2023
Posted: 24 Apr 2023 3:26 EDT
Last activity: 24 Apr 2023 11:33 EDT
Closed

Filter Years Dynamically

How to display next 5 years dynamically in dropdown based on current year.

My Scenario: I have one report under Reports navigation pane.

1.If user select that particular report today (current date) then the Yearly dropdown filed should allow user to choose the years next five years, 2023, 24,25,26,27.

2. Suppose i am in date "April 24 2024" and i have clicked on the report then user should able to see the dropdown for following 5 years from 2024, like 2024,25,26,27,28.

Please advise if there anyway to achieve this functionality. Also i have attached the screen shot.Screen shot

***Edited by Moderator: Pooja Gadige to change category from General to Product, add product details tag, add capability tag***
To see attachments, please log in.
Pega Platform
User Experience
Healthcare and Life Sciences

Posted: 1 year ago
Posted: 24 Apr 2023 5:11 EDT
Saurabh Gupta (SaurabhG7134)
ING Nederland
Pega Engineer
ING Nederland
NL

Hi @MadhuR16578287, you can use the Year of [Input Date] function in your 1st report to get the year of the input date, then pass that date to the second dpage/report which is the source of your "Yearly" dropdown, sort the year in a descending order and set "Maximum number of rows to retrieve" as 5. 

Regards,

Saurabh.

To see attachments, please log in.

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

Pega Collaboration Center 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