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

[Raed El-Hames]

Ken:

Can't see much wrong , the only thing I noticed CF.{DS-SubjectArea} should be 'CF.{DS-SubjectArea}'
Not sure if it makes any difference
As a first step, I would suggest as you  are directed to the Advanced page, add the ' around the CF name and hit apply, then see what happens and if you can search, if it works, then the next step is finding out why its not adding ' in the first place.

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 17:15
To: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RT Query not allowing any Custom Field selection

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<mailto: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> [mailto: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<mailto: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/f10d7d8f/attachment.htm>