Disabling sorting on specific columns on pages

Cem_Karaer

Hello,
I want to disable automatic sorting on flowfield columns on pages. I know how to disable sorting for all columns but it does not apply to my problem because I don't want to lose automatic sorting facility for all columns but rather disable it for some specific columns.
Thanks in advance.

rehansatti

I did not want to say that its not possible but I have to. But there are other workaround that you may consider. Like the one as follows
http://www.navida.eu/sort-keys-back-in-nav-2015-and-nav-2013-r2/

rehansatti

Hi @Cem_Karaer ,
FlowField can not be part of a key and therefore can not be used for sorting. If you want to sort some specific column. Check if the key exist of that combination in the table kes list. If it does not exist make a combination of the key with respective columns which you want to sort. After that go to page and set that key to "sourcetableview" property as follows.



Please verify the answer.

Cem_Karaer

Hello Rehan, thank you for your interest. But it is not what I am asking for. As you can see in the following screenshot you can sort the posted sales invoices by amount on the page even though there is no key having Amount field in the underlaying source table (Sales Invoice Header). This is a generic and automatic facility coming with RTC. And it is a perfect novelty but sometimes I have to disable it. But how can I do it for specific columns?

RockWithNAV

Heu Cem_Karaer,

I dont think its possible in standard NAV. It's a RTC feature.

rehansatti

Hi @Cem_Karaer ,
we can do this. Go to the Posted sales Invoice Page 143. design it and go to the Repeater section of the page. Open the Property window of the page and set the "IndentationColumnName" property to 0 as follows. This will remove the default sorting fro the column.

Cem_Karaer

Thank you Rehan again. I appreciate your efforts. But as I said in my first entry it is the way to disable sorting for all columns but I need to disable sorting for some of columns.

rehansatti

I did not want to say that its not possible but I have to. But there are other workaround that you may consider. Like the one as follows
http://www.navida.eu/sort-keys-back-in-nav-2015-and-nav-2013-r2/

Cem_Karaer

Thank you Rehan. I hope it will be possible to disable automatic sorting for some of columns in the future releases.

zohaibu95@hotmail.com

@Cem_Karaer it is not possible to disable the sorting unfortunately. It is the feature of RTC. May be in the next versions it is possible.

mgn

Has anyone found a way to 'reset' the manual sorting?
Eg. the subpage on Sales Documents is based on table Sales Line. The default sorting is based on "Line No." (and this makes sense when the AutoSplitKey is set to YES). But this field is not on the Page.
So, how to reset this default sorting after a user has (accidentally) clicked on the column header of No., Quantity or any other field?
So far I only found that the 'Reset Defaults' button on the 'Customize Document Layouts'. But this resets all the layout customizations...

AntHillMob

Read the field value into a variable on the OnAfterGetRecord trigger and replace the column on the list with the variable. Because it is a variable. not table field it will not be sortable but the other columns still will be. It's a bit of a pain as you will then need to replicate the drilldown functionality in code if required but will certainly fulfil the requirement.

mgn

AntHillMob wrote: »

Read the field value into a variable on the OnAfterGetRecord trigger and replace the column on the list with the variable. Because it is a variable. not table field it will not be sortable but the other columns still will be. It's a bit of a pain as you will then need to replicate the drilldown functionality in code if required but will certainly fulfil the requirement.

I understand that it can be done by customizing the object. But is there no standard (out of the box) functionality to do this ???

Slawek_Guzek

Nope. It is a bit annoying but there is nothing build in.

The workaround is to add an action on a page to reset the sorting or to add the Line No. to the subpage

mgn

Clear.
Thanks AntHillMob and Slawek.
In the mean-time I found this blog of Julian navida.eu/2015/06/04/sort-keys-back-in-nav-2015-and-nav-2013-r2/