Idea Summary
Dates in an IG gets a nice default quick picks for date ranges.
But when you want to enter a specific date it is not as helpful.
An end user will want to enter someting like "2023-05-15" and get all rows for that day no matter the time portion.
The date filter is displyed as something like “reg_date equal to 2023-05-15” but in reality it is 2023-05-15 00:00:00. The typical enduser is not really aware of how Oracle store dates.
Also in the actions-filter dialog there is no time that can be selected. mening the user ends up selecting a date but it searches for just the second at midnight.
When the time is not displayed, it is to the end user very confusining that some rows are shown and some are not. The shown ones being the ones that happened right at midnight (00:00:00).
Sure, they can go into Actions-Filter and enter an between where they get to pick the dates. But even that is confusing to an end user. Why a between when they look for a single day. Having to explain to end users how dates are stored in Oracle and that their user interface has a UX that is the result on technical choices 40 years back is not really making it feel low-code and "it just works".
And sure, we can make it a string and then get distinct values but then missing out on the date specific quick picks and date picker popup in the filter dialog.
It is of course also possible to make the SQL truncate the date to ensure all dates are just the day portion. But that requires SQL and you cannot just point to the table you want to display data from. That in turn can be solved with a view. It also makes the ability to control how it is displayed with a format specification on the column less useful.
Even if we force the column to be a date we create data on the fly that are not in an index. Creating a view + FBI is about as far from low-code as we can get.
Use Case
Anytime a user want to search for a date in a report where the actual column value includes time portion. Especially when we opt to not show that time.
Preferred Solution (Optional)
When a user enters a date, all rows for that date is retrieved using a between. The column filter the user gets when clicking the label would preferably also show a date picker just like the actions→filter does.