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

[Kenneth Crocker]

Raed,

That did it. Where did you find that? I don't remember any instructions on
having to use quotes around a CF name. Did I miss that or did you come by
that info via trail & error?

Now, again, I owe you *MORE* beer. ;-).

Thanks.

Kenn
LBNL

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

>  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>
> 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/ea1320bf/attachment.htm>