Hello @Bruno
We have created the selection checkbox with the following script.

It is displaying the selection checkbox and possible to select the rows.
The problem which we are facing is:
if we select with checkbox and also clicking on rows, the GetSelectedRowsData action is taking all the rows (SelectedRows+CheckedRows).
Please let me know if we can send the checked rows only with current version of DataGrid reactive?


As for our use case, we need to retrieve only the rows which are selected with checkbox.
So, in my opinion, it would be helpful if there is an action like GetChekcedRowsData, which will only take the checked rows.

Please let me know.
Thank you.

Regards,
Alam

Hello @Alam,

As soon as you add the checkbox selection to the grid, using the client actions that are being provided won't assure that you will get what you need.

You need to build your own action to retrieve the selection, so to get only the checked row using the checkbox you can use the JS function:

JSON.stringify(GridAPI.GridManager.GetGridById($parameters.GridId).provider.rows.filter((x) => {return x.isSelected}).map((y) => y.dataItem))

You can use the array in the result and deserialize to your data structure to get the lines that have been checked.

Please note that, in this case, when using the JSON Deserialize node, you would to select in the Data Type field - List of Record of Sample_Product.

Please keep in mind that this hasn't been tested for all possible use cases or that it cover all of your requirements, so we cannot assure that it will work for all use cases.

Please let us know if this helps.

Bruno Martinho

Hello @Bruno Martinho,

My use case is similar to what @Alam described: we want to select the rows with the checkbox and we want to be able to get the checked rows, so we would need a new client action for that.

As for the mixing of selection between the checkbox and the row header, it would be nice if we could choose how to select a row. However, if that's not possible, the selection could be mixed, as long as there is a client action that can get us only the checked rows (with the checkbox, ignoring the ones that were selected through the row header).

Best regards,

André Dinis

Hello @Bruno Martinho
Thank you for the help. For now, we have been able to achieve what we wanted with the way you suggested.
However, like me and `Mr. Andre mentioned, it would be great if there is a client action built into the DataGrid Reactive.
Thanks again.

Hello @Alam, @all, 

I'm trying to use this solution that you proposed but the column picker disappears, while I wanted it to be also shown in the data grid. I've been trying some things to get the column picker next to the checkbox selection column, with no success so far. Is there any way I can do this?

Thanks in advance.

Best regards,

André Dinis

I want to add CSS class on this column. I have tried different method but not able to done. anyone can help.. Thanks in advance.  

Hi Alam i used ur script to enable checkbox in row headers, and i am able to get all the selected rows alone if use the GetCheckedRowData from the API. Thank you for the script for selecting row headers.

Hello @Cátia Candeias,

Which version of DataGrid are you using? Have you tried using Checkboxes? With them, you are able to persist selections between pages and retrieve them with the GetCheckedRowsData.

Hello, 

I'm using the 2.7.0 version.

I already tried to do that, but since the values were not being passed on, I moved on to this second approach.

I'm using an Advanced Query to get the information, I don't know if this has an impact on the actions.

Hello,

Could you please give a example for this?

Can you post your client action how you get selected data