Attachment 312751 Details for Bug 456681 – v1 patch to remove format=ft and fix ordering in named queries for 3.2 bz

[patch] v1 patch to remove format=ft and fix ordering in named queries for 3.2 bz

update_cf_queries.patch (text/plain), 1.11 KB, created by Noura El hawary on 2008-07-28 05:25:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Noura El hawary

Created: 2008-07-28 05:25:33 UTC

Size: 1.11 KB

patch

obsolete

>Index: update_cf_queries.pl
>===================================================================
>RCS file: /cvs/qa/rh_bugzilla_3/redhat/update_cf_queries.pl,v
>retrieving revision 1.1
>diff -p -u -r1.1 update_cf_queries.pl
>--- update_cf_queries.pl	2 May 2008 15:33:29 -0000	1.1
>+++ update_cf_queries.pl	28 Jul 2008 05:20:55 -0000
>@@ -54,7 +54,7 @@ else {
>             "UPDATE namedqueries SET query = ? WHERE userid = ? AND name = ?"
>         );
>         $update_query_sth->execute( $new_query, $userid, $name );
>-
>+        print "$userid, $name\n\n";
>         $count++;
>     }
> 
>@@ -115,6 +115,15 @@ sub convert_query {
>     my $new_query = canonicalise_query($cgi);
>     $new_query =~ s/=$_/=cf_$_/g foreach @custom_fields;
> 
>+    # remove format "&format=ft" from the query string
>+    $new_query =~ s/&format=ft//g;
>+    
>+    # change Bug Number Ascending to just Bug Number 
>+    $new_query =~ s/Bug%20Number%20Ascending/Bug%20Number/g;
>+
>+    # change Bug Number Descending to bugs.bug_id+desc
>+    $new_query =~ s/Bug%20Number%20Descending/bugs\.bug_id%20desc/g;
>+    
>     print "New Query: $new_query\n\n";
> 
>     return $new_query;

Actions: View | Diff

Attachments on bug 456681: 312751 | 312768