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]

