Re: Gnatsweb 4.0 Query Problems

[Chad Walstrom]

"Denny Yang" <denny.yang@alcatel.com>  wrote:
> Was the bug referenced in this old message ever resolved or was
> there a workaround?
> <http://www.cygwin.com/ml/bug-gnats/2001-11/msg00042.html>
> http://www.cygwin.com/ml/bug-gnats/2001-11/msg00042.html.  I am
> having the exact same problem where if the query is more than 1
> expression in Gnatsweb, I get the error "Return code: 415 - Invalid
> expression."
>  
> For example:
> 1) Default query with "Originated by You" and everything else at "any" is OK
> 2) Query with "Originated by You" and State "open" is NOT OK as there is
> more than one expression
> 3) Query with State "open" and Priority "low" is NOT OK again as there is
> more than one expression
>  
> This is running on Solaris 8 if that helps.  Thank you!

Could you try submitting a query with "&debug=all" appended to the URL
and send that to me (edit out the password line).  For example, go to
the query page.  Append the string above.  If there is no
"?param=value" style string in the URL, use "?debug=all" instead.
This will output the full communication with the server from gnatsweb.

Scroll down past the bold "Query Results" and look at the output:

--------- 8< ------------
client_cmd:

expr ((! builtinfield:State[type]="closed")) & 
(builtinfield:originator="chewie")

server_reply: 210 Ok. 
client_cmd:

qfmt "%s%d%s%d%d%d%d%d%d%d%{%Y-%m-%d %H:%M:%S %Z}D%{%Y-%m-%d %H:%M:%S
%Z}D%{%Y-%m-%d %H:%M:%S %Z}D%s%s%s" builtinfield:Number Category
%Synopsis Confidential Severity Priority Responsible State Class
%Submitter-Id Arrival-Date Closed-Date Last-Modified Originator
%Release Notify-List


server_reply: 210 Ok.

client_cmd:

quer

server_reply: 300 PRs follow. 
--------- 8< ------------

You're not going to get a 300.  Rather, you'll get your 415.
Hopefully, we can see what your expression is doing.  Is it possible
you don't have the Originator field in your dbconfig file?

-- 
Chad Walstrom <chewie@wookimus.net>           http://www.wookimus.net/
           assert(expired(knowledge)); /* core dump */