Loading Profile...
how to create date-filter ranges based on supplier data
I'm trying to create a report which collates news entries from local space or user's personal spaces but apply a date filter to only retrieve information from the actual week, when the page was created e.g. I create a page on 10th June and it grabs all news entries for users x, y & z entered between 3rd & 10th. I then create a page on 22nd June and it should only grab news entered in that past week e.g 15th - 22nd, but when I revisit the first page, the filter should only report news from the week ending 10th June (eg 3rd - 10th, not based on current date such as...
{report-list:injected=true}
{content-reporter:spaces=@self,@personal|type=news}
{date-sort:content:modification date|order=descending}
{date-filter:content:modification date|minValue=%content:modification date -1w%|maxValue=%content:modification date%}
{user-filter:content:creator|users=x,y,z}
{content-reporter}
{report-body}{report-image:content:icon} {report-info:content:modification date|format=EEE, d MMM yy} {report-info:content:title|link=true} {report-info:content:modifier|link=false}{report-body}
{report-empty}
_No news items are available._
{report-empty}
{report-list}
It's the date-filter that I can't get right and not sure if I can use injection to achieve this? The report always returns the most recent week without filtering but not sure how to structure it.
Thanks
{report-list:injected=true}
{content-reporter:spaces=@self,@personal|type=news}
{date-sort:content:modification date|order=descending}
{date-filter:content:modification date|minValue=%content:modification date -1w%|maxValue=%content:modification date%}
{user-filter:content:creator|users=x,y,z}
{content-reporter}
{report-body}{report-image:content:icon} {report-info:content:modification date|format=EEE, d MMM yy} {report-info:content:title|link=true} {report-info:content:modifier|link=false}{report-body}
{report-empty}
_No news items are available._
{report-empty}
{report-list}
It's the date-filter that I can't get right and not sure if I can use injection to achieve this? The report always returns the most recent week without filtering but not sure how to structure it.
Thanks
1
person has this question
I have this question, too!
Tell me when someone answers.
The more people who ask this question, the more it gets noticed.
The more people who ask this question, the more it gets noticed.
The company marked this question as answered.
-
Inappropriate?We don't really have any support for that kind of relative date currently. You can to a 'minDate=-2w', but not in combination with an arbitrary fixed date. From memory there is an existing issue to allow people to set the 'epoch' or 'fromDate', but nothing has been implemented yet to my knowledge.
So, the short answer is, sorry for the moment, but feel free to create a feature request and it may get implemented at some point.
EMPLOYEE
