Thanks Marcos! That worked like a charm! Kim
On Thu, Nov 3, 2011 at 2:59 PM, Marcos Núñez <[email protected]> wrote: > Hi Kimberly! If by "concept search" you mean searching the concept > lists by name and storing its concept_id on a text widget bound to a > coded concept, try this for the external source of your widget: > > Instead of "concept" use something like "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". The issue is related to the way ids are > stored in coded concepts (thus the concat and the ^99DCT stuff). Also, > set Value field to "id" and Display Field to "name". > > If what you want is just to display the concepts and store them as > text, set the External source to "select distinct name from > concept_name" and the display and value fields to "name". > > > > 2011/11/3 Kimberly Hanson <[email protected]>: >> Hi all, >> >> I have a repeating concept search item in one of my forms, and since >> upgrading to xforms v 4.0.7 from v.3.8.7 i've been getting the >> following error when trying to enter anything in the field. i'm >> running openmrs v 1.8.2 and using firefox. any ideas on what might be >> causing this? thanks in advance! >> >> >> (ReferenceError): dojo is not defined >> stack: searchExternal("CONCEPT","a",[object >> HTMLTableRowElement],[object HTMLDivElement],[object >> HTMLInputElement],"DRUG")@http://localhost:8080/openmrs/admin/encounters/encounter.form?encounterId=7422:647 >> dEb([object >> Object])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1945 >> $s([object >> Object])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1939 >> Tv([object Object],[object >> Object])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1759 >> Xv([object Object],[object >> Object])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:888 >> Fv([object Object],[object >> Object])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1330 >> SP([object Object],[object >> Object])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:698 >> Wq([object KeyboardEvent],[object Object],[object >> HTMLInputElement])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1430 >> VP([object Object],[object >> KeyboardEvent])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1312 >> t5([object Object],[object >> KeyboardEvent])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1233 >> B5([object >> KeyboardEvent])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1942 >> oM([object KeyboardEvent],[object HTMLInputElement],[object >> Object])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1176 >> ([object >> KeyboardEvent])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1919 >> Fk((function (b) {var c, d = this;while (d && !(c = d.__listener)) {d >> = d.parentNode;}d && d.nodeType != 1 && (d = null);c && UN(c) && oM(b, >> d, c);}),[object HTMLInputElement],[object >> Object])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1658 >> ([object >> KeyboardEvent])@http://localhost:8080/openmrs/moduleResources/xforms/formrunner/F1D1A821A01F12F3E7B0BD51ED2F3D66.cache.html:1189 >> >> fileName: >> http://localhost:8080/openmrs/admin/encounters/encounter.form?encounterId=7422 >> lineNumber: 647 >> >> >> -- >> Kimberly Hanson >> Data Informatics Program Lead >> Global Brigades Honduras >> Personal email: [email protected] >> HND mobile: +504-9822-2438 >> Skype: kmhanson86 >> www.globalbrigades.org >> >> _________________________________________ >> >> 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] >> > > _________________________________________ > > 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] > -- Kimberly Hanson Data Informatics Program Lead Global Brigades Honduras Personal email: [email protected] HND mobile: +504-9822-2438 Skype: kmhanson86 www.globalbrigades.org _________________________________________ 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]
