The requests are stricken, when associated with expired contract
When , in Request Module, the requests are stricken out, the below mentioned is the reason and solution to remove it.
-> The stricken out of the tickets indicates that the contract associated with that ticket has expired.
-> You can follow the below instructions to remove the strikeouts
3. Run the below query
update globalconfig set paramvalue='false' where parameter like '%StrikeExpired%';
5. Re-start the services.
New to ADSelfService Plus?
Related Articles
Can we extend the expired contract?
Only an active contract can be renewed. If the contract has expired then a new contract has to be created from the latest duration has to be created. Overlapping of dates in this scenario is not possible.Query to show Contract details with assets associated (PGSQL)
Tested in PGSQL build (14300) SELECT mcdt.customcontractid "Contract ID", mcdt.CONTRACTNAME AS "Contract Name", mcdt.customcontractid "Contract ID", contractcategory.Categoryname "Contract Type", LONGTODATE(mcdt.CREATEDDATE) AS "Created Time", ...Query to show requests and its associations with Problems, Changes and Projects (MSSQL)
Working on Builds: 14500 and above Database: MSSQL SELECT wo.WORKORDERID AS "Request ID", pim.problemid "Associated Problem ID", icm.changeid "Associated Change ID", wtp.projectid "Associated Project ID", CASE WHEN (wo.is_catalog_template) = 'false' ...Query to get Asset contract and its details (MSSQL & PGSQL)
Tested in builds from PGSQL (14300) or MSSQL (14306) SELECT mcdt.Contractid "URL Contract ID", mcdt.customcontractid "Custom contractid in details page", mcdt.CONTRACTNAME "Contract Name", aao.NAME "Maintenance Vendor Name", LONGTODATE(mcdt.FROMDATE) ...Close Multiple associated Requests to Problem with one resolution
By following the below steps we can Copy one problem solution and workaround to all associated incidents Instructions 1. Create a problem ticket. 2. Associate incidents to the problem to the ticket. 3. Under Admin>Problem Closure Rules you can set ...