CiviCRM Community Forums (archive)

Hi ,

i m using civicrm 3.3 in my application.i used to store the participant details in civicrm_participant table.

In Search Builder, to search the particpant details depending upon their status.

so i navigate to search builder page by using the url civicrm/contact/search/builder&reset=1.

In this page i selected the record type as "Participant" => "Participant Status" then operator type as "=" and value as 16(which is completed status)

It is showing all the contacts  instead of contacts with complete status.

Whereas i tried the similar one for searching the participant depending upon the Courses eg)  the record type as "Participant" => "Course Type" ,it works fine.

Can some one suggest with searching the participant based on the participant status ?

Hi Xavier,

Thanks for suggestion.

As my objective is to search  the number of participants  based on participant details  and Course Type to create a smart group.For this i will be using the || and && condition in Search builder

I believe,this would be feasible only in search builder while in participant search  and advance search ,combination of these conditions is not possible.

Could you advice on this please ?

Regards,
Sriraman.V

Hi,

As per your view , i confirm that field name in which details is updated in civicrm_participant is correct.

But this thing is working fine in Find Participants Screen.

i was Strange to know it doesn't work in Search Builder .Then i debugged the code and i found that "Participant Status" condition is not appended to the Query generated  where as for course type conditions is added and it is working.

Any Idea how to fix this issue ?

Regards,
Sriraman.v