Data-Grid Widgets

A data-grid widget allows you to display data in a grid, or table, for your users and analysts to view and explore. For example; Assets, recent tickets, members of a given group.

The widget can be found in Screen Designer and is configured with string properties.

Adding a Data-Grid Widget to your Screen - Widget Properties

When you first add a widget to the screen it will appear as a solid grey box that spans all columns. You cannot resize the columns.

After you have added your widget:

1. Highlight the widget so it has the focus

2. Set the Widget id to "data-grid"

3. Enter your widget properties (see known issues and examples below).

These fields are case sensitive. They must be all lower case without spaces unless specified otherwise.

Sample data-grid Widget Library

Request Details Screens

Show Child Requests of a Parent Request

Widget ID: data-grid

{"entityType":"request","columns":"Ref,Status:RequestStatus.Name,Template:Template.Name,Person:Ext_RscrPersonSearch2.Name,CreatedDate","headers":"Ref,LoggedDate,Status,Type,NewStarter","sorting":"off","pageFilters":[{"id":"REQUEST_NO","apiId":"Number1"}],"orderBy":"","sortBy":""}

List Stakeholders of the Request

Widget ID: data-grid

{"entityType":"configuration-item","columns":"Ref,Asset:Target.Name,Type:Target.InfraEntityType.Name","headers":",Asset,Type","filters":"","autoheight":"true",
"columnsresize":"true","sorting":"on","pageFilters":"[{\"id\":\"REF\",\"apiId\":\"Holder.Ref\"}]","orderBy":"Target.InfraEntityType.Name","sortBy":"Target.Name"}

List all Assets where User is a Stakeholder

Widget ID: data-grid

{"entityType": "configuration-item", "columns": "Ref, Name, Type:InfraEntityType.Name, Manufacturer:Manufacturer.Name, ModelType:ModelType.Name", "headers": ",Title, Type, Manufacturer, Model", "filters": "", "sorting": "off", "pageFilters": "[{\"id\":\"REQUESTOR_REF\",\"apiId\":\"User\"}]", "orderBy": "", "sortBy": ""}

List all Assets where nthe User is the Owner

Widget ID: data-grid

{"entityType": "configuration-item", "columns": "Ref, Name, Type:InfraEntityType.Name, Manufacturer:Manufacturer.Name, ModelType:ModelType.Name", "headers": ",Title, Type, Manufacturer, Model", "filters": "", "sorting": "off", "pageFilters": "[{\"id\":\"REQUESTOR_REF\",\"apiId\":\"User\"}]", "orderBy": "", "sortBy": ""}

Task Screens

Config Items where User is a Stakeholder

Widget ID: data-grid

{"entityType":"person-to-asset-stakeholder-link","columns":"Asset:Target.Name,Type:Target.InfraEntityType.Name","headers": ",User of, Type","sorting":"off","pageFilters":"[{\"id\":\"REF\",\"apiId\":\"Holder.Ref\"}]","orderBy":"Target.InfraEntityType.Name","sortBy":"Type"}

Config items belonging to a user

Widget ID: data-grid

{"entityType": "configuration-item", "navigationEntityType":"asset","columns": "Ref:Target.Ref, Type:InfraEntityType.Name, Manufacturer:Manufacturer.Name, ModelType:ModelType.Name", "headers": ",Title, Type, Manufacturer, Model", "filters": "", "sorting": "off", "pageFilters": "[{\"id\":\"REQUEST:REQUESTOR_REF\",\"apiId\":\"User\"}]", "orderBy": "", "sortBy": ""}

Incident Details Screen

Show User's Resources

Widget ID: data-grid

{"entityType": "configuration-item", "columns": "Ref,Title,Type:InfraEntityType.Name,Status:PhysicalStatus.Name,Desc:Description", "headers": ",Title,CMDB Type,Status,Description", "filters": "Status%20%3D%3D%20%22A%22%20%26%26%20User.Ref%20!%3D%200", "sorting": "on", "pageFilters": "[{"id":"USER_REF","apiId":"User.Ref"}]", "orderBy": "Title%20asc", "sortBy": ""}

Portal HomePage

Show all Assets of a Specific CMDB Item Type Where User is a Stakeholder

Widget ID: data-grid

{"entityType": "person-to-asset-stakeholder-link","columns": "Ref:Target.Ref,Title:Target.Title,Type:Target.InfraEntityType.Name,Name:Target.User.Name,Org:Target.Organization.Name,Description:Target.Description",
   "headers": "Ref,Title,CIType,Person,Organisation,Description",
   "filters": "Holder%3D%3D%40UserId%26%26%28LinkType.Name%3D%22Practice%20Manager%22%7C%7CLinkType.Name%3D%22Registered%20Manager%22%29",
   "sorting": "On",
   "pageFilters": "[{\"id\":\"ITEM_REF\",\"apiId\":\"Asset.Ref\"}]",
   "orderBy": "Ref",
   "sortBy": "Ref"
}

All Calls Awaiting Your Action

Widget ID: data-grid

{"entityType":"call","columns":"Ref,CreatedDate,ShortDescription,Product:ConfigurationItem.Name,Status:CallStatus.Name","headers":"No.,Date Raised,Description,Product,Status","sorting":"on","filters":"UserId%20%3D%3D%20%40UserId%26%26(OpenStatus=1%7C%7COpenStatus=2%7C%7COpenStatus=3)%26%26CallStatus.IsAwaitingAction=1"}

Calls Awaiting Closure Confirmation

If you have 2 part closure enabled and are waititng for the custoer to confirm call can be closed

Widget ID: data-grid

{"entityType":"call","columns":"Ref,CreatedDate,ShortDescription,Product:ConfigurationItem.Name,Status:CallStatus.Name","headers":"No.,Date Raised,Description,Product,Status","sorting":"on","filters":"UserId%20%3D%3D%20%40UserId%26%26(OpenStatus=1%7C%7COpenStatus=2%7C%7COpenStatus=3)%26%26CallStatus.IsAwaitingAction=1"}

Change Requests for the Next 7 Days

Widget ID: data-grid

{"entityType":"request","columns":"Ref,Req_Title:Name,Req_Risk:Risk.Name,Req_Priority:Priority.Name,Req_Status:RequestStatus.Name,ImpStart:ImplementationStartDate,ImpEnd:ImplementationEndDate,Req_Desc:ShortDescription","headers":"No.,Title,Risk,Priority,Status,Start Date,End Date,Description","sorting":"on","filters":"WorkflowProfile%3D%3D0%26%26OpenStatus%3E0%26%26TemplateType%3D%3D0%26%26ImplementationStartDate%3E%40Now%26%26ImplementationStartDate%3C%3D%40NowOffset%287%3B0%3B0%29%26%26ImplementationEndDate%21%3Dnull","orderBy":"ImplementationStartDate%20Asc","sortBy":"ImplementationStartDate"}
Notes:
•Workflow Profile : 0 (Change Management)
•Implementation Start Date > @Now and <= @NowOffset by 7 days
•Implementation End Date is not Null

Change Requests for the Next 7-14 Days

Widget ID: data-grid

{"entityType":"request","columns":"Ref,Req_Title:Name,Req_Risk:Risk.Name,Req_Priority:Priority.Name,Req_Status:RequestStatus.Name,ImpStart:ImplementationStartDate,ImpEnd:ImplementationEndDate,Req_Desc:ShortDescription","headers":"No.,Title,Risk,Priority,Status,Start Date,End Date,Description","sorting":"on","filters":"WorkflowProfile%3D%3D0%26%26OpenStatus%3E0%26%26TemplateType%3D%3D0%26%26ImplementationStartDate%3E%40NowOffset%287%3B0%3B0%29%26%26ImplementationStartDate%3C%3D%40NowOffset%2814%3B0%3B0%29%26%26ImplementationEndDate%21%3Dnull","orderBy":"ImplementationStartDate%20Asc","sortBy":"ImplementationStartDate"}
Notes:
•Workflow Profile : 0 (Change Management)
•Implementation Start Date > @NowOffset by 7 days and <= @NowOffset by 14 days
•Implementation End Date is not Null

Change Requests for the Next 14-28 Days

Widget ID: data-grid

{"entityType":"request","columns":"Ref,Req_Title:Name,Req_Risk:Risk.Name,Req_Priority:Priority.Name,Req_Status:RequestStatus.Name,ImpStart:ImplementationStartDate,ImpEnd:ImplementationEndDate,Req_Desc:ShortDescription","headers":"No.,Title,Risk,Priority,Status,Start Date,End Date,Description","sorting":"on","filters":"WorkflowProfile%3D%3D0%26%26OpenStatus%3E0%26%26TemplateType%3D%3D0%26%26ImplementationStartDate%3E%40NowOffset%2814%3B0%3B0%29%26%26ImplementationStartDate%3C%3D%40NowOffset%2828%3B0%3B0%29%26%26ImplementationEndDate%21%3Dnull","orderBy":"ImplementationStartDate%20Asc","sortBy":"ImplementationStartDate"}
Notes:
•Workflow Profile : 0 (Change Management)
•Implementation Start Date > @NowOffset by 14 days and <= @NowOffset by 28 days
•Implementation End Date is not Null

Stakeholders of a Service

Widget ID: data-grid

{"entityType": "person-to-asset-stakeholder-link","columns": "HolderName:Holder.Name,LinkTypeName:LinkType.Name","headers": "Stakeholder, Role Type","filters": "!%40IsDeleted","sorting": "off","pageFilters": "[{\"id\":\"ITEM_REF\",\"apiId\":\"Target.Ref\"}]","orderBy": "Holder.Name","sortBy": "Holder.Name"}

Requests Logged for Others

Widget ID: data-grid

{"entityType":"request","columns":"Ref,CreatedDate,User:RequestedBy.FriendlyName,Status:RequestStatus.Name,Title:Name,Desc:ShortDescription","headers":"No.,Date Raised,Requested For,Status,Title,Description","sorting":"on","filters":"%40IsLoggedByMe%26%26!%40IsLoggedForMe%26%26SystemStatus%3E0%26%26OpenStatus","orderBy":"CreatedDate%20Desc","sortBy":"CreatedDate"}

Note: Requests logged by User but submitted for another User (ie modified the User field in the Submission screen), not including un-submitted requests.

Calls Logged for Others

Widget ID: data-grid

{"entityType":"call","columns":"Ref,CreatedDate,User:User.FriendlyName,Status:CallStatus.Name,Desc:ShortDescription","headers":"No.,Date Raised,Logged For,Status,Description","sorting":"on","filters":"%40IsLoggedByMe%26%26!%40IsLoggedForMe%26%26SystemStatus%3E0%26%26OpenStatus","orderBy":"CreatedDate%20Desc","sortBy":"CreatedDate"}

Note: Calls logged by User but submitted for another User (ie modified the User field in the Call Submission screen), not including un-submitted Calls.

My Organizations Calls

Widget ID: data-grid

{"entityType":"call","columns":"Ref,CreatedDate,User:User.FriendlyName,Status:CallStatus.Name,Desc:ShortDescription","headers":"No.,Date Raised,Logged By,Status,Description","sorting":"on","filters":"OrganizationId%20%3D%3D%20%40OrganizationId%26%26OpenStatus","orderBy":"CreatedDate%20Desc","sortBy":"CreatedDate"}

Show the calls awaiting your action and any that are open/resolved open/unresolved

Widget ID: data-grid

{"entityType":"call","navigationEntityType":"call","Ref:Target.Ref",columns":"Ref,CreatedDate,ShortDescription,Product:ConfigurationItem.Name,Status:CallStatus.Name","headers":"No.,Date Raised,Description,Product,Status","sorting":"on","filters":"UserId%20%3D%3D%20%40UserId%26%26(OpenStatus=1%7C%7COpenStatus=2%7C%7COpenStatus=3)%26%26CallStatus.IsAwaitingAction=1"}

Person Screens

Calls Outstanding for a User

Widget ID: data-grid

{"entityType":"call","columns":"Ref,CreatedDate,Status:CallStatus.Name,ProblemDesc:Description", "headers":"Ref,Logged Date,Status,Description","sorting":"on", "filters":"OpenStatus == 1", "pageFilters": "[{\"id\":\"REF\",\"apiId\":\"User.Ref\"}]" }

Users Assigned Software where the person is a stakeholder

Widget ID: data-grid

{"entityType":"person-to-asset-stakeholder-link","navigationEntityType":"asset","columns":"Ref:Target.Ref,Asset:Target.Name,ModelType:Target.ModelType.Name,Type:Target.InfraEntityType.Name","headers":"Assigned Applications,Module,Type","filters":"!@IsDeleted","sorting":"on","pageFilters": "[{\"id\":\"REF\",\"apiId\":\"Holder.Ref\"}]","orderBy":"Target.InfraEntityType.Name","sortBy":"Model"}

Users Assigned Assets/Configuration Items

Widget ID: data-grid

{"entityType":"configuration-item","navigationEntityType":"asset","columns":"Ref,Name,Type:InfraEntityType.Name,Manufacturer:Manufacturer.Name,ModelType:ModelType.Name","headers":",Assigned Assets,Type,Manufacturer,Model","filters":"!@IsDeleted","sorting":"off","pageFilters":"[{\"id\":\"REF\",\"apiId\":\"User\"}]","orderBy":"","sortBy":""}