API -Listing Open Requests of a specific Requester
{
"list_info": {
"row_count": 20,
"start_index": 1,
"sort_field": "subject",
"sort_order": "asc",
"get_total_count": true,
"search_fields": {
"requester.name": "CustomREQ1"
},
"filter_by": {
"name": "Open_System"
}
}
}
2. Make sure to include input_data at the beginning of the parameter as highlighted below:
New to ADSelfService Plus?
Related Articles
API - Listing of Worklogtype
1. Go to Admin > API > Reports > Execute Query: select * from worklogtypedefinition 2. Sharing screenshot for your reference:Query report to show Open requests without open tasks
PGSQL & MSSQL: SELECT wo.WORKORDERID AS "Ticket Number", pd.PRIORITYNAME AS "Priority", cd.CATEGORYNAME AS "Category", ti.FIRST_NAME AS "Technician", aau.FIRST_NAME AS "Requester", wotodesc.FULLDESCRIPTION AS "Description", std.STATUSNAME AS "Request ...How to send periodic notifications to requester(s) about their pending requests and accordingly update their status.
This post describes the use of a python script to notify requester(s) about their requests through email and move those to a specific status. Use Case: Let us assume a scenario where the technicians reply to a request and put it in a custom status ...API -Listing requests based on Additional Field Values
This can be met through V3 API. Go to Admin > Incident Additional Fields and make a note of the "API Field Name" as highlighted below: Please follow the below mentioned to pull the requests based on the additional field values: 1. Use the Input as ...Requests that are open for more than 7 days (PGSQL)
Tested in Build PGSQL (14300) PGSQL: select wo.workorderid as "RequestID", wo.Title as "Title", reqaaa.First_Name as "Requester", aaa.first_name as "Technician", sd.StatusName as "Status", wo.CreatedTime as "CreatedTime", wos.AssignedTime as ...