Layton ServiceDesk - Settings - Global List View - End User Request
From Layton Support
(Difference between revisions)
m (Minor edits) |
m (Updated links) |
||
(15 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
− | <p align="right">[[File:btn_back_up.png|link=User Guide for Layton | + | <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> |
− | ==Removing the Change Request Status Button== | + | __FORCETOC__ |
+ | =Advanced Actions= | ||
+ | ==Removing the Change Request Status Button Column== | ||
− | The End User Request form has four | + | The End User Request form has four button columns by default: |
− | [[File:Button task 16.png]] Tasks<br /> | + | [[File:Button task 16.png|link=]] Tasks<br /> |
− | [[File:Button comments 16.png]] Comments<br /> | + | [[File:Button comments 16.png|link=]] Comments<br /> |
− | [[File: | + | [[File:Lsd btn attach 16px.png|link=]] Attachments<br /> |
− | [[File:Button change status 16.png]] Change Request Status | + | [[File:Button change status 16.png|link=]] Change Request Status |
− | To remove | + | To remove the Change Request Status button column: |
#Go to Administration > Global List Views > End User Request. | #Go to Administration > Global List Views > End User Request. | ||
Line 16: | Line 18: | ||
The column will disappear from the request list view. | The column will disappear from the request list view. | ||
+ | |||
+ | ==Resetting the Global End User List View== | ||
+ | |||
+ | Resetting the list view requires a SQL query. Note that this will reset all the columns, so any changes you've made will be lost. | ||
+ | |||
+ | #Back up your database using SQL Server Management Studio. | ||
+ | #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: | ||
+ | |||
+ | <blockquote><code><nowiki> | ||
+ | UPDATE resultsetprofile<br /><br /> | ||
+ | |||
+ | 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><br /> | ||
+ | '<br /><br /> | ||
+ | |||
+ | WHERE sys_resultsetprofile_id = 'enduserrequest'</nowiki></code></blockquote> | ||
+ | |||
+ | 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> |
Latest revision as of 06:40, 21 September 2016
Contents |
[edit] Advanced Actions
[edit] Removing the Change Request Status Button Column
The End User Request form has four button columns by default:
Tasks
Comments
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.
[edit] Resetting the Global End User List View
Resetting the list view requires a SQL query. Note that this will reset all the columns, so any changes you've made will be lost.
- Back up your database using SQL Server Management Studio.
- 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<br /><br />
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><br />
'<br /><br />
WHERE sys_resultsetprofile_id = 'enduserrequest'
Now the default column configuration has been restored.