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) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • To0 many events showing in Druapl View
Pages: [1]

Author Topic: To0 many events showing in Druapl View  (Read 932 times)

mhoefer

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
To0 many events showing in Druapl View
March 09, 2011, 07:25:26 am
http://www.hannahgrimes.com/hannah-grimes-marketplace

No matter what I seem to do to the within the views module I can not get this view/list to not show the entire upcoming event calendar.

Would like to limit to the the next X# of events.

Any tips?

(64k limit for attachements seems a bit strict!)

dafeder

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 3.3
  • CMS version: Drupal 6
  • MySQL version: 5.092
  • PHP version: 5.2
Re: To0 many events showing in Druapl View
March 12, 2011, 09:05:49 am
Maybe try making the upcoming events view separate from your calendar view?

mhoefer

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
Re: Too many events showing in Drupal View
April 22, 2011, 01:43:17 pm
Still can not figure out this issue.  :( It really seems like it should be a simple thing. Adjust the view setting to the number of events you want to show.

At this point I have to assume the "CiviCRM Upcoming Events' block is not using a view but is some how hard coded to pull all upcoming events.

These thread seems to insinuate this
* http://forum.civicrm.org/index.php/topic,10956.0.html
* http://forum.civicrm.org/index.php/topic,16344.0.html

I did find and obsolete module on Drupal that was supposed to do this sort of thing
* http://drupal.org/project/civicrm_eventblock

Would love for one of the elders of these forums to chime in!  :D

It would seem to me that this would be a pretty std use case, its hard to believe there is no configurable way to limit the number of events.

mhoefer

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
Re: To0 many events showing in Druapl View
April 23, 2011, 07:44:02 am
Posting here to prevent future frustration for others.

It is not a views issue. The CiviEvent Upcoming Events does not seem to use a view!

I took Junglecoders advice from this thread
http://forum.civicrm.org/index.php/topic,10956.0.html
and edited
$query .=" ORDER BY   civicrm_event.start_date ASC limit 10";
in
CRM/Event/BAO/Event.php

Worked like a charm. The Line # was 82x. Search for "$query .=" ORDER BY" and you will find the right line, then just add the limit and number you'd like to display.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Drupal Modules (Moderator: Donald Lobo) »
  • To0 many events showing in Druapl View

This forum was archived on 2017-11-26.