Custom query in a custom form is taking too long to return the field content after the form is loaded
Article ID: 77036
Updated On:
Products
SUPPORT AUTOMATION- SERVER
CA Service Desk Manager - Unified Self Service
KNOWLEDGE TOOLS
CA Service Management - Asset Portfolio Management
CA Service Management - Service Desk Manager
Issue/Introduction
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%"
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
It solved the problem
Feedback
Yes
No
Powered by
