Duplicate Request Alert for users when a similar request is in pending status
Requirement:
If User A has already logged a request that is still in a pending status, the system should recognize this duplication when User B attempts to log the similar request.
Usecase:
When User A logs a call on the Self Service Portal using the Links Request Template, they must fill in the mandatory UDF fields: Circuit ID (e.g., ABC1234) and IP Address (e.g., 192.168.0.1). After the call is successfully logged, if User B attempts to log a call on the Self Service Portal using the same Links Request Template with the same Circuit ID and IP Address, the system should check the status of User A's request. If User A's request is still in a pending status (open, on hold, in progress, etc.), the system should display a popup to User B stating, "This request has already been raised by another user," preventing the duplication of the request.
Steps to follow:
- Extract the attached content and copy it into Admin > Developers Space > Request custom function > New.
- Save the function with a proper name.
- Configure this script as a Business Rule to execute each time a request is created, the template matches, and both additional field values are not empty.
New to ADSelfService Plus?
Related Articles
Pending Request for more than 10 days
This report provides a quick view of all Pending incidents which are not closed for more than 10 days. When the incidents start backlogging faster than they can be resolved, the tendency of long incidents pending time can be exposed in this report. ...Query to retrieve pending approvals from a technician account specific (MSSQL)
Tested in build MSSQL (14306) SELECT wo.WORKORDERID AS "Request ID", ad.org_name as "Account", aaa .first_name as "Technician", ApprovalStatusDefinition.STATUSNAME AS "Approval Status" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON ...Duplicate users while importing from AD
Use the below queries; To find the number of duplicate users: SELECT objectguid, COUNT(*) TotalCount FROM aduser GROUP BY objectguid HAVING COUNT(*) > 1; SELECT userid, samaccname, objectguid, COUNT(*) TotalCount FROM aduser GROUP BY userid, ...Query to show an additional column action pending by in change request
Database: MSSQL SELECT "chdt"."CHANGEID" AS "Change ID", "chdt"."TITLE" AS "Title", LONGTODATE(chdt.CREATEDTIME) AS "Created Time", "ownaaa"."FIRST_NAME" AS "ChangeOwner", STUFF((SELECT ', '+ au.first_name + char(10) FROM changeroleusermapping crum ...Query that lists pending approval of a particular service approver (PGSQL)
Doesnt work in PGSQL (14300) ERROR: relation "workorder_threaded" does not exist SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",wo.TITLE "Subject",ti.FIRST_NAME "Technician", longtodate(wo.CREATEDTIME) "Created Time",appsau.first_name ...