[rt-users] RT Query not allowing any Custom Field selection

[Kenneth Crocker]

Raed,

Just keep it up guy, and I'm gonna end up owing you an entire brewery. ;-).

This is what is in "Advance":

( Queue = 'DS-BRS' OR Queue = 'DS-Development' ) AND CF.{DS-SubjectArea} =
'Expense'

and it won't let me get out of it. If I hit "ShowResults", it just shows ALL
tickets in those two Queues, regardless of the CF value.

The funny thing is, I checked the DB records and the values are there, the
OBJECTCUSTOMFIELDVALUES records are there (*not* disabled) for several
tickets, the Tickets *show the values* in Display, Privileges are correct
for the group I'm in (plus I'm a SuperUser), CF is applied to these Queues
(duh, wouldn't see them in Display otherwise), etc. All data in the DB seems
quite correct. RT is being VERY STUBBORN about this.

Any ideas?

Kenn
LBNL

On Fri, Oct 15, 2010 at 2:25 AM, Raed El-Hames <Raed.El-Hames at vialtus.com>wrote:

>  Hi Ken:
>
>
>
> It usually throw you into the Advanced tab when the sql generated is not
> properly formatted into FromSQL ..
>
> Can you share what you get in the advanced Query ? it may also be a problem
> in the displayed fields listed in Format.
>
>
>
> Regards;
>
> Roy
>
>
>
>
>
>
>
> *From:* rt-users-bounces at lists.bestpractical.com [mailto:
> rt-users-bounces at lists.bestpractical.com] *On Behalf Of *Kenneth Crocker
> *Sent:* 15 October 2010 00:40
> *To:* rt-users at lists.bestpractical.com
> *Subject:* [rt-users] RT Query not allowing any Custom Field selection
>
>
>
> To List,
>
> I'm getting a wierd result when trying to create a search looking for a
> certain value in a Custom Field that is applied to a couple Queues.
> I check the Queues and add them, no problem. I check the Custom Field and
> add it and I am immediately thrown into *"Advanced"*. Every change I make
> after that cannot be applied. I just end up back in the *"Advanced"*screen. It acts like there is no such Custom FIeld. I tried "Like" and "is"
> and no joy.
>
> I've checked the Custom Field and it *IS* applied to those Queues.
> The Values *ARE* available for "Select One"
> I am a SuperUser so I *should* have rights to it, but I went ahead and
> added "AdminCustomField", "ModifyCustomField" and "SeeCustomField" to the
> group I'm in anyway. Still no joy.
>
> When I run an SQL in SQL Navigator against the OBJECTCUSTOMFIELDVALUES
> Table with this code:
>
> select *
> from OBJECTCUSTOMFIELDVALUES
> where CustomField = 50111
>   and (Content = 'Ledger' or Content = 'Expense');
>
> I got 12 records. None are disabled.
>
> I'm in 3.8.7 and Queries *without *Custom Fields are working fine.
>
> Has anyone noticed this?
>
> Was it mentioned awhile back and I missed it?
>
> Thanks in advance.
>
> Kenn
> LBNL
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20101015/4fca0fdb/attachment.htm>