Re: [rt-users] Sorting by the value of a custom field in search results *numerically*
Thanks for your replies guys. And thanks for adding that feature request Brent (http://issues.bestpractical.com/Ticket/Display.html?id=29638). On 2 May 2014 13:52, Landon Stewart wrote: > Hello, > > It seems that the sorting by custom field in search results is always done > alphabetically. > > For example sorting by CF that contains only integers in descending order: > 4 > 3 > 2 > 11 > 1 > > Is there a way to sort search results by custom field numerically? > > -- > Landon Stewart :: lstew...@iweb.com > Lead Specialist, Abuse and Security Management > Spécialiste principal, gestion des abus et sécurité > http://iweb.com :: +1 (888) 909-4932 > > > -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932 -- RT Training - Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Sorting by the value of a custom field in search results *numerically*
This is because the custom field values are stored as varchar or text in the database. I added a feature request (http://issues.bestpractical.com/Ticket/Display.html?id=29638) for it. - Brent -Original Message- From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Emmanuel Lacour Sent: Monday, May 05, 2014 8:23 AM To: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Sorting by the value of a custom field in search results *numerically* On Mon, May 05, 2014 at 02:21:28PM +0200, Emmanuel Lacour wrote: > On Fri, May 02, 2014 at 01:52:06PM -0700, Landon Stewart wrote: > >Hello, > >It seems that the sorting by custom field in search results is always > > done > >alphabetically. > >For example sorting by CF that contains only integers in descending > > order: > >4 > >3 > >2 > >11 > >1 > >Is there a way to sort search results by custom field numerically? > > > > > I use the attached patch for 4.2.3 (not very efficient, but it works). > I misread your email, my patch just fix sorting on CF edit pages, not in search results. -- Easter-eggs Spécialiste GNU/Linux 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité Phone: +33 (0) 1 43 35 00 37- Fax: +33 (0) 1 43 35 00 76 mailto:elac...@easter-eggs.com - http://www.easter-eggs.com -- RT Training - Dallas May 20-21 http://bestpractical.com/training -- RT Training - Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Sorting by the value of a custom field in search results *numerically*
On Mon, May 05, 2014 at 02:21:28PM +0200, Emmanuel Lacour wrote: > On Fri, May 02, 2014 at 01:52:06PM -0700, Landon Stewart wrote: > >Hello, > >It seems that the sorting by custom field in search results is always > > done > >alphabetically. > >For example sorting by CF that contains only integers in descending > > order: > >4 > >3 > >2 > >11 > >1 > >Is there a way to sort search results by custom field numerically? > > > > > I use the attached patch for 4.2.3 (not very efficient, but it works). > I misread your email, my patch just fix sorting on CF edit pages, not in search results. -- Easter-eggs Spécialiste GNU/Linux 44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité Phone: +33 (0) 1 43 35 00 37- Fax: +33 (0) 1 43 35 00 76 mailto:elac...@easter-eggs.com - http://www.easter-eggs.com -- RT Training - Dallas May 20-21 http://bestpractical.com/training
Re: [rt-users] Sorting by the value of a custom field in search results *numerically*
On Fri, May 02, 2014 at 01:52:06PM -0700, Landon Stewart wrote:
>Hello,
>It seems that the sorting by custom field in search results is always done
>alphabetically.
>For example sorting by CF that contains only integers in descending order:
>4
>3
>2
>11
>1
>Is there a way to sort search results by custom field numerically?
>
I use the attached patch for 4.2.3 (not very efficient, but it works).
--
Easter-eggs Spécialiste GNU/Linux
44-46 rue de l'Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37- Fax: +33 (0) 1 43 35 00 76
mailto:elac...@easter-eggs.com - http://www.easter-eggs.com
diff --git a/rt/local/lib/RT/CustomFieldValues_Local.pm b/rt/local/lib/RT/CustomFieldValues_Local.pm
new file mode 100644
index 000..d167f18
--- /dev/null
+++ b/rt/local/lib/RT/CustomFieldValues_Local.pm
@@ -0,0 +1,45 @@
+package RT::CustomFieldValues;
+
+use strict;
+no warnings qw(redefine);
+
+
+=head2 Array
+
+Return the values as an array
+
+=cut
+
+sub Array {
+my $self = shift;
+
+my @values;
+while (my $value = $self->Next) {
+push @values, $value;
+}
+
+return @values;
+
+}
+
+=head2 SortedArray
+
+Return the values as an array sorted by Sortorder, then by name using natural sort
+
+=cut
+
+sub SortedArray {
+my $self = shift;
+
+my @values = $self->Array;
+
+use Sort::Key;
+use Sort::Key::Natural qw(natkeysort);
+
+my @sorted = natkeysort { $_->Category." ".$_->SortOrder." ".$_->Name } @values;
+
+return @sorted;
+
+}
+
+1;
diff --git a/rt/share/html/Elements/EditCustomFieldSelect b/rt/share/html/Elements/EditCustomFieldSelect
index 222fcd9..e8548d8 100644
--- a/rt/share/html/Elements/EditCustomFieldSelect
+++ b/rt/share/html/Elements/EditCustomFieldSelect
@@ -110,7 +110,8 @@ jQuery( function () {
% }
% my $CFVs = $CustomField->Values;
-% while ( my $value = $CFVs->Next ) {
+% my @sorted_values = $CFVs->SortedArray;
+% foreach my $value ( @sorted_values ) {
% my $content = $value->Name;
% my $labelid = "$name-". $value->id;
@@ -186,9 +187,10 @@ $MaxValues => 1
% $_ = lc $_ foreach @Default;
% my $selected;
% my $CFVs = $CustomField->Values;
+% my @sorted_values = $CFVs->SortedArray;
% my @levels;
-% while ( my $value = $CFVs->Next ) {
+% foreach my $value ( @sorted_values ) {
% my $name = $value->Name;
% my $category = $value->Category || '';
% my $level = (split /:/, $category, 2)[0] || '';
% while (@levels) {
--
RT Training - Dallas May 20-21
http://bestpractical.com/training
[rt-users] Sorting by the value of a custom field in search results *numerically*
Hello, It seems that the sorting by custom field in search results is always done alphabetically. For example sorting by CF that contains only integers in descending order: 4 3 2 11 1 Is there a way to sort search results by custom field numerically? -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932 -- RT Training - Dallas May 20-21 http://bestpractical.com/training
