I'm trying to filter a column, where the value need to be shown in date time format, but it's filtered using date format. e.g if i filter 2023-12-13, the data shown will be the ones on that date, So 2 data with date of 2023-12-13, regardless of the time.
Is there a way to do this, since if i changed the format on the column, the filter automatically changes as well. Is there a way for the filter to be date only, and the data shown on the table is on datetime format?
I've tried doing some modification on the backend side to get the data based on the date only, and it says that there's 2 data, but the data isn't shown on the datagrid table.
Any idea on how to do this? Thank you.Best Regards, Felix
Hello @Felix Intan Bahagia
This issue is a known issue that will be fixed under the code ROU-4702 (for reference in the release notes) and released in the next release of OutSystems Data Grid (ETA end of January / beginning of February).
Cheers,GM
Hi @Felix Intan Bahagia ,If you want to filter for a specific date without time selection, then you should use "Is greater than" instead of "Equals".Here I filter data with "Is greater than" and it returns 3 records.Regards,
Hi Anubhav,Thanks for the reply. The requirement at the moment is using equal, since we only want to show data specific on that chosen date. For example if we choose 2023-11-28, the data shown is only on 2023-11-28. Using Is Greater Than could show data above that date.Best Regards, Felix
In that case, you will need to apply another filter with the "And" condition.I don't think if you can filter datetime without mentioning time and get results with only the "equals" condition, equal will perfectly work with text input but not with datetime.
I see, is there a way to just show the filtered data from the database, without the data being filtered by DataGrid?
Since here i can see that i got the 2 items that's already filtered from the backend, but since it's being filtered again by datagrid, it's not showing up on the table. Is there a way to just show the data if the column being filtered is the datetime column, while other columns will work as usual?
Not sure why data is showing in pagination, in my case no data is available.Other than that what I have explained to you is the default filter behavior of this component, we can not change it from our side.If you feel that it should work differently then in this case, you can raise an Outsystems support ticket.