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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • profile listings filter
Pages: [1]

Author Topic: profile listings filter  (Read 2152 times)

anniekin

  • Guest
profile listings filter
October 26, 2007, 11:48:02 am
I can't seem to get profile listings to filter like step 9 in the wiki specifies here:
http://wiki.civicrm.org/confluence/display/CRM/Configure+CiviCRM+Profile#ConfigureCiviCRMProfile-9.ProfileSearch%2FListings

See this example:
http://demo.civicrm.org/drupal/civicrm/profile?reset=1&force=1&gid=7&state_province_id=1228

I've tried everything I can think of the field=value for state, ones that make sense and ones that don't... state-Primary=FL, state=FL, state_province_id=FL, State=FL, State=Florida, etc...

The field is searchable, the profile has been limited to a specific group, the field label is "State".
Anyone able to get a successful search or have ideas or more questions?

Thanks.




Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: profile listings filter
October 26, 2007, 03:35:59 pm
This is a bit tricky and I've added this example to that documentation to help others...

You need to use the exact name of the profile search field - which you can see by doing a View Source on the page. The field you're trying to filter on is named "state_province-Primary". You can use either the full name of the state OR the ID - but using the ID is preferred as it then selects the correct value in the search form field...

http://demo.civicrm.org/drupal/civicrm/profile?reset=1&force=1&gid=7&state_province-Primary=1008
Protect your investment in CiviCRM by  becoming a Member!

anniekin

  • Guest
Re: profile listings filter
November 01, 2007, 12:34:27 pm

Thanks Dave, I was able to configure everything I wanted to for my profiles. The "View Source" trick was exactly what I needed.

Another question, though-- where is the non-obsolete documentation describing this?  I can add to the page if it makes sense, but I'm having trouble finding it.

Thanks.
 
« Last Edit: November 01, 2007, 01:05:48 pm by annietm »

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: profile listings filter
November 01, 2007, 02:42:14 pm
The home page for all current documentation is linked from the top of every forum page:
http://documentation.civicrm.org/

... the specific page on linking profiles is here (I've updated it already - but if you think it needs more / better explanation - jump in!):
http://wiki.civicrm.org/confluence/display/CRMDOC/Linking+Profiles
Protect your investment in CiviCRM by  becoming a Member!

kenlyle

  • I post occasionally
  • **
  • Posts: 116
  • Karma: 7
Re: profile listings filter - SOLVED
January 16, 2008, 09:38:57 am
SOLUTION: http://forum.civicrm.org/index.php/topic,1437.msg8734.html#msg8734  Limit Listings to Group in the Profile.

Dave et al.,

Wow!  It's like being able to see the oasis, but not get a drink...

I have what seems like a complex situation in 1.9 where I have my Joomla users (sorry), and my Legislators in the same civicrm_contacts table.

I only want to display Legislators, which are contact_id < 141
Legislators also have either R, D, or I in their Source field, whereas users have NULL
Legislators have their District name/number like "59th" in legal_identifier

I am pretty sure that you would strip < from the URL, and contact_id is not found in the page source.  I tried searching with &contact_id=2, which exists, and it had no effect.

I added &source<>"" to a working URL, and it was apparently ignored, because I got the same list back.

Is there a syntax that works in this scenario for:

{field} = NULL
{field} = XYZ or {field} = PDQ
{field} <> XYZ

Thanks!
Ken
« Last Edit: January 16, 2008, 03:56:09 pm by kenlyle »

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: profile listings filter
January 16, 2008, 10:37:43 am
Ken - Have you looked at putting your Legislators in a Group, and then using the Profile Settings "Limit Listings to Group" which is described briefly here:
http://wiki.civicrm.org/confluence/display/CRMDOC/How+to+Create+Profiles

The syntax for doing a listing w/ preset search criteria is described here:
http://wiki.civicrm.org/confluence/display/CRMDOC/Linking+Profiles

... but frankly I haven't tried these in Joomla front-end pages - so not sure if you can set the query string params needed when creating the menu item. In any case - if you want a searchable listing of JUST legislators - the "limit to group" seems like the best approach.
Protect your investment in CiviCRM by  becoming a Member!

kenlyle

  • I post occasionally
  • **
  • Posts: 116
  • Karma: 7
Re: profile listings filter
January 16, 2008, 03:55:20 pm
YES! Joy in Mudville!  Limit Listings to Group is an Advanced Topic in the Joomla component, a property of the Profile.  Fortunately, I had created a separate profile for my Legislators that was largely redundant with the Contacts, but somehow seemed right.

LLtG is a beautiful thing.

This is Joomla 1.0.13 and CiviCRM 1.9.12432

THANKS!
Ken

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • profile listings filter

This forum was archived on 2017-11-26.