Author Topic: Custom search - Event Aggregate update (Read 3687 times)

Eileen · August 25, 2008, 09:03:35 pm

Hi there,

The custom search Event Aggregate recently uploaded doesn't appear to work - if I try to search for event type fundraisers I only get one participant in one event

http://sandbox.civicrm.org/civicrm/contact/search/custom?csid=7&reset=1

http://issues.civicrm.org/jira/browse/CRM-3433

I'm not sure if this is because of the difference between 2.0 & 2.1 or a change made during the tidy up.

NB with regards to the tidy up - it was made at the cost of some functionality. I'll explain how I use the search to clarify why I put the functionality there (even though I'm the first to admin to flaws in the presentation - described on the wiki.)

1) firstly I run the search with no values entered. This gives me an aggregate of each event type. I match these aggregates against the accounts *** I think this function has been removed ****

2) if one or more doesn't match I check that box to narrow it down to that event type. This gives me the aggregates for all the individual events which I match against the accounts *** this is still there ***

3) I then select the individual event/s that doesn't match & chose the 'show participants' option so I can check the individual registrations in the event to find the discrepancy. *** the show participants option has been removed. ****

Kurund Jalmi · August 28, 2008, 03:24:33 am

As mentioned on the wiki:

Quote

- summarisation by event type
- summarisation by event
- option to only show credit card payments

Above stuff is done.

Quote

- listing of participants within an event

This cannot be done. Mainly because criteria used for this search is different. So list of participant may not actually match result shown by this custom search.

Hope i am clear ..

Kurund

Eileen · August 28, 2008, 06:43:05 pm

Hi there,

I'm a bit confused. When I use the search on the sandbox:

http://sandbox.civicrm.org/civicrm/contact/search/custom?csid=7&reset=1

I don't seem to be able to return a result - no matter what criteria I enter or if I don't enter any.

Also, I'm wondering if the reason :

Quote

- listing of participants within an event

won't work is a change in 2.1. Obviously you should put whatever code in the release you think most appropriate but I need to know if I'm not going to be able to change it back to how it works in 2.0.5 because I use that functionality all the time. (if works in the code I posted)

( as per http://wiki.civicrm.org/confluence/pages/viewpageattachments.action?pageId=6750499 )

Kurund Jalmi · August 29, 2008, 01:59:21 am

Quote

http://sandbox.civicrm.org/civicrm/contact/search/custom?csid=7&reset=1
I don't seem to be able to return a result - no matter what criteria I enter or if I don't enter any.

This is because there is not data or participant records on the sandbox. Now i have added participant record for one event.

Regarding to Listing of Participants.
- We can give general list of participant related to particular event like http://sandbox.civicrm.org/civicrm/event/manage?reset=1
But we won't be able to give list of participants according to search criteria.

HTH

Kurund

Eileen · August 29, 2008, 02:06:08 am

OK - I can see that record - but I'm still missing something - what is the difference between a participant record & the records I see on this page:

http://sandbox.civicrm.org/civicrm/event/search?reset=1&force=1&event=1&status=true

Kurund Jalmi · August 29, 2008, 02:37:07 am

Quote

http://sandbox.civicrm.org/civicrm/event/search?reset=1&force=1&event=1&status=true

This link displays all the participant registered for "Fall Fundraiser Dinner" AND Participant Status is "Registered" or "Attended".

Here there is not differentiation between participant who have paid using Credit Card or any other payment instrument.

Kurund

Eileen · August 29, 2008, 02:41:58 am

So, shouldn't they show in the Event Aggregate search unless the only show credit card payments box is ticked? I've logged onto Mibbit if it's easier for you to explain to me there

Kurund Jalmi · August 29, 2008, 02:58:44 am

Quote

So, shouldn't they show in the Event Aggregate search unless the only show credit card payments box is ticked?

It is possible. We will have modify participant link based on each criteria.

Kurund

Kurund Jalmi · August 29, 2008, 03:58:44 am

As per discussing on #civicrm, i have updated http://sandbox.civicrm.org/civicrm/contact/search/custom?csid=7&reset=1

let me know if anything is missing.

Kurund

Eileen · September 01, 2008, 02:26:41 am

Hi,

I'm still not seeing any results in the query - perhaps I should download it & try it on 2.0 - will it work on that?

Kurund Jalmi · September 01, 2008, 10:53:17 am

Do add some event registration and check again.

Kurund

Eileen · September 10, 2008, 03:19:45 am

Hi,

I just downloaded it this search and tried it on my 2.0 install. There's a discrepancy between the figures I get using my version and using your version but it will take a bit of time to figure out why as I have to work a bit harder to get the information I need in your version.

I think your version looks nice but to be honest I will probably revert back to mine because it still allows me to get more information out of it. However, I don't expect you to change it to suit me - I'd just like to make sure the version that goes out gives correct results.

For the records here's how mine differs
Default search

	Sandbox	Mine

Default Search	Shows all events on individual lines with a total for each event	Shows all event types on individual lines with a total for each event type (to get this in the Sandbox version you need to check every event type sandbox)

One or more Event Type check boxes selected	Shows selected event types on individual lines with a total for each event type	Shows all events of that type on individual lines with a total for each event

Show payees checked (e.g. one event chosen with payees ticked)	SHows the selected event & total on one row. Lists participants names (only) in right hand column	Shows each participants that meet search criteria on a different line. Total for that participant in that event is given. (In some circumstances I would have more than one contribution for the same participant in one event - these are aggregated)

To figure out why the total for event type 2 is different between the two searches on the sandbox version I will need to individually select each event of event type 2 to get each total. ie. I will need to run the query 10 times whereas on my version I will run it once - with just the event type selected. Once I know which event has the discrepancy I don't know how I will determine which participant it relates to on your version but on mine I will tick 'show payees'.

Eileen · September 10, 2008, 03:33:51 am

Actually there's a slightly more serious problem - it seems I can only select current events on the sandbox version so I can't get information about finished events to figure out where the problem is.

Eileen · September 11, 2008, 02:54:54 am

Sussed it - the discrepancy is the participant status - I had 'in 1,2' but the new one has 'in 1'.

I think 2 is attended - we have some enrolments which are set to attended where they have paid up but perhaps this is not the norm and I hope not to have any more created.

I have recovered the functionality I wanted by changing the group by clause (line 143 approx) to

$groupBy = "event_type_id";
if ( ! empty($this->_formValues['event_type_id'] ) ) {
$groupBy = "event_id";
      }
     if ( $showPayees ) {
          $groupBy = "civicrm_contact.id";
}

The events listed is still an issue though - it only lists current events not past ones. I think a check box would be better than the select box too on balance - as I can see circumstances when I'd want to select more than one.

Kurund Jalmi · September 11, 2008, 04:09:41 am

Quote

The events listed is still an issue though - it only lists current events not past ones. I think a check box would be better than the select box too on balance - as I can see circumstances when I'd want to select more than one.

- fixed, http://fisheye.civicrm.org/changelog/CiviCRM-2-1/?cs=17033

Kurund

CiviCRM Community Forums (archive)

News:

Author Topic: Custom search - Event Aggregate update (Read 3687 times)

Eileen

Custom search - Event Aggregate update

Kurund Jalmi

Re: Custom search - Event Aggregate update

Eileen

Re: Custom search - Event Aggregate update

Kurund Jalmi

Re: Custom search - Event Aggregate update

Eileen

Re: Custom search - Event Aggregate update

Kurund Jalmi

Re: Custom search - Event Aggregate update

Eileen

Re: Custom search - Event Aggregate update

Kurund Jalmi

Re: Custom search - Event Aggregate update

Kurund Jalmi

Re: Custom search - Event Aggregate update

Eileen

Re: Custom search - Event Aggregate update

Kurund Jalmi

Re: Custom search - Event Aggregate update

Eileen

Re: Custom search - Event Aggregate update

Eileen

Re: Custom search - Event Aggregate update

Eileen

Re: Custom search - Event Aggregate update

Kurund Jalmi

Re: Custom search - Event Aggregate update