Layton ServiceDesk - Settings - Global List View - End User Request
From Layton Support
(Difference between revisions)
m (Removed image links) |
m (Updated links) |
||
(8 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> |
+ | __FORCETOC__ | ||
+ | =Advanced Actions= | ||
==Removing the Change Request Status Button Column== | ==Removing the Change Request Status Button Column== | ||
Line 6: | Line 8: | ||
[[File:Button task 16.png|link=]] Tasks<br /> | [[File:Button task 16.png|link=]] Tasks<br /> | ||
[[File:Button comments 16.png|link=]] 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|link=]] Change Request Status | [[File:Button change status 16.png|link=]] Change Request Status | ||
Line 17: | Line 19: | ||
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. | #Connect to the LaytonServiceDesk database in SQL Server Management Studio. | ||
#Click the New Query button. | #Click the New Query button. | ||
Line 26: | Line 29: | ||
#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: | ||
− | <blockquote><code> | + | <blockquote><code><nowiki> |
UPDATE resultsetprofile<br /><br /> | UPDATE resultsetprofile<br /><br /> | ||
Line 33: | Line 36: | ||
'<br /><br /> | '<br /><br /> | ||
− | WHERE sys_resultsetprofile_id = 'enduserrequest'</code></blockquote> | + | WHERE sys_resultsetprofile_id = 'enduserrequest'</nowiki></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 | + | <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.