Forum

Default sorting for dynamic list

Felicia McKenzie	#1 Feb 04, 2013 09:56 AM
Active user Points:: 0 Joined:: Oct 29, 2012	Hi, I need to set default sorting for one of catalogs by Order column, is it possible and how to do that?
	Profile

Alexey Alexandrovich

Feb 04, 2013 11:49 AM

Active user

Points:: 0
Joined:: Nov 1, 2011

You can do it using script

Code

&AtClient
Procedure OnOpen(Cancel)
   
   Order = ThisForm.List.Order;
   Order.Items.Clear();
   OrderItem = Order.Items.Add(Type("DataCompositionOrderItem"));
   OrderItem.ViewMode = DataCompositionSettingsItemViewMode.Normal;
   OrderItem.OrderType = DataCompositionSortDirection.Asc;
   OrderItem.Field = New DataCompositionField("MyOrder");
   OrderItem.Use = True;
   
EndProcedure

Profile

Felicia McKenzie	#3 Feb 05, 2013 09:38 AM
Active user Points:: 0 Joined:: Oct 29, 2012	Thank you, Alexey!
	Profile

mohammad maleh	#4 Oct 25, 2013 11:14 PM
Active user Points:: 0 Joined:: Jun 4, 2013	this script doesn't work for me ... is there any other trick to do it ? ... when i run it, it doesn't do anything at all and thanks in advance for helping ...
	Profile

Timofey Bugaevsky	#5 Oct 27, 2013 11:45 PM
Guest Points:: Joined::	Can you show us your script?
	Profile

mohammad maleh

Oct 28, 2013 01:08 AM

Active user

Points:: 0
Joined:: Jun 4, 2013

Of course!!

In the list form:

Code

&AtClient
Procedure OnOpen(Cancel)      
   
   Order = ThisForm.List.Order;
   Order.Items.Clear();
   OrderItem = Order.Items.Add(Type("DataCompositionOrderItem"));
   OrderItem.ViewMode = DataCompositionSettingsItemViewMode.Normal;
   OrderItem.OrderType = DataCompositionSortDirection.Asc;
   OrderItem.Field = New DataCompositionField("Personel");
   OrderItem.Use = True;
      
EndProcedure

Personeln is the filed that i want the rows to be ordered according to

Hope you can help someway me guys

Profile

Alexey Alexandrovich	#7 Oct 28, 2013 05:28 AM
Active user Points:: 0 Joined:: Nov 1, 2011	Try to set Index property of the field
	Profile