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: [email protected]
[mailto:[email protected]] On Behalf Of Kenneth Crocker
Sent: 15 October 2010 17:15
To: [email protected]
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
<[email protected]<mailto:[email protected]>> 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:
[email protected]<mailto:[email protected]>
[mailto:[email protected]<mailto:[email protected]>]
On Behalf Of Kenneth Crocker
Sent: 15 October 2010 00:40
To: [email protected]<mailto:[email protected]>
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
RT Training in Washington DC, USA on Oct 25 & 26 2010
Last one this year -- Learn how to get the most out of RT!
