# Data-Grid Widgets

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

<figure><img src="/files/zXWNTrJ2TkMxUpBdjBIZ" alt=""><figcaption></figcaption></figure>

## 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. &#x20;

<figure><img src="/files/2ytCe42DyXLFINPhyMhp" alt=""><figcaption></figcaption></figure>

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). &#x20;

{% hint style="warning" %}
These fields are case sensitive.  They must be all lower case without spaces unless specified otherwise.
{% endhint %}

## Sample data-grid Widget Library

<details>

<summary>Request Details Screens</summary>

## Show Child Requests of a Parent Request

**Widget ID:** data-grid

{% code overflow="wrap" %}

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

{% endcode %}

## List Stakeholders of the Request

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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"}
```

{% endcode %}

## List all Assets where User is a Stakeholder

**Widget ID:** data-grid

{% code overflow="wrap" %}

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

{% endcode %}

## List all Assets where nthe User is the Owner

**Widget ID:** data-grid

{% code overflow="wrap" %}

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

{% endcode %}

</details>

<details>

<summary>Task Screens</summary>

### Config Items where User is a Stakeholder

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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"}
```

{% endcode %}

### Config items belonging to a user

**Widget ID:** data-grid

{% code overflow="wrap" %}

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

{% endcode %}

</details>

<details>

<summary>Incident Details Screen</summary>

### Show User's Resources

**Widget ID:** data-grid

{% code overflow="wrap" %}

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

{% endcode %}

</details>

<details>

<summary>Portal HomePage</summary>

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

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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"
}
```

{% endcode %}

## All Calls Awaiting Your Action

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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"}
```

{% endcode %}

## 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

{% code overflow="wrap" %}

```
{"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

```

{% endcode %}

## Change Requests for the Next 7-14 Days

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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

```

{% endcode %}

## Change Requests for the Next 14-28 Days

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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

```

{% endcode %}

## Stakeholders of a Service

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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"}
```

{% endcode %}

## Requests Logged for Others

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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.
```

{% endcode %}

## Calls Logged for Others

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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.

```

{% endcode %}

## My Organizations Calls

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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"}
```

{% endcode %}

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

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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"}
```

{% endcode %}

</details>

<details>

<summary>Person Screens</summary>

### Calls Outstanding for a User

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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\"}]" }
```

{% endcode %}

### Users Assigned Software where the person is a stakeholder

**Widget ID:** data-grid

{% code overflow="wrap" %}

```
{"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"}
```

{% endcode %}

### Users Assigned Assets/Configuration Items

**Widget ID:** data-grid

{% code overflow="wrap" %}

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

{% endcode %}

</details>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.alemba.com/asm/asm-hermes/setup-and-configure-asm/configuring-your-system/configuring-screens/building-screens-in-asm-designer/screen-widgets/building-screen-widgets.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.