Joao Kuae
Rank: #1629
9Views
4Comments
Solved
[Data Grid Reactive] To add row requires no filter or sort - how to force grid to clear before adding?
Question
Reactive
Forge
Data Grid Reactive
Forge component by Bruno Martinho
5
Published on 24 Feb 2021
Application Type
Reactive

Hi,

I am implementing the Add Row feature, but the Grid must not have any sort or order applied, otherwise I get the error.

Error when column sorted:


Error when column with filter:

I was able to implement a JS code to clear the Filter:

GridAPI.GridManager.GetGridById($parameters.GridId).features.filter._filter.clear()


But I was unable to find a function to clear the sorting, so the user won't have to clear any column sorting. 

Is there a function to easily clear all sorting applied to the grid? 

Thanks.

0
0
8 days ago
Copy link to comment
Tiago Miguel Pereira
Staff
Rank: #489
Solution

Hello @Joao Kuae,

Thanks for bringing this subject to the discussion. 

It seems that you want to clear the sorting from all columns. After some searching I found that you can remove it by executing the following line:

GridAPI.GridManager.GetGridById($parameters.GridId).provider.itemsSource.sortDescriptions.clear()


Hope this helps,

Best Regards,

Tiago Pereira

1
0
7 days ago
Copy link to comment
Bruno Martinho
Staff
Rank: #52

Hello @Joao Kuae ,

Can you please let us know if you are using the Custom Menu item to implement the Add new Row?

Would it be helpful to have these actions as a public client action?

0
0
7 days ago
Copy link to comment
Joao Kuae
Rank: #1629

Thank you @Tiago Miguel Pereira! It worked!


1
0
7 days ago
Copy link to comment
Joao Kuae
Rank: #1629

@Bruno Martinho,

Yes, I am using the Custom Menu Item to implement it.

I think it would be great to have those actions as public - it gives more flexibility for developers.

1
0
7 days ago
Copy link to comment