Hello!
I'm trying to ignore the current month data by using the following code:
"slice": {
"reportFilters": [
{
"uniqueName": "creationTimestamp.Year",
"filter": {
"query": {
"last": "month"
}
}
},
...
However, although the front seems to be catching the filter, it does not show any data.
The date format I'm using is: yyyy-MM-dd
Thank you!
Hello, Martin,
Thank you for your question.
It seems you might be using the date
date data type (the default) for the date Field.
We would like to explain that the date query {"last": "month"}
is supported only for date string
, datetime
, year/month/day
, year/quarter/month/day
date data types.
More information about the available date data types, please see our guide: https://www.flexmonster.com/doc/managing-data-presentation-json
We have prepared a JSFiddle example showing how the date query {"last": "month"}
can be used for date fields: https://jsfiddle.net/flexmonster/o2cjzuq8/
In this example, dates containing the current month (September) are filtered out. Dates containing the month before (August) are displayed on the grid.
Please let us know if this works for you.
You are welcome to contact us in case of questions.
Best Regards,
Vera