Custom query in a custom form is taking too long to return the field content after the form is loaded

Document ID : KB000077036
Last Modified Date : 07/03/2019
Show Technical Document Details
Issue:
Custom query in a custom form is taking too long to return the field content after the form is loaded
After restarting the Service Catalog services, the information is returned quickly

The query seems like:

"select ct.pri_phone_number as txtSoliTelefone, ISNULL(lo.location_name,'') as [txtSoliUnidade], de.name as txtSoliLotacao, %USER_ID% as testeĀ 
from ca_contact ct
left join ca_location lo on ct.location_uuid = lo.location_uuid
left join ca_resource_department de on ct.department = de.id
where userid = %USER_ID%"
Environment:
Service Catalog 14.1
Resolution:
The workaround for this case is to re-customize the form and use a different Form Type to implement que customized query.
It solved the problem