Search for customer facing question

[Eric Sammons]

Hello,

I'm trying to implement a search for customer facing is yes.  Not seeing a
flag for this option I have decided to try boolean_query; however, it seems
my results are the opposite of what I would have expected.  Perhaps I have
the wrong "field" or I am making some bad assumptions here.

My current query:

bugzilla query -p "Red Hat Enterprise MRG" -t
"NEW,ASSIGNED,ON_DEV,POST,MODIFIED,ON_QA"
--boolean_query="cf_cust_facing.notsubstring-yes &
flagtypes.name-substring-mrg-2.4.0 &
flagtypes.name-notsubstring-mrg-2.4.0-" -z "low,medium"

I assumed that the customer facing field was cf_customer_facing based on
the cgi in page source.

My goal is to return only those bugs that are _not_ customer facing.

Can anyone help me correct my query above?

Thanks!

[Cole Robinson]

On 05/13/2013 12:14 PM, Eric Sammons wrote:
> Hello,
>
> I'm trying to implement a search for customer facing is yes.  Not seeing a
> flag for this option I have decided to try boolean_query; however, it seems my
> results are the opposite of what I would have expected.  Perhaps I have the
> wrong "field" or I am making some bad assumptions here.
>
> My current query:
>
> bugzilla query -p "Red Hat Enterprise MRG" -t
> "NEW,ASSIGNED,ON_DEV,POST,MODIFIED,ON_QA"
> --boolean_query="cf_cust_facing.notsubstring-yes &
> flagtypes.name-substring-mrg-2.4.0 & flagtypes.name-notsubstring-mrg-2.4.0-"
> -z "low,medium"
>
> I assumed that the customer facing field was cf_customer_facing based on the
> cgi in page source.
>
> My goal is to return only those bugs that are _not_ customer facing.
>
> Can anyone help me correct my query above?

I didn't look too closely at the above query since honestly the boolean syntax
makes my head spin. What I've been suggesting to various folks who have issues
like this is to do the following:

Build your working query with bugzilla.redhat.com web UI, copy the entire
generated URL out of the location bar, and do

bugzilla query --from-url "<url>"

If you want to see what was wrong in the first step, do 'bugzilla --debug ...'
and look at the difference between the generated queries for command.

- Cole

[Simon Green]

On 14/05/13 02:14, Eric Sammons wrote:
> Hello,
>
> I'm trying to implement a search for customer facing is yes.  Not seeing
> a flag for this option I have decided to try boolean_query; however, it
> seems my results are the opposite of what I would have expected.
>  Perhaps I have the wrong "field" or I am making some bad assumptions here.
>
> My current query:
>
> bugzilla query -p "Red Hat Enterprise MRG" -t
> "NEW,ASSIGNED,ON_DEV,POST,MODIFIED,ON_QA"
> --boolean_query="cf_cust_facing.notsubstring-yes &
> flagtypes.name-substring-mrg-2.4.0 &
> flagtypes.name-notsubstring-mrg-2.4.0-" -z "low,medium"
>
> I assumed that the customer facing field was cf_customer_facing based on
> the cgi in page source.

That is correct. You can also get a list of field names by calling the
Bug.fields RPC call.

cf_cust_facing.notsubstring-yes
flagtypes.name-substring-mrg-2.4.0

I notice in the first statement, you have a full stop between the field
and the type. In the second statement you use a hyphen. Could that be
the problem?