Support

Home Forums Event Espresso Premium Live Search Not showing Attendees

Live Search Not showing Attendees

Posted: December 19, 2013 at 10:36 am


Al Joly

December 19, 2013 at 10:36 am

When I click on all attendees then search for an attendee, nothing comes up when we now the person exists. Then if we go directly to the event they attendeed we can see them. Is there a reason the live search does not search “All Attendees”. Or is there a specific way in which it works?


Jonathan Wilson

December 19, 2013 at 12:36 pm

Hello Al,

Can you try changing the filters to Show All Complete/Incomplete and let us know whether that works?


Al Joly

December 19, 2013 at 1:54 pm

If I go to Event Overview -> All Attendees -> Filter by All Complete/Incomplete then search the first name, he does not come up.

But if I go to Event Overview -> All Attendees -> Filter by Month -> Then Filter by Category -> Then search first name, he appears.

The issue is, in this case we know the month and category, but sometimes we may only have the name. So if we go to “All Attendees” and search, we expect to be able to search for any other the attendees.


Jonathan Wilson

December 19, 2013 at 2:22 pm

Hi Al,

I’m going to test this on my testing site. Just need some info from you. Has the event passed? What was the payment status? Is this happening for all attendees?


Al Joly

December 19, 2013 at 3:41 pm

The event is passed, completed payment.
It isn’t all, for example if I go to all attendees, and search for a name i see in the list shown it filters to that name.


Al Joly

December 19, 2013 at 4:11 pm

I have sent in details (diff ticket) to our dev site, you’be be able to replicate there if you want.


Tony

  • Support Staff

December 20, 2013 at 2:47 am

Hi Al,

Can you go to Event Overview (Do not click All Attendees) http://d.pr/i/x3b7

Now setup the status filter to ‘All (Active/Inactive)’ and the DB retrieval field to ‘All’ then click filter status. http://d.pr/i/dvhX

Now click the All attendees button and search http://d.pr/i/3CNs

Does the attendee show now?

*Edit just remembered how many attendee’s you have, the above may result in a white screen


Dean

December 20, 2013 at 3:48 am

Hi,

I logged in and did some random testing and couldn’t see any issues. Could you provide a specific name or two that you are struggling to see, so we can test those please?


Al Joly

December 20, 2013 at 1:24 pm

Name: Yaman
Event Date: Dec 14


Tony

  • Support Staff

December 21, 2013 at 1:17 pm

Hi Al,

I logged in and could find that attendee, although it is a little confusing. Using the the steps from my previous reply, plus a slight change at the end.

If you go to Event Overview (Do not click All Attendees) http://d.pr/i/x3b7

Now setup the status filter to ‘All (Active/Inactive)’ and the DB retrieval field to ‘500’ then click filter status.

*This loads all the events from the database, and the total number of attendees.

Now click the All attendees button.

Now this is were I think it is a little confusing.

Although it would seem you are searching all attendees your actually not. You are searching however many rows of attendees you have set to retrieve (in this case due to 500 above), so we are searching through 500 attendees out of the total number of attendees, the ‘Next 500 Rows’ button pulls the next 500 rows for the live search to search through and so on.

You can test this by setting the number to 250, and pressing Retrieve. The attendee will not be found, click ‘Next 250 Rows’ and they will be.

I do think its rather confusing and have created a ticket to see what can be done to improve on this.

Now the solution would be to select ‘All’ and then retrieve, allowing you to search all attendees. Problem is this your server can’t handle 30,000 attendees at once.

Next problem is that 500 rows is currently the max for the dropdown other than ‘All’.

30,000/500 = 60 so worse case scenario to find an attendee you would need to retrieve the next set of rows 60 times.

You can change the rows EE retrieves to a higher number (say 5000) which reduces the amount of times you’d need to retrieve the rows to 6. However, each time you retrieve the rows it will take a little time to pull in all the information.

If you go to event-espresso/includes/admin-files/admin_reports_filters.php line 269

$rows = array( 5=>5, 50 => 50, 100 => 100, 250 => 250, 500 => 500, 100000 => 'all' );

Add a number of rows to retrieve, say 5000.

$rows = array( 5=>5, 50 => 50, 100 => 100, 250 => 250, 500 => 500, 5000 => 5000, 100000 => 'all' );

You can then select that from the drop down and see how the page responds. Try upping the number and see how the page responds or if it takes too long to retrieve the info.

The other option would be to write a custom query to search the attendees database based on a given input (attendee name for example) then display that single attendee. However this is not currently something EE supports so would require custom development.


Al Joly

December 23, 2013 at 10:12 am

We had imported 29,000 attendees. So technically we could remove those (using an alternate method to view them)

Then this would work (without searching 500 at a time), But eventually we will run into the same issue again, in say 6-12 months.

The support post ‘Live Search Not showing Attendees’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso