Author Topic: Basic/Advanced Searching  (Read 169 times)

Offline zoemax

  • I’m new here
  • *
  • Posts: 3
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: WordPress 3.3.2
  • MySQL version: unknown
  • PHP version: unknown
Basic/Advanced Searching
« on: June 22, 2012, 06:49:52 am »
Greetings. Newbie is having issues building searches ( using checkbox values)

Background.
2 Profiles are being used  ( Volunteer & Rider ).  They both have 'checkbox' for availability

Volunteer Data:
Labels consist of [monday/tuesday..etc] [mornings/afternoon/evenings]  - VALUES are as mon_9_12, mon_12_5, mon_5_7.. etc

Rider Data
Labels consist of [weekday/saturday][before/after 2PM] - VALUES are" weekday_[pre/post]_2, and saturday_[pre/post_2]


I can't seem to get any searches to work.

Search Builder matching (=) with the exact value = zero results
Search Builder matching ( LIKE %_12 ) = zero results

Advance search with the 2 checkbox's ticked return zero results.
I've verified my data for test records, I have the correct boxes checked, but I can't seem to get any results.

Anybody have any hints on how to further troubleshoot?

Advanced Search Typical Error:No matches found for:
Volunteer Availability = Monday Mornings (9-12PM) ( match ALL ) ...AND...
Rider: Preferred Times For Lessons/ Availibility = Weekday before 2PM ( match ALL )

OR

No matches found for:
Volunteer Availability = Monday Mornings (9-12PM) ( match ANY ) ...AND...
Rider: Preferred Times For Lessons/ Availibility = Weekday before 2PM ( match ANY )
« Last Edit: June 22, 2012, 07:11:43 am by zoemax »