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 Profiles (Moderator: Dave Greenberg) »
  • Search with optionlists
Pages: [1]

Author Topic: Search with optionlists  (Read 2266 times)

airwaves

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 1
Search with optionlists
October 01, 2009, 09:35:19 am
Hello,

I made a custom field of the type Alphanumeric > Select. Aprx 60 items
Then I created a profile for searching with that custom field and made it searchable and available in results column. (next to a few others)

When I open the url in J. frontend to search for the members of the custom field, I can make a selection in the drop-down-list (of those 60 items), but after hitting search. I don't get the records that correspond with the selection. I get a list I can't understand. (I don't see any logic in it).

So I have 4000 members and all of them have their custom field filled with the a value (let say the color of their hair). Now I want to search members with color hair "red"
The actual value in the DB for color hair is a number (red = 3). In the multiple choice options is red also 3.

Am I seeing somthing wrong here. What am I doing wrong?

I use 2.2.9 with Joomla

Edwin.

airwaves

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 1
Re: Search with optionlists
October 08, 2009, 11:11:10 am
Maybe I'll wasn't clear enough wat is going wrong.

When a front-end users makes a search and selects an Item in the civi search form (hair color Red).
The result that is display are all members with red hair, but also a few other colors.

I tried to simulate this in the demo, but i'm not able to make a frontend search from.


Is this a bug?



Edwin.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Search with optionlists
October 08, 2009, 12:10:00 pm
I created a front-end Profile search on the Joomla demo and included a radio-button style custom field:
http://joomla.demo.civicrm.org/index.php?option=com_civicrm&view=Profiles&layout=search&Itemid=7

... you can modify the profile / add a custom field similar to yours to see if you can recreate the issue.

Note: Do review how that Profile Search is setup via Joomla Menu Manager. Directions are here:
http://wiki.civicrm.org/confluence/display/CRMDOC/Configuring+Front-end+Profile+Listings+and+Forms+in+Joomla%21+Sites
Protect your investment in CiviCRM by  becoming a Member!

airwaves

  • I post occasionally
  • **
  • Posts: 40
  • Karma: 1
Re: Search with optionlists
October 09, 2009, 01:18:10 am
I created the test in the J. demo. In the frontpage you see a "Search Dropdown"  menu item.
If you search for a color (try red) The results are strange. I would expect only the record with "red"

What I did.
I created a csv with 12 usernames

last   color   dropdown list nr
ediwn   red   1
hans   green   2
piet   orange   3
klaas   blue   4
john   light blue  5
peter   violet   6
su   black   7
wilhem   white   8
daz   purple   9
Bill   brown   10
Cruz   pink   11
Johannes   gray   21

Created a custom field (alpha and select) and a profile to search te custom field.

In 2.2.9 I have the same results.


Results from frontpage


Dropdown test profile
New Search
Displaying contacts where:
Color LIKE red

Name                    Color       First Name   Lastname   
Bill,brown                brown   brown   Bill              View  
Cruz, pink               pink           pink           Cruz              View  
ediwn, red               red           red           ediwn            View  
Johannes, gray        Gray      gray           Johannes   View  


Somethings wrong here.


Edwin
« Last Edit: October 09, 2009, 07:53:36 am by airwaves »

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Search with optionlists
October 09, 2009, 04:51:57 pm
Edwin:

This is a bug in profile search. I have filed an issue for this http://issues.civicrm.org/jira/browse/CRM-5213

Thanks

Kurund
Found this reply helpful? Support CiviCRM

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Search with optionlists

This forum was archived on 2017-11-26.