Queryproblems

[Max Bernhardt - extern TAGP - Tel. 3749]

Hi,

i just installed gnats-4.0 and gnatsweb-4.0. gnatsd is running and seems

to be working fine.

But ...

I installed the default database, but left it alone, then i installed a
second
database called 'plami' and customized it (added access rights, added
users, etc).
Then i added a test pr in the class 'support'.

Now when i do the following:

    query-pr -d plami --expr 'Class=="support"'

everything is fine and dandy. I get the info to my pr.

When i try to to the same in gnatsweb it doesn't work!
On the first try i received the following answer:

    Return code: 415 - Invalid expression.

After turning on the client_debug mode, I got the following output:

    client_cmd:
    rset
    client_cmd:
    qfmt "%s%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"
builtinfield:Number Notify-List Category Synopsis Confidential Severity
Priority Responsible State Class Submitter-Id Arrival-Date Closed-Date
Last-Modified Originator Release
    client_cmd:
    expr '((! builtinfield:State[type]="closed")) & (State~"^open$")'
    Return code: 415 - Invalid expression.

After some experimenting, it seemed to me that the parentheses seemed to
be the problem.
(Also I found a thread in the Mailinglist complaining about the operator
'~'. One should use the
operator '==' instead) So i changed the relevant lines in submitquery
and appendexpr. The reply
was ok, so i thought everything was fine until ...

Well i wanted only the pr's that are open, so i unchecked "Ignore
Closed" and got the following reply:

    client_cmd:
    rset
    client_cmd:
    qfmt "%s%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"
builtinfield:Number Notify-List Category Synopsis Confidential Severity
Priority Responsible State Class Submitter-Id Arrival-Date Closed-Date
Last-Modified Originator Release
    client_cmd:
    expr 'State=="open"'
    client_cmd:
    quer
    Return code: 220 - No PRs match.

This really is NOT what i expected! After some further experimenting it
seems to me that the
expression is not really evaluated at all.

My System is Solaris8 and i'm using either Netscape7 or Firefox0.8.

Anybody can help,  please ...

Regards

MAx



--

"There is no spoon ..." ;-)

Max.Bernhardt.vcf
Description: Card for Max Bernhardt - extern TAGP - Tel. 3749