How to show upcomig milestone based on date in Canvas

Rajakumar Burra

I have a table like below.

I want show only upcoming milestone based on current date.

For example, My canvas should show only RC2 Content Complete Oct/25/2024

Any ideas?

Federico Venturin - Oracle

Hi @Rajakumar Burra ,

I would create a parameter and initialize it with the date of the upcoming milestone using a logical SQL query: select MIN(Date) from <Dataset/Subject area> where Date >= CURRENT_DATE and Milestones IS NOT NULL

Then you can add an expression filter to your table (or to your canvas): Date = @parameter(<NAME>)(<DEFAULT>)

Rajakumar Burra

Thanks @Federico Venturin It works.

In

I have not used Logical SQL parameter select MIN(Date) from <Dataset/Subject area> where Date >= CURRENT_DATE

and used Initial Value as "First Available" and bind to table filters.