CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Can we have another set of relative filters for reports
Pages: [1]

Author Topic: Can we have another set of relative filters for reports  (Read 814 times)

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Can we have another set of relative filters for reports
September 02, 2014, 06:42:13 am
I know there are a lot of relative filters already, but the one I want is not there.

We have 12 and 24 month rolling memberships and I want to be able to send out a report on the first day of each month that states the total number of members on the last day of previous month.

Who gets to decide what relative filters are included in the reports (and searches).

If I come up with the code for it and submit a patch will it be included in core?

Although I only need "from last day of previous month"  (which I thought could be greater_previous.month)  I could submit code for "from last day of previous year" , "...quarter" etc for completeness.

 

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Can we have another set of relative filters for reports
September 02, 2014, 06:44:31 am
Quote
Who gets to decide what relative filters are included in the reports (and searches).
It's pretty much a do-ocracy. Whoever wants to do it can add more to reports :)

Code: [Select]
If I come up with the code for it and submit a patch will it be included in core? I'm sure that can be arranged...

The relative date filter is sort of a "package" so if you want one of the options you need to add the whole thing.
Try asking your question on the new CiviCRM help site.

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: Can we have another set of relative filters for reports
September 02, 2014, 09:19:02 am
FWIW the current system is not scaleable and a better approach IMO would be to the change relative filter implementation from the current set up to a form that looked a bit more like

FROM: [N] [TIMEPERIOD]
TO:  [N] [TIMEPERIOD]

Where N can be a positive or negative integer and time period is a select for days, weeks, months, years.

Not that I am against adding more to the list - just saying :)


Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Can we have another set of relative filters for reports
September 02, 2014, 09:20:50 am
Don't forget what I said about do-ocracy Michael.
Be the change ;)
Try asking your question on the new CiviCRM help site.

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Can we have another set of relative filters for reports
September 03, 2014, 03:40:26 am
I have created https://issues.civicrm.org/jira/browse/CRM-15227 and submitted three PRs: one for new relative date filters, one to fix some e-notices and one to change wording for an existing set of relative date filters to make it conform to the established patterns.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Can we have another set of relative filters for reports

This forum was archived on 2017-11-26.