AnsweredAssumed Answered

Help on Lookup Field

Question asked by diegojacob on Aug 22, 2018
Latest reply on Aug 30, 2018 by Louis_van_Amelsfort

Hi guys,


I'm having some difficulties creating a lookup field to bring users from SDM in order to notify this contact contained in this field.


I created the data object for use in ca_fdDoFieldLookup according to the query below:


ID: caContactPlugin

Database: mdb

Table: ca_contact

Fields: value, label


select contact_uuid as value, last_name as label from mdb.dbo.ca_contact where userid is not null


In the form i created a lookup field with the following attributes:


_id: ca_sdm_attr_z_SuperiorImediato (this custom attribute is a SREL from the cnt factory)

onLookup: ca_fdDoFieldLookup ('last_name', 'caContactPlugin')


When I select the field to view the values it does not give me a search option or even allows users to search with the value entered in the lookup field.


Is there anything I should do besides creating this query and making the field available?


Bellow the form and popup lookup field:




Many thanks for your help!