Layton ServiceDesk - Settings - Global List View - End User Request
m (Minor edits) |
(Added section "Restoring the Change Request Status Button") |
||
Line 16: | Line 16: | ||
The column will disappear from the request list view. | The column will disappear from the request list view. | ||
+ | |||
+ | ==Restoring the Change Request Status Button== | ||
+ | |||
+ | Restoring the button requires a SQL query. Note that this will reset all the columns, so any changes you've made other than the removal of the Change Request Status button will be lost. | ||
+ | |||
+ | #Connect to the LaytonServiceDesk database in SQL Server Management Studio. | ||
+ | #Click the New Query button. | ||
+ | #Choose ''LaytonServiceDesk'' in the Available Databases drop-down menu. | ||
+ | #Copy and paste the following query into the query field and execute it: | ||
+ | |||
+ | UPDATE resultsetprofile | ||
+ | |||
+ | SET sys_resultsetprofile_xml = ' | ||
+ | <request pagecolor="#EEEEEE" toolboxtop="48" toolboxleft="1488" table="request" backimg="" height=""><label1 top="32" left="536" font-family="Verdana" font-size="18" color="#003366" font-bold="false">{{request}}s</label1><filter1 font-family="Verdana" font-size="11" color="#000000" userreq="false" caption="" tabindex="" left="872" top="24" width="300">Requests Filter</filter1><resultset top="72" left="24" maxrows="18" width="1149" height=""><field1 heading="ID" font-family="Verdana" font-size="11" color="#000000" width="5%" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="left" headingalign="left">sys_request_id</field1><field4 heading="Date" font-family="Verdana" font-size="11" color="#000000" width="15%" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="left" headingalign="left">sys_requestdate</field4><field2 heading="{{requesttype}}" width="19%" font-family="Verdana" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="left" headingalign="left">sys_requesttype_id</field2><field5 heading="Problem Summary" font-family="Verdana" font-size="11" color="#000000" width="18%" align="left" headingalign="left">sys_problemsummary</field5><field6 heading="Priority" font-family="Verdana" font-size="11" color="#000000" width="10%" align="center" headingalign="center">sys_requestpriority</field6><field3 heading="Status" width="10%" font-family="Verdana" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center">sys_requeststatus</field3><actionlink width="5%" heading="" font-family="verdana, arial, sans-serif" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="~/Application_Images/16x16/tasks_16.png" linkhasitemsimg="~/Application_Images/16x16/task_hasitems.png" linkinactiveimg="" linkimgalt="{{action}}s" linkhasunreaditemsimg="">View</actionlink><commentlink width="5%" heading="" font-family="verdana, arial, sans-serif" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="~/Application_Images/16x16/Comments_16.png" linkhasitemsimg="~/Application_Images/16x16/Commentshasreaditem16px.png" linkinactiveimg="" linkimgalt="{{comment}}s" linkhasunreaditemsimg="~/Application_Images/16x16/Commentshasunreaditem16px.png">Comments</commentlink><attachlink width="5%" heading="" font-family="Verdana" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="~/Application_Images/16x16/attach_16.png" linkhasitemsimg="~/Application_Images/16x16/attachhasitems_icon_16px.png" linkinactiveimg="" linkimgalt="" linkhasunreaditemsimg="">Attachment</attachlink><opencloselink width="5%" heading="" font-family="verdana, arial, sans-serif" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="application_images\16x16\Request_Open.png" linkhasitemsimg="" linkinactiveimg="" linkimgalt="" linkhasunreaditemsimg="">Open Close</opencloselink></resultset></request> | ||
+ | ' | ||
+ | |||
+ | WHERE sys_resultsetprofile_id = 'enduserrequest' | ||
+ | |||
+ | Now the default column configuration has been restored. |
Revision as of 06:24, 26 August 2013
Removing the Change Request Status Button
The End User Request form has four buttons by default:
Tasks
Comments
File:Button attachment 16.png Attachments
Change Request Status
To remove a button:
- Go to Administration > Global List Views > End User Request.
- Click any Change Request Status button. A settings page will open.
- In the settings, change the Column Width to 0 Pixels. Click Save.
The column will disappear from the request list view.
Restoring the Change Request Status Button
Restoring the button requires a SQL query. Note that this will reset all the columns, so any changes you've made other than the removal of the Change Request Status button will be lost.
- Connect to the LaytonServiceDesk database in SQL Server Management Studio.
- Click the New Query button.
- Choose LaytonServiceDesk in the Available Databases drop-down menu.
- Copy and paste the following query into the query field and execute it:
UPDATE resultsetprofile
SET sys_resultsetprofile_xml = ' <request pagecolor="#EEEEEE" toolboxtop="48" toolboxleft="1488" table="request" backimg="" height=""><label1 top="32" left="536" font-family="Verdana" font-size="18" color="#003366" font-bold="false">Template:Requests</label1><filter1 font-family="Verdana" font-size="11" color="#000000" userreq="false" caption="" tabindex="" left="872" top="24" width="300">Requests Filter</filter1><resultset top="72" left="24" maxrows="18" width="1149" height=""><field1 heading="ID" font-family="Verdana" font-size="11" color="#000000" width="5%" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="left" headingalign="left">sys_request_id</field1><field4 heading="Date" font-family="Verdana" font-size="11" color="#000000" width="15%" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="left" headingalign="left">sys_requestdate</field4><field2 heading="Template:Requesttype" width="19%" font-family="Verdana" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="left" headingalign="left">sys_requesttype_id</field2><field5 heading="Problem Summary" font-family="Verdana" font-size="11" color="#000000" width="18%" align="left" headingalign="left">sys_problemsummary</field5><field6 heading="Priority" font-family="Verdana" font-size="11" color="#000000" width="10%" align="center" headingalign="center">sys_requestpriority</field6><field3 heading="Status" width="10%" font-family="Verdana" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center">sys_requeststatus</field3><actionlink width="5%" heading="" font-family="verdana, arial, sans-serif" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="~/Application_Images/16x16/tasks_16.png" linkhasitemsimg="~/Application_Images/16x16/task_hasitems.png" linkinactiveimg="" linkimgalt="Template:Actions" linkhasunreaditemsimg="">View</actionlink><commentlink width="5%" heading="" font-family="verdana, arial, sans-serif" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="~/Application_Images/16x16/Comments_16.png" linkhasitemsimg="~/Application_Images/16x16/Commentshasreaditem16px.png" linkinactiveimg="" linkimgalt="Template:Comments" linkhasunreaditemsimg="~/Application_Images/16x16/Commentshasunreaditem16px.png">Comments</commentlink><attachlink width="5%" heading="" font-family="Verdana" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="~/Application_Images/16x16/attach_16.png" linkhasitemsimg="~/Application_Images/16x16/attachhasitems_icon_16px.png" linkinactiveimg="" linkimgalt="" linkhasunreaditemsimg="">Attachment</attachlink><opencloselink width="5%" heading="" font-family="verdana, arial, sans-serif" font-size="11" color="#000000" bgcolor="#FFFFFF" headingbgcolor="#CCCCCC" align="center" headingalign="center" linkimg="application_images\16x16\Request_Open.png" linkhasitemsimg="" linkinactiveimg="" linkimgalt="" linkhasunreaditemsimg="">Open Close</opencloselink></resultset></request> '
WHERE sys_resultsetprofile_id = 'enduserrequest'
Now the default column configuration has been restored.