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?