Layton ServiceDesk - Settings - Global List View - End User Request
From Layton Support
(Difference between revisions)
m (Clarified text) |
m (Changed formatting) |
||
Line 26: | Line 26: | ||
#Copy and paste the following query into the query field and execute it: | #Copy and paste the following query into the query field and execute it: | ||
− | <code>UPDATE resultsetprofile | + | <blockquote><code> |
+ | UPDATE resultsetprofile<br /><br /> | ||
− | SET sys_resultsetprofile_xml = ' | + | SET sys_resultsetprofile_xml = '<br /> |
− | <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> | + | <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><br /> |
− | ' | + | '<br /><br /> |
− | WHERE sys_resultsetprofile_id = 'enduserrequest'</code> | + | WHERE sys_resultsetprofile_id = 'enduserrequest'</code></blockquote> |
Now the default column configuration has been restored. | Now the default column configuration has been restored. | ||
<p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk™]] [[User Guide for Layton ServiceDesk™|<u>Back to Contents</u>]]</p> | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton ServiceDesk™]] [[User Guide for Layton ServiceDesk™|<u>Back to Contents</u>]]</p> |
Revision as of 23:01, 26 August 2013
Removing the Change Request Status Button Column
The End User Request form has four button columns by default:
Tasks
Comments
File:Button attachment 16.png Attachments
Change Request Status
To remove the Change Request Status button column:
- 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.