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.

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:

Highlight the widget so it has the focus
Set the Widget id to "data-grid"
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.

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":""}

Last updated 7 months ago

Was this helpful?