Enable Print Jobsheet for all Status tickets
By default Print Jobsheet option is available for only Closed status tickets from Request's detailed view-> Actions.
If you want to enable the same for all statuses, then you need to update an entry in the Globalconfig table.
Make sure to take at least a trimmed Backup of the application (or a SQL Backup or a Server Snapshot) before performing the update operation.Connect to the database and execute the below query,
update globalconfig set paramvalue = 'true' where category like 'jobsheet' and parameter like '%Allow_AnyStatus%';
Restart the application for the changes to be effective.
Now navigate to any NOT closed request and check under Actions, you will see the Print Timesheet option.
New to ADSelfService Plus?
Related Articles
Query to show Timesheet details (MSSQL & PGSQL)
Tested in build PGSQL (14300) and MSSQL (14306) MSSQL: select ts.id "TimeSheet ID", sdu.firstname "Technician Name", LONGTODATE(ts.starttime) "Timesheet Start Date", LONGTODATE(ts.endtime) "Timesheet End Date", CONVERT(varchar, ((ts.totaltime)/1000) ...Status Change on new reply.
The status do not automatically switch from "OnHold" to "Open" when a response from the Requester arrives. Enable below configuration to automate the same. Go to Admin >> Self Service Portal >> Enable the below option Also, it does not switch from ...Query to show tickets older than 30 days ( MSSQL )
Tested in build MSSQL (14306) MSSQL: SELECT wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",std.STATUSNAME "Request Status",wo.TITLE "Subject",aau.FIRST_NAME AS "Requester Name", pd.PRIORITYNAME as "Priority", adef.ORG_NAME as "Account", ...Forgot password option missing
If Forgot password option missing in the login page, then please check the below option under Admin->Self-Service Portal Settings. If this option is disabled, then the Forgot password option will not be visible in the login page. Allow users to login ...Script to reset password and enable local authentication
Purpose : Interactive mode of resetting the password of a user by entering his username. Also, to enable local authentication in the application. This script can be used in builds on or above 9400 version How the script works ? Invoking the script ...