Re: [rt-users] Custom Field Search??

[Mike Diehl]

I think the original poster has a similar question to one I've been pondering.

In my case, I have a custom field in the tickets that stores SLA information.  
I would like to be able to query my tickets to see which tickets have a 
particular SLA setting and are older than a certain age.

Can this be done in the query-by-example web interface?

I hope I haven't hijacked your question.  Please forgive me if I have.




On Tuesday, April 12, 2016 01:59:17 PM Matt Zagrabelny wrote:
> On Tue, Apr 12, 2016 at 1:44 PM, Jesse Maseto
> 
>  wrote:
> > Hello Matt,
> > 
> > Sorry I should have added more content of what I was actually doing.
> > 
> > So I wanted to create a custom field that applies to a users group that
> > their a member of.
> 
> Are you trying to duplicate data that is already in RT, then?
> 
> Group membership is already stored in the database.
> 
>  Once I’ve created this custom field I would like to be
> 
> > able to search for this. Here is a screen shot of where I’m adding this
> > field.
> 
> Sure.
> 
> > I know that if I created this custom field and set to to apply for
> > tickets,
> > I’m able to search using the standard RT search but can’t find a way to
> > search the groups.
> 
> Generally if you want to see what is in a group, you'd go to the Group
> and click the Members link.
> 
> If you want to see what groups a user is in, you'd go to that user and
> click memberships.
> 
> -m
> -
> RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
> * Washington DC - May 23 & 24, 2016

-- 
Mike Diehl
Diehlnet Communications, LLC.
Voice: (505) 903-5700
Fax: (505) 903-5701

-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016

Re: [rt-users] Custom Field Search??

[Matt Zagrabelny]

On Tue, Apr 12, 2016 at 1:44 PM, Jesse Maseto
 wrote:
> Hello Matt,
>
> Sorry I should have added more content of what I was actually doing.
>
> So I wanted to create a custom field that applies to a users group that
> their a member of.

Are you trying to duplicate data that is already in RT, then?

Group membership is already stored in the database.

 Once I’ve created this custom field I would like to be
> able to search for this. Here is a screen shot of where I’m adding this
> field.

Sure.

>
> I know that if I created this custom field and set to to apply for tickets,
> I’m able to search using the standard RT search but can’t find a way to
> search the groups.

Generally if you want to see what is in a group, you'd go to the Group
and click the Members link.

If you want to see what groups a user is in, you'd go to that user and
click memberships.

-m
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016

Re: [rt-users] Custom Field Search??

[Jesse Maseto]

Hello Matt,

Sorry I should have added more content of what I was actually doing.

So I wanted to create a custom field that applies to a users group that
their a member of. Once I’ve created this custom field I would like to be
able to search for this. Here is a screen shot of where I’m adding this
field.

I know that if I created this custom field and set to to apply for tickets,
I’m able to search using the standard RT search but can’t find a way to
search the groups.

Thanks,
-Jesse



Jesse Maseto
Head of Support
ByWater Solutions
Support & Consulting for OSS
Office - Stratford,CT
T/F 888.900.8944
http://bywatersolutions.com
je...@bywatersolutions.com



On Tue, Apr 12, 2016 at 2:35 PM, Matt Zagrabelny  wrote:

> Hey Jesse,
>
> On Tue, Apr 12, 2016 at 12:56 PM, Jesse Maseto
>  wrote:
> > Hello All,
> >
> > Is there a way to Search for a "Custom Field" I’ve added to a ‘Group’?
>
> What is the context?
>
> For instance:
>
> I can see all CFs for groups by drilling down:
>
> Admin -> Global -> Custom Fields -> Groups
>
> -m
>
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016

Re: [rt-users] Custom Field Search??

[Matt Zagrabelny]

Hey Jesse,

On Tue, Apr 12, 2016 at 12:56 PM, Jesse Maseto
 wrote:
> Hello All,
>
> Is there a way to Search for a "Custom Field" I’ve added to a ‘Group’?

What is the context?

For instance:

I can see all CFs for groups by drilling down:

Admin -> Global -> Custom Fields -> Groups

-m
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016

[rt-users] Custom Field Search??

[Jesse Maseto]

Hello All,

Is there a way to Search for a "Custom Field" I’ve added to a ‘Group’?

Best Regards,
-Jesse


Jesse Maseto
Head of Support
ByWater Solutions
Support & Consulting for OSS
Office - Stratford,CT
T/F 888.900.8944
http://bywatersolutions.com
je...@bywatersolutions.com
-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Washington DC - May 23 & 24, 2016

Re: [rt-users] Custom Field search - dynamically modify query string

[Andy Harrison]

Doh...  it would have been awful helpful if I'd mentioned I was
talking about a User custom field.

Regardless, your suggestion actually got me thinking in the right
direction anyway, so it occurred to me exactly how to make this do
what I want.  :)

Thanks!

--
Andy Harrison
public key: 0x67518262


On Wed, Jun 12, 2013 at 12:41 PM, Ruslan Zakirov r...@bestpractical.com wrote:
 Hi,

 You can wrap _CustomFieldLimit in lib/RT/Tickets.pm, but don't forget to
 update link in %dispatch.


 On Tue, Jun 11, 2013 at 11:37 PM, Andy Harrison aharri...@gmail.com wrote:

 This seems rather unlikely, but I wanted to ask just in case someone
 knows a simple way this could be done.

 I have a custom field containing mac address values and I store them
 without the : colon characters.  Is there a simple way, (maybe a
 callback or _Local overlay or something), where I could make it so
 that if someone tries to search by that custom mac address field, that
 I strip out any colons before performing the search?

 Thanks,


 --
 Andy Harrison
 public key: 0x67518262


 --
 RT Training in Seattle, June 19-20: http://bestpractical.com/training




 --
 Best regards, Ruslan.


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] Custom Field search - dynamically modify query string

[Ruslan Zakirov]

Hi,

You can wrap _CustomFieldLimit in lib/RT/Tickets.pm, but don't forget to
update link in %dispatch.


On Tue, Jun 11, 2013 at 11:37 PM, Andy Harrison aharri...@gmail.com wrote:

 This seems rather unlikely, but I wanted to ask just in case someone
 knows a simple way this could be done.

 I have a custom field containing mac address values and I store them
 without the : colon characters.  Is there a simple way, (maybe a
 callback or _Local overlay or something), where I could make it so
 that if someone tries to search by that custom mac address field, that
 I strip out any colons before performing the search?

 Thanks,


 --
 Andy Harrison
 public key: 0x67518262


 --
 RT Training in Seattle, June 19-20: http://bestpractical.com/training




-- 
Best regards, Ruslan.


-- 
RT Training in Seattle, June 19-20: http://bestpractical.com/training

Re: [rt-users] custom field search

[Roy El-Hames]

Thanks Torsten , upgrading is not a simple process in here, I have to go 
through dev cycle etc .. as there is a risk of something breaking
I searched the mailing list and wiki before sending my mail yesterday 
could n't find anything about pacthes or fix for this, You wont happen 
to know the thread ??

Roy

Torsten Brumm wrote:

Hi Roy,

so far i can remember, there was a problem some sub releases ago with 
CF's

searches and jesse also send a patch or fix to the list. I'm not sure for
which version but i think it was 3.6.1. Have you tryed to upgrade to 
3.6.3?

Here it is working.

Torsten

2007/2/8, Roy El-Hames [EMAIL PROTECTED]:


Hi there;
RT 3.6.1 , apache2 mod_perl2 and mysql 5

I have asked this question before , but did not get a valid response ,
I have a problem searching custom fields values, I can display them in
the search results , but I can't search for them eg a search
'CF.{Customer_Ref}' LIKE '1234' AND Queue = 'Testing' display 0 results
where I know there is atleast 1 ..
I can see and edit cf's so its not permission issue ...

I have removed all customisation (apart of RT_SiteConfig) so its nothing
I did ..
the problem apply to all types of custom fields.

Any help will be appreciated.

Thanks;
Roy
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com







___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Custom Field Search returns 0 records

[Roy El-Hames]

I tend to agree with Robert from my experience CF searches do n't work 
(on 3.6.1/3.6.2) , you can't search for them or order by them
I think there was a patch released few weeks back, just can't find it at 
the moment ..

Roy

Mathew wrote:

Have you attached the CF to anything.  Not only do you have to create it
but it has to be enabled under Global-Custom Fields.

Mathew

Gendron, Robert wrote:
  

Hello,

This is my first attempt at using the Custom Field feature in RT.  However, when I try to run a query using the custom field the system does not return any records.  


Here are my systems specifics:
RT Version 3.6.1
MySQL 5.0.27


Query:
 Queue = 'Test' AND 'CF.{Test}' LIKE 'Test'

I have saved one record with the Custom Field test set to 'Test'

Could this be a configuration error?  Has something been fixed since 3.6.1 to 
address this issue?

Thank you for your assistance.

Bob G
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com






___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


  


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Custom Field Search returns 0 records

[Mathew]

I've created three custom fields.  Each a single Select type.  I've
never had problems.  I'm using 3.6.1.

Mathew

Roy El-Hames wrote:
 I tend to agree with Robert from my experience CF searches do n't work
 (on 3.6.1/3.6.2) , you can't search for them or order by them
 I think there was a patch released few weeks back, just can't find it at
 the moment ..
 Roy
 
 Mathew wrote:
 Have you attached the CF to anything.  Not only do you have to create it
 but it has to be enabled under Global-Custom Fields.

 Mathew

 Gendron, Robert wrote:
  
 Hello,

 This is my first attempt at using the Custom Field feature in RT. 
 However, when I try to run a query using the custom field the system
 does not return any records. 
 Here are my systems specifics:
 RT Version 3.6.1
 MySQL 5.0.27


 Query:
  Queue = 'Test' AND 'CF.{Test}' LIKE 'Test'

 I have saved one record with the Custom Field test set to 'Test'

 Could this be a configuration error?  Has something been fixed since
 3.6.1 to address this issue?

 Thank you for your assistance.

 Bob G
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com


 

 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
 Buy a copy at http://rtbook.bestpractical.com

   
 
 
 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Custom Field Search returns 0 records

[Roy El-Hames]

Well I must be missing something .. I tried searching for both cf where 
its a select a value , or a cf where you enter one value neither worked 
both returned 0 where I know there is atleast 10 tickets with these cf's 
in the queue I am searching in ..

Do you know where to look  in the code??

Regards;
Roy

Mathew wrote:

I've created three custom fields.  Each a single Select type.  I've
never had problems.  I'm using 3.6.1.

Mathew

Roy El-Hames wrote:
  

I tend to agree with Robert from my experience CF searches do n't work
(on 3.6.1/3.6.2) , you can't search for them or order by them
I think there was a patch released few weeks back, just can't find it at
the moment ..
Roy

Mathew wrote:


Have you attached the CF to anything.  Not only do you have to create it
but it has to be enabled under Global-Custom Fields.

Mathew

Gendron, Robert wrote:
 
  

Hello,

This is my first attempt at using the Custom Field feature in RT. 
However, when I try to run a query using the custom field the system
does not return any records. 
Here are my systems specifics:

RT Version 3.6.1
MySQL 5.0.27


Query:
 Queue = 'Test' AND 'CF.{Test}' LIKE 'Test'

I have saved one record with the Custom Field test set to 'Test'

Could this be a configuration error?  Has something been fixed since
3.6.1 to address this issue?

Thank you for your assistance.

Bob G
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com





___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

  
  






  


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

RE: [rt-users] Custom Field Search returns 0 records

[Gendron, Robert]

I did try to enable it under Global.  It did not make a difference.

-Original Message-
From: Mathew [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 16, 2007 7:17 PM
To: Gendron, Robert
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Custom Field Search returns 0 records


Have you attached the CF to anything.  Not only do you have to create it
but it has to be enabled under Global-Custom Fields.

Mathew

Gendron, Robert wrote:
 Hello,
 
 This is my first attempt at using the Custom Field feature in RT.  However, 
 when I try to run a query using the custom field the system does not return 
 any records.  
 
 Here are my systems specifics:
 RT Version 3.6.1
 MySQL 5.0.27
 
 
 Query:
  Queue = 'Test' AND 'CF.{Test}' LIKE 'Test'
 
 I have saved one record with the Custom Field test set to 'Test'
 
 Could this be a configuration error?  Has something been fixed since 3.6.1 to 
 address this issue?
 
 Thank you for your assistance.
 
 Bob G
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com
 
 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Custom Field Search returns 0 records

[Mathew]

And just to cover bases, you have the SeeCustomField right?

Mathew

Gendron, Robert wrote:
 I did try to enable it under Global.  It did not make a difference.
 
 -Original Message-
 From: Mathew [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, January 16, 2007 7:17 PM
 To: Gendron, Robert
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] Custom Field Search returns 0 records
 
 
 Have you attached the CF to anything.  Not only do you have to create it
 but it has to be enabled under Global-Custom Fields.
 
 Mathew
 
 Gendron, Robert wrote:
 Hello,

 This is my first attempt at using the Custom Field feature in RT.  However, 
 when I try to run a query using the custom field the system does not return 
 any records.  

 Here are my systems specifics:
 RT Version 3.6.1
 MySQL 5.0.27


 Query:
  Queue = 'Test' AND 'CF.{Test}' LIKE 'Test'

 I have saved one record with the Custom Field test set to 'Test'

 Could this be a configuration error?  Has something been fixed since 3.6.1 
 to address this issue?

 Thank you for your assistance.

 Bob G
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]


 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com


 
 
 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Custom Field Search returns 0 records

[Gendron, Robert]

Hello,

This is my first attempt at using the Custom Field feature in RT.  However, 
when I try to run a query using the custom field the system does not return any 
records.  

Here are my systems specifics:
RT Version 3.6.1
MySQL 5.0.27


Query:
 Queue = 'Test' AND 'CF.{Test}' LIKE 'Test'

I have saved one record with the Custom Field test set to 'Test'

Could this be a configuration error?  Has something been fixed since 3.6.1 to 
address this issue?

Thank you for your assistance.

Bob G
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Re: [rt-users] Custom Field Search returns 0 records

[Mathew]

Have you attached the CF to anything.  Not only do you have to create it
but it has to be enabled under Global-Custom Fields.

Mathew

Gendron, Robert wrote:
 Hello,
 
 This is my first attempt at using the Custom Field feature in RT.  However, 
 when I try to run a query using the custom field the system does not return 
 any records.  
 
 Here are my systems specifics:
 RT Version 3.6.1
 MySQL 5.0.27
 
 
 Query:
  Queue = 'Test' AND 'CF.{Test}' LIKE 'Test'
 
 I have saved one record with the Custom Field test set to 'Test'
 
 Could this be a configuration error?  Has something been fixed since 3.6.1 to 
 address this issue?
 
 Thank you for your assistance.
 
 Bob G
 ___
 http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
 
 Community help: http://wiki.bestpractical.com
 Commercial support: [EMAIL PROTECTED]
 
 
 Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
 Buy a copy at http://rtbook.bestpractical.com
 
 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com

[rt-users] Custom field search on RT 3.6.0pre0

[Rangarajan Radhakrishnan]

I have read a few posts on this and I am not sure those posts apply in
this case.

I am dealing with RT 3.6.0pre0 under Oracle 10g:

When doing searches, I have this in the Current search area:
Queue = 'queuename'
AND 'CF.{customfieldname}' = 'Customvalue'

Where customfield expects a single value (a string).

On clicking add and search the query returns no rows, even though there
are rows satisfying the criteria.

Additional info:
(1) The customfield is queue specific
(2) I have already tried adding search criteria using GUI which adds
'CF.{customfieldname}' = 'Customvalue'
(3) I have also tried things (using Advanced) such as:
 (a) 'CF.{queuename.customfieldname}' = 'Customvalue'
 (b) 'CF.{queuename}.{customfieldname}' = 'Customvalue'

I am in trying to get access to V$ views so that I can see what is
getting executed on the oracle side.

am I missing something very simple?

Thanks


___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html