[Data Grid Reactive] how to stop sorting automatically when the cell value changed
Question
Forge component by OutSystems R&D

i do not want to sort automatically when i modify a cell value.

but the sort works automatically after I sorted the data by clicking the column.


how to stop sorting automatically?

Solution

Hello Jiro,

I'm not sure I understood your case correctly. Please correct me if I'm wrong, but you want a cell to stay where it is after sorting a column?

If this is correct, I've made a sample for you.

On Grid Initialize, I call our API to disable refresh on edits with this code.


GridAPI.GridManager.GetActiveGrid().provider.collectionView.refreshOnEdit = false;


Let me know if this works for you,

Gabriel Lundgren

GridSortRefresh.oml

Hi @Jiro Yamada,

Have you tried Clear Sort action under API Sort because that helps you to clear all sortings in the grid

thank you @Pranay Kumar 

i successfully clear sort setting by using the api you suggested 

But unfortunately the sorted data is also rolled back.

I don’t want to roll back the data.

Only the sort setting is the thing I want to clear


mvp_badge
MVP


Hi @Jiro Yamada,

Can you explain a bit more what you mean by "roll back the data"?

Also if you record a small gif/video of what is happening, would be extremely useful.

Thank you!
RG

hi @Ruben Goncalves 

i am sorry, i can not make a gif/video.

the thing i want to do is the following:

 (1) sort the data by clicking column

 (2) make the sort function disable

 (3) edit the data on cells which were sorted in (1)


i tried to use the api you suggested but the data sorted in (1) become unsorted back.


Hello @Jiro Yamada ,

We are trying to understand your use case, but we are not getting it.

If the column is sorted, in the grid, when you change a value, that value will be sorted because the column is sorted.

What do you want to achieve with " make the sort function disable ".

Can you please give some more details, please?

Thanks.

Bruno Martinho

hi

i made an image file to explain

could you refer to the attached file?

sortfunction.png

Solution

Hello Jiro,

I'm not sure I understood your case correctly. Please correct me if I'm wrong, but you want a cell to stay where it is after sorting a column?

If this is correct, I've made a sample for you.

On Grid Initialize, I call our API to disable refresh on edits with this code.


GridAPI.GridManager.GetActiveGrid().provider.collectionView.refreshOnEdit = false;


Let me know if this works for you,

Gabriel Lundgren

GridSortRefresh.oml

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.