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? _________________________________________ 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]
