Get Free Trial

i have to create a report in an angular application with default date filter applied to last 90 days.

Answered
amir asked on March 5, 2021

i have to create a report in an angular application with default date filter applied to last 90 days. Now can i use “last quater” filter or have any other method to have last 90 days filter to date column dynamically 

4 answers

Public
Tanya Gryshko Tanya Gryshko Flexmonster March 5, 2021

Hello, Amir, 
 
Thank you for writing to our forum.
 
It seems that the last quarter filter is the most suitable for this scenario. Also, you are welcome to check our docs where all date filters are described: https://www.flexmonster.com/api/date-query-object/. The same filters are also available in the UI.
 
Please let us know if any further questions occur.
 
Kind regards,
Tanya

Public
Tanya Gryshko Tanya Gryshko Flexmonster March 5, 2021

Amir,
 
Adding more details to my initial reply, I would like to clarify that although the last filter is dynamic, it is not a direct equivalent of the last 90 days. For instance, since now is the Q1 of 2021, the last quarter is Q4 2020. 
 
Another dynamic filter that may be useful in this situation is current. However, to show the last 90 days, we suggest setting the needed date explicitly before loading the report into the component. Please let me know if you need more details on this approach.

Kind regards,
Tanya 

Public
amir March 12, 2021

Thank you for your response. I am planning to use last quarter. But i am facing problem. I am using flexmonster with elasticsearch. And for date type data i am not able to apply date filter with “Last”  anything. i.e i am able to filter date data by other parameters like equal, before , after and so on but when I try to use last date filter with any value like last quarter, last month etc it is not working when i check  _search post request it is sending empty post data as in the screenshot attached 
 
 
 

Attachments:
empty-date-filter.PNG

Public
Milena Pechura Milena Pechura Flexmonster March 13, 2021

Hi, Amir,
 
Thank you for describing the issue in detail.
 
Our team noticed your new question related to this issue on our forum.
Please see the answer following this link.
 
Kind regards,
Milena

Please login or Register to Submit Answer