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) »
  • Profile Listing and Search giving Array error for custom multiselect
Pages: [1]

Author Topic: Profile Listing and Search giving Array error for custom multiselect  (Read 3660 times)

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Profile Listing and Search giving Array error for custom multiselect
October 14, 2008, 10:03:10 pm
Scenario

Anon Users have
- Access all Custom Data
- Profile Listing and Forms


Issue 1
when i use eg /civicrm/profile&reset=1&force=1&gid=1&city=wellington I end up seeing all my contacts not just those in Wellington

Issue 2
when I include custom data that is set to
- searchable'
in a profile that is set to
- searchable
- in selector
- public page and listings'
and choose one of the multiselect or checkboxes I am getting a message
"No matches found for: <custom field> LIKE Array"


Yet a search using 'State' in the same Profile for example delivers the records I expect.

As does a Select type Custom Data field.

I note the 'use sql or' is showing up in the multiselect and checkboxes (which is good) but might it be contributing to the problem???

Issue 3 - possibly related - in Custom Data, when I set a field to be "Is this Field Searchable?"and Save, and then open the Field again the tickbox is unchecked (tested on your sandbox) - though it does seem to set the field to be in Advanced Search.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Profile Listing and Search giving Array error for custom multiselect
October 14, 2008, 10:05:07 pm
Oh yes, the Custom Data was set up for CONTACTS. Presume that was okay since it works for the select type fields.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Profile Listing and Search giving Array error for custom multiselect
October 14, 2008, 10:17:38 pm
Just set up and tested on demo

http://drupal.demo.civicrm.org/civicrm/profile?reset=1&gid=5

PD Test: Test checkbox   One Two Use SQL OR - FAILS
PD Test: Test multiselect   - FAILS
PD Test: Test select - WORKS

So maybe this is more a bug than a user error, or am I just bending things the wrong way?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Profile Listing and Search giving Array error for custom multiselect
October 14, 2008, 10:30:08 pm
And just tested on our test 2.0 and it works fine. Sorry guys. Looks like a bug.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

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: Profile Listing and Search giving Array error for custom multiselect
October 14, 2008, 10:52:43 pm
For tracking purpose: http://issues.civicrm.org/jira/browse/CRM-3705
This is fixed and will be part of next CiviCRM v2.1 release. also updated demo.

Kurund
« Last Edit: October 14, 2008, 11:37:42 pm by Kurund Jalmi »
Found this reply helpful? Support CiviCRM

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Profile Listing and Search giving Array error for custom multiselect
November 19, 2008, 05:04:22 pm
Quote from: peterd on October 14, 2008, 10:03:10 pm
Issue 1
when i use eg /civicrm/profile&reset=1&force=1&gid=1&city=wellington I end up seeing all my contacts not just those in Wellington

For folks who find this and want to do something similar.... you need to use the exact field name as shown in the profile search form if you want to force a search on a specific field. The URL above should have "city-1" or similar value rather than just "city" (depending on which location type is used in the profile).

Code: [Select]
/civicrm/profile&reset=1&force=1&gid=1&city-1=wellington
Protect your investment in CiviCRM by  becoming a Member!

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Profile Listing and Search giving Array error for custom multiselect
November 19, 2008, 11:46:34 pm
Thanks - is there an obvious source of what city-1 and city-2 are ie which locations are what code?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

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: Profile Listing and Search giving Array error for custom multiselect
November 20, 2008, 03:13:55 am
Quote
is there an obvious source of what city-1 and city-2 are ie which locations are what code?

city-x, where 'x' is location type id. And you can do a view source on your Profile search form to see the field names.

Kurund
« Last Edit: November 20, 2008, 11:05:08 am by Dave Greenberg »
Found this reply helpful? Support CiviCRM

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Profile Listing and Search giving Array error for custom multiselect
November 20, 2008, 11:47:40 am
"View source" of course thanks.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Profiles (Moderator: Dave Greenberg) »
  • Profile Listing and Search giving Array error for custom multiselect

This forum was archived on 2017-11-26.