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

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!

Outcomes