I am trying to create a text box able to search all the diagnosis of the CIEL dictionary. In order to do this, I am writing the following in the text box in Xforms:
External Source: select distinct cn.name, concat(cn.concept_id,concat(concat(’^’,name),’^99DCT’))
as concept_id from concept_name cn inner join concept c on c.concept_id=cn.concept_id
where class_id=4
Value Field: concept_id
Display Field: name
When I am searching throughout “Finding” and therefore I use class_id=5, I can found all the correct concepts. However, using class_id=4 and therefore looking for “Diagnosis”, nothing appears. I think it is probably because there are too many concepts within the class “Diagnosis”.
Am I doing something wrong? Any better solution for achieve this?
Sorry for taking so much answering, I am not responsible for the server, so I have always to contact someone else.
What I gave to you was in the file “catalina.out”.
Anyway, I did not find anything in the logs. If you have the kindness to check for yourself, I am providing you the logs of today here:
http://www.■■■■■■■■■■■■■■■/openmrs
Should be easy for you to find what you want since today I just tried to search in the searchbox 3 times (around 12h30min). I did not make anything else in OpenMRS, so the logs are quite small.