asked on September 5, 2023
When filtering by datetime dimensions, we have the option of filtering only by date.
Filtering by date and time is needed.
⋅ September 6, 2023
Hello, Janez!
Thank you for contacting us.
Kindly note that you can add the time filter to your custom filtering pop-up by using a couple of Flexmonster API calls.
Please find the brief description of the approach below:
1. Get all the timestamps from the initial data using getMembers() API call:
const timestamps = pivot.getMembers("Date")
.map(d =>parseInt(d.uniqueName.match(/\d+/)[0], 10));
2. Convert timestamps to the JavaScript Date object:
const date = new Date(timestamp);
3. Get the time from the created object using date.getHours() function and compare it with the time selected in the filter.
4. After comparing, apply the filter using our setFilter() API call:
pivot.setFilter("Date", {
members: filteredTimestamps.map(t => "date.[" + t + "]")
})
We have prepared a JSFiddle sample to illustrate the idea: https://jsfiddle.net/flexmonster/sgjnkp92/.
Here, we are filtering all the timestamps with the datetime greater than 2023.09.06 10:00:00 AM.
Hope you will find our answer helpful.
Please let us know if the suggested approach works for your case.
Kind regards,
Solomiia
⋅ September 11, 2023
Hi,
Thank you for your response, but I believe there may have been a misunderstanding.
In the attached screenshot, the yellow highlight indicates where we would like to have an option to include time as a filter.
Could be so kind to ask dev team to add this feture? In screen shoot Time should be written on not Date
Janez
⋅ September 13, 2023
Hello, Janez!
Thank you for your response.
We kindly recommend creating a custom filter pop-up to add the time filter to the datetime field.
You can find a step-by-step guide on how to create a custom filter in the following thread: https://www.flexmonster.com/question/how-to-use-custom-labels-for-filter-items/.
Hope you will find our answer helpful.
Feel free to reach out to us in case of any further questions.
Kind regards,
Solomiia
⋅ September 21, 2023
Hello, Janez!
Hope you are having a great week.
Our team is wondering if you had a chance to look through the provided thread. Could you please let us know if there are any further questions about adding a custom filter pop-up?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ September 22, 2023
Hello,
Your suggested solution could work but will add aditional complexity to the our solution that we don't want.
On the other hand I belive that your dev team doesn't have much work to add this to standard solution.
Could you be so kind to ask them if they could add this to your product?
Janez
⋅ September 22, 2023
Hello, Janez!
Thank you for your response.
We have added the request for time filter UI control in the Filter pop-up to our clients' wishlist.
Our team will notify you about any updates on the matter.
Feel free to contact us if any other questions arise.
Kind regards,
Solomiia
⋅ May 28, 2024
Hello Janez,
We are happy to let you know that a new filter.filterByDateAndTime option was added. When set to true, date fields are filtered by both date and time parts. This option is supported only for the "api" data source type.
This feature is included in the 2.9.77 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-77/
You are welcome to update the component. Check out our updating tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if the feature works.
Kind regards,
Nadia
⋅ May 28, 2024
Thank you this will realy help us.
Could you prepere for us one fidler to help us tu implement new fuctionality faster.
Janez
⋅ May 29, 2024
Hello Janez,
Thank you for the feedback.
Please refer to the following JSFiddle for illustration: https://jsfiddle.net/flexmonster/w1y57gzq/. Kindly note that this option is supported only for the "api" data source type.
We hope this helps. You are welcome to contact us if other questions arise.
Kind regards,
Nadia