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) »
  • Strange State Field Behaviour
Pages: [1]

Author Topic: Strange State Field Behaviour  (Read 1165 times)

Pewit

  • Guest
Strange State Field Behaviour
March 23, 2008, 11:02:11 pm
I have just started to evaluate CiviCRM 1.9.1 on Joomla for our international organisation.

I started to enter my own information and noted that when you select the Country=Australia the dropdown for States doesn't include Victoria yet it is included in the mySQL database  - the civicrm_state_province table includes Victoria for country_id 1013 (which is Australia).

However, if you start to type the letters of Victoria (e.g. "Vic"), it then appears in the dropdown.

I've noted the references to performance issues with this field - is this connected?

Regards

Paul White

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: Strange State Field Behaviour
March 23, 2008, 11:32:50 pm
Paul,

I guess you are using Contact Edit form. We use ajax (dojo widget) for populating states and country. So in state and country by default we display only top 5 record sorted by alphabetical order. Hence "Victoria" is not shown by default.

As you type any letter(eg. "Vic") we then display top 5 records matching that criteria are shown. So Victoria was included in the list.

I hope i am clear...

kurund
Found this reply helpful? Support CiviCRM

Pewit

  • Guest
Re: Strange State Field Behaviour
March 26, 2008, 01:05:43 am
OK thanks. Now I understand.

Can you specify in the properties of the widget how many state records are displayed?

Regards

Paul

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Strange State Field Behaviour
March 27, 2008, 05:52:10 am
The number of records to be displayed can be configured here

CRM/Core/Page/AJAX.php

around line No. 336
 
Code: [Select]
while ( $dao->fetch( ) && $count < 5 ) {

HTH
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Strange State Field Behaviour

This forum was archived on 2017-11-26.