AnsweredAssumed Answered

Fetch data when Catalog form load

Question asked by pcpolo on Jun 13, 2017
Latest reply on Jun 14, 2017 by pier-olivier.tremblay

Hi Community,

I want to load user data (requester_user) when user create a new ticket in catalog.

I already have a data object with the query:

 

SELECT c.userid, CONVERT(varchar(32), l.location_uuid, 2) AS location_id,
l.location_name AS loc_name
FROM ca_location l INNER JOIN ca_contact c on l.location_uuid=c.location_uuid
WHERE upper(userid) like upper('%STRING%%%')

 

And a lookup field in my form that fetch this query. In lookup field value property I got $(_.user.id) but when user create the ticket the lookup field still want to search the userid to fetch data from query.

 

Any form to fetch data from the query when form load?

 

Regards,

Pedro

Outcomes