Hi @Dhineshkumar B, 

In OutSystems, the SetRowAsSelected client action in the Data Grid component can be used to programmatically select a row. When grouping is applied to the grid, selecting a row within a group works the same as in an ungrouped grid, but you need to ensure that the row is correctly referenced.

Here’s how you can handle SetRowAsSelected when grouping is applied:

Steps to Select a Row in a Grouped Data Grid:

1. Ensure Row Identifier is Available: The SetRowAsSelected action requires a row identifier, which is typically the row's primary key or unique identifier.

2. Get the Row's Index: Since the grid might be grouped, the row’s index can change based on the group structure. You can loop through the rows to find the correct one or extract it dynamically based on your grouping structure.

3. Use the SetRowAsSelected Action: Once you identify the row, you can pass its identifier or index to the SetRowAsSelected action.

Example:

Here’s a sample implementation:

1. Grouping the Grid: Ensure the Data Grid is grouped based on a certain column (like "Category" or "Region"). You can do this by configuring the grid’s grouping feature via its configuration options.

2. Finding the Row in the Group: Write a logic to determine the row you want to select. If you are selecting based on a specific field, you might loop through the rows to find the correct one.

3. SetRowAsSelected Usage: Use the SetRowAsSelected action, passing the row’s index or key. Example:

   outsystemsCopy codeDataGridActions.SetRowAsSelected(    GridId: "YourGridId",    RowIndex: YourRowIndex)

   If you are dealing with the row’s unique ID:

   outsystemsCopy codeDataGridActions.SetRowAsSelectedByKey(    GridId: "YourGridId",    Key: YourRowKey)

4. Handling Grouped Rows: If your rows are grouped, make sure you adjust for the group's expansion. Ensure the group is expanded before setting a row as selected.

Notes:

• Expanded Grouping: If a group is collapsed, you cannot select rows from it directly until the group is expanded. You might need to use an action to programmatically expand the group if needed.
• SetRowAsSelectedByKey might be more reliable in scenarios where the grid is grouped, as row indexes can shift when groups are collapsed or expanded.

Hi @Dhineshkumar B 

you can use this JS to select the row you want:

1. let myGrid = OutSystems.GridAPI.GridManager.GetGridById("MyGrid").provider;
2. var rowIndex = 3; // For example, row 3
3. var rowHeaderCell = myGrid.rowHeaders.getCellElement(rowIndex, 1);
4. var checkbox = rowHeaderCell.querySelector('input[type="checkbox"]');
5. checkbox.click();

Result:

Hi @Dhineshkumar B ,

You're right, since the script is based on DOM, when item is hided, the script won't find it, so that it will returrn the error  "Cannot read properties of null (reading 'querySelector')." 

Incase you want the item get selected even when it is hided. Let my try something else. 

Hi @Dhineshkumar B ,

Let's do some combination, try this solution below, it works for me.

1. let myGrid = OutSystems.GridAPI.GridManager.GetGridById("MyGrid");
2. var rowIndex = 3; // For example, row 3
3. var rowHeaderCell = myGrid.provider.rowHeaders.getCellElement(rowIndex, 1);
4. if (rowHeaderCell) {
5.     var checkbox = rowHeaderCell.querySelector('input[type="checkbox"]');
6.     checkbox.checked = true;
7.     checkbox.dispatchEvent(new Event('change'));
8. } else {
9.     myGrid.features.selection.getMetadata(rowIndex).isChecked = true;
10.     myGrid.provider.refresh();
11. }