nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OAC - Auto selection of Current Date in List Filter

Hasan Sd

Hii OAC Community. As shown below ,In some of our visualizations ,We have List Filter having Date values of Data type:Date and Format :dd/MM/yyyy .We want to make sure that the selection of Current Date is done automatically .For this we tried with Parameters ,but we couldn't found the current date value as shown below.Pls suggest if this the correct approach ? also how to resolve this .Thank you.

Find more posts tagged with

Accepted answers

All comments

Sushant Mishra

You’re on the right track by using a date parameter to auto-select today’s date in your filter. For this to work, set your parameter’s initial value to an expression like CURRENT_DATE instead of a hardcoded date. Make sure your dataset always includes today’s date, otherwise the filter cannot select it automatically. If your data sometimes lacks the current date, consider applying a filter expression (YourDateColumn = CURRENT_DATE) or use the Relative Time Filter for best flexibility.

Hope this helps.

RVohra

Can you create a derived column in In your data model / dataset,

Example:

CASE WHEN TRUNC("Your_Date_Column") = TRUNC(CURRENT_DATE) THEN 'Y' ELSE 'N' END AS Is_Today

Now add this column to your canvas.

Create a hidden filter Is_Today = 'Y' on to limit data to today’s date.

Leave the List Filter for date visible, users can still change it manually.

Jestin Rajan

Hi, to do this please set the data type to Timestamp and Auto, then set the initial value to the following Logical SQL:

SELECT MAX(CURRENT_DATE) AS Current_Date FROM

XSA('<REPLACE_WITH_YOUR_DATASET_PATH>')

You’ll just need to replace <REPLACE_WITH_YOUR_DATASET_PATH> with any existing dataset reference from your environment — that should do the trick.
I’ve tested it on my end, and it works fine.

RVohra

Excellent, thanks for sharing.

Hasan Sd

Thank you everyone for the responses, we'll test them one by one:

Dear @Jestin Rajan ,we tried with the approach ,however we are getting an error as shown below, Can you pls advise what mistake we're doing ? Thank you.

Jestin Rajan

https://community.oracle.com/products/oracleanalytics/discussion/comment/71719#Comment_71719

Hi, most of it looks good. The only part I can’t verify is whether the reference is correctly set up as the LSQL expects. What I’d suggest is — since the file name shows as _kpi_dataset, please go to Data > (3 dots) > Inspect, and you should find an option to Copy Object ID. That exact ID is what needs to be copy-pasted here.

Hasan Sd

Thanks @Jestin Rajan ,After using object id ,it's auto selecting the current Date .However it's now in Timestamp Format .We require it in the format :dd/MM/yyyy .We tried changing the parameter Datatype from Timestamp to Date and Format :Custom - dd/MM/yyyy and keeping the same Logical SQL ,but its not working, Pls advise on this . Also find some screenshots below for your info:

Jestin Rajan

Glad it worked for you, @Hasan Sd ! What I’d suggest is to keep the parameter datatype as Timestamp (Auto), and then go to the visual and change the date format at the visual level from Auto to Custom (dd/MM/yyyy).

Hasan Sd

Thanks @Jestin Rajan for the reply .However we are not using Dashboard Filter Type. We are directly using Filters inside Different Visualizations as shown below :In this we can't see any option to change Filter Format to dd/MM/yyyy .Pls advise what we should now do to resolve this :

Jestin Rajan

In this case, since you’re directly using filters within individual visualizations, you can try either of the following approaches to resolve the issue:

Change the data type from DateTime to Date in your data file (as shown in the snapshot). You can also set the required date format (dd/MM/yyyy) at that stage.

Alternatively, At workbook level create a custom formula using

CAST(<your_value_field> AS DATE)

and then bind this field to your parameter — ensuring both have matching data types.