Queue CFs in query builder?

Hi,

I’ve created a couple of global queue CFs in order to add some
categorisation to our queues.

I was hoping these would appear in the query builder so I can easily
restrict my queries to these categories but they don’t :frowning: Nor does it
appear to work if I use the advanced builder to specify them manually.

I’m not familiar enough with the query builder code to know if it would
be easy to add this functionality in. Comments anyone?

Olly

May be you just forgot to apply those fields? It’s not enough to create them.On Wed, Aug 27, 2008 at 2:16 AM, Olly Stephens Olly.Stephens@arm.com wrote:

Hi,

I’ve created a couple of global queue CFs in order to add some
categorisation to our queues.

I was hoping these would appear in the query builder so I can easily
restrict my queries to these categories but they don’t :frowning: Nor does it
appear to work if I use the advanced builder to specify them manually.

I’m not familiar enough with the query builder code to know if it would
be easy to add this functionality in. Comments anyone?

Olly


List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

Best regards, Ruslan.

rt-devel-bounces@lists.bestpractical.com wrote:

May be you just forgot to apply those fields? It’s not enough to
create
them.

Nope, they’re definitely applied. I see them when I modify a queue and
I use them in a custom version of SelfService/CreateTicketInQueue to
arrange the queues into logical groupings.

Looking at the code that builds the Query/Build.html page, it uses
RT::CustomFields LimitToQueue and LimitToGlobal methods to get the
relevant set of CFs; both of these limit their searches to lookup type
’RT::Queue-RT::Ticket’, but the CF I want has a lookup type of
’RT::Queue’ so it explains why it won’t be found.

Likewise, if I use the advanced query builder to add a " CF.{MyQueueCF}
= ‘X’ " condition and look at the generated SQL, I can see that it will
also only work for ticket-based CFs, not queue-based ones.

I think I’ve convinced myself that it won’t work with the current
release, but I don’t know enough about the query building process to
know how easy a feature it would be to add. I’d really like to see it
in the product. If someone can confirm that my conclusions are correct,
I’ll file an enhancement request.

Cheers,

Olly

In 3.6 CF are associated to the queue. When you select the queue in the
Query Builder it should bring up the CFs for that queue when you
refresh.El mié, 27-08-2008 a las 06:24 +0400, Ruslan Zakirov escribió:

May be you just forgot to apply those fields? It’s not enough to create them.

On Wed, Aug 27, 2008 at 2:16 AM, Olly Stephens Olly.Stephens@arm.com wrote:

Hi,

I’ve created a couple of global queue CFs in order to add some
categorisation to our queues.

I was hoping these would appear in the query builder so I can easily
restrict my queries to these categories but they don’t :frowning: Nor does it
appear to work if I use the advanced builder to specify them manually.

I’m not familiar enough with the query builder code to know if it would
be easy to add this functionality in. Comments anyone?

Olly


List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

Olly Stephens wrote:

Hi,

I’ve created a couple of global queue CFs in order to add some
categorisation to our queues.

I was hoping these would appear in the query builder so I can easily
restrict my queries to these categories but they don’t :frowning: Nor does it
appear to work if I use the advanced builder to specify them manually.

I’m not familiar enough with the query builder code to know if it would
be easy to add this functionality in. Comments anyone?

Olly


List info:
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel

HI,

you just have to add the queue to the query,
then the CF fields are available in the search builder.

Chris
View this message in context: http://www.nabble.com/Queue-CFs-in-query-builder--tp19171489p19216059.html