Hi Marcos,

Can you get on IRC and we walk through this together?


On Fri, Aug 19, 2011 at 8:24 AM, Marcos Núñez <[email protected]> wrote:

> UPDATE: I could partially solve the issue, the fault seems to involve the
> number of values to display. My table has 24 provinces, 420 districts and
> about 15000 cities.
>
> Changing
>
> PROVINCE=>External Source= addresses, Display Field=province, Value
> Field=province
> DISTRICT=>External Source= addresses, Display Field=district, Value
> Field=district, Filter Field=province
> CITY=>External Source=adresses, Display Field=city, Value Field=city,
> Filter Field=district
>
> PROVINCE=>External Source= *select distinct province from addresses,* Display
> Field=province,
>  DISTRICT=>External Source= *select distinct district from addresses*,
> Display Field=district, Value Field=district,
> CITY=>External Source=*select distinct city from addresses*, Display
> Field=city, Value Field=city,
>
> allows the Display Field to show the 24 provinces instantly. Similary
> occurs with the 420 districts. The cities are just too many, it takes about
> a minute to load them, but eventually they do. The logical thing to do would
> be to apply the Filter Field now to both Districts and Cities. However,
>
> PROVINCE=>External Source= *select distinct province from addresses,* Display
> Field=province,
> DISTRICT=>External Source= *select distinct district from addresses*,
> Display Field=district, Value Field=district, *Filter Field=province*
> CITY=>External Source=*select distinct city from addresses*, Display
> Field=city, Value Field=city, *Filter Field=district*
> *
> *
> does not display neither districts nor cities.
>
> Any idea as to why?
> ------------------------------
> Click here to 
> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-implement-l>from
>  OpenMRS Implementers' mailing list
>



-- 
If we keep uppermost in our minds the unkind and unjust acts of others, we
shall find it impossible to love them as Christ has loved us; but if our
thoughts dwell upon the wondrous love and pity of Christ for us, the same
spirit will flow out to others.

_________________________________________

To unsubscribe from OpenMRS Implementers' mailing list, send an e-mail to 
[email protected] with "SIGNOFF openmrs-implement-l" in the  body 
(not the subject) of your e-mail.

[mailto:[email protected]?body=SIGNOFF%20openmrs-implement-l]

Reply via email to