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) »
  • Alpha and Beta Release Testing »
  • 3.4 and 4.0 Releases Testing »
  • Reports lose their criteria
Pages: [1]

Author Topic: Reports lose their criteria  (Read 1373 times)

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Reports lose their criteria
March 18, 2011, 03:05:52 pm
3.4.alpha3

I upgraded and rebuilt the menus, and my dashlets displayed, but as if the underlying reports had lost memory of their criteria. When I ran the reports by hand they had indeed lost memory of their criteria (my dashboard is set to show custom reports, eg Ken's outstanding Activities, but the dashlets show eg all Activities).

Ken

Rajan Mayekar

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 20
    • Rajan's Blogs
Re: Reports lose their criteria
March 21, 2011, 10:02:24 pm
This is regrading issue http://issues.civicrm.org/jira/browse/CRM-7681
For 3.4.alpha3, in most of the reports we have changed contact display name to sort name, so we are rebuilding the instance criteria of modified report in 3.4.alpha3 upgrade. 
Need to reset the custom criteria of those instance again :(

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Reports lose their criteria
March 21, 2011, 11:26:00 pm
Can we warn people of this as they upgrade (or in the upgrade documentation). It can be a bit of work resetting a bunch of reports, and better done with forethought (eg, writing down all the criteria before an upgrade) rather than afterwards (eg, what are the settings on that report again?).

Thanks,
Ken

Rajan Mayekar

  • I post frequently
  • ***
  • Posts: 177
  • Karma: 20
    • Rajan's Blogs
Re: Reports lose their criteria
March 21, 2011, 11:57:21 pm
Yes, I think this is better suggestion :)
Report criteria is stored as serialised array in db,
so for updation of sepecific field we need to
1. unserialise the data ( instance criteria ) and modify criteria array accordingly.
2. again serialise and save.

This will bit lengthy but very useful.

Thanks,
Rajan

ken

  • I live on this forum
  • *****
  • Posts: 916
  • Karma: 53
    • City Bible Forum
  • CiviCRM version: 4.6.3
  • CMS version: Drupal 7.36
  • MySQL version: 5.5.41
  • PHP version: 5.3.10
Re: Reports lose their criteria
March 22, 2011, 04:37:14 am
Yes, that's a much better suggestion!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Reports lose their criteria
March 22, 2011, 07:02:26 am

we cannot delete the report criteria because it changed :P

we should unserialize and fix. We'll make the needed fixes for beta1

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 3.4 and 4.0 Releases Testing »
  • Reports lose their criteria

This forum was archived on 2017-11-26.