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
Query:
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!