Query to display additional field associations with templates
Use case
The reports shows in which templates the created additional fields are associated
Query
select sd.name "Service Catalog Name",
rt.templatename "Template name",
fc.field_name "Fields" from requesttemplate_list rt
left join servicedefinition sd on sd.serviceid = rt.parent_service
left join form_customizer fc on fc.form_name = ('WorkOrder_' + rt.templatename)
where fc.index_tech >= 0 and fc.field_name='udf_sline_901'
order by 1
Go to Admin >> Service Catalog - Additional Fields/Incident - Additional Fields >> Note the API name for the additional field and replace it with the highlighted text in the query
DB: MSSQL
Filter: None
Sample Table
New to ADSelfService Plus?
Related Articles
Script to Populate User Additional Field under Incident Template using FAFR
The script load the Requester Name under Incident Additional field ( As a pick list), by choosing the requester name under additional field the script populates the user additional field value. * Kindly create two additional fields under Admin -> ...Query to find the time taken to assign a field
Use case The query will pull a report of when an additional field was first assigned a value DB: MSSQL Query Please replace additional field name with the Field Name Here. SELECT "wo"."WORKORDERID" AS "Request ID", "ad"."ORG_NAME" AS "Account", ...Query to show account additional fields _ Details required
We Need to know whether that is a common account additional fields or add attribute under individual account. So please send us the following screenshots. 1. Admin-> Account additional fields list view page. 2. Accounts->Edit account and show the ...Query to fetch the fields in the templates
The query fetches all the fields with display name used across Request templates PQSQL: select Distinct (CASE when fc.field_name like 'udf_%' then ca.aliasname else fc.field_name END) "Fields", rt.templatename "Template name" , sd.name "Service ...Query to show difference between current and previous value of a Date additional field
MSSQL: SELECT "wo"."WORKORDERID" AS "Request ID", "mdd"."MODENAME" AS "Request Mode", "qd"."QUEUENAME" AS "Group", "aau"."FIRST_NAME" AS "Requester", "cd"."CATEGORYNAME" AS "Category", "scd"."NAME" AS "Subcategory", "wo"."TITLE" AS ...