Querying tickets based on current user custom field

Hi,

I have added successfully 2 custom fields to my fresh rt instance :

  • a single value region dropdown field to tickets
  • a favorite-regions field to users

I can easily query tickets against the ticket custom field, but I would like
to build a query against the current users custom field : something like
"give me the tickets who’s region are in my favorites".

From what I’ve read in the RT book and experimented, it doesn’t seem far off
but I can’t find the write syntax. I’ve tried things like ‘CF.region =
CurrentUser.CF.favorite-region’ (pseudo code).
Can this really be done ?

Thanks in advance.

View this message in context: http://www.nabble.com/Querying-tickets-based-on-current-user-custom-field-tp21702520p21702520.html

Hello again,

Been stuck on this since : I guess the search builder page won’t make it up
to that…
Can anyone give me a hint on how to do this ?

I’ve looked Search/Generic.pm after working on Custom Conditions and Actions
but there is much less (any?) documentation on this : how to extend it and
then use it.

Any help appreciated.
Nicolas.

nseigne wrote:

Hi,

I have added successfully 2 custom fields to my fresh rt instance :

  • a single value region dropdown field to tickets
  • a favorite-regions field to users

I can easily query tickets against the ticket custom field, but I would
like to build a query against the current users custom field : something
like “give me the tickets who’s region are in my favorites”.

From what I’ve read in the RT book and experimented, it doesn’t seem far
off but I can’t find the write syntax. I’ve tried things like ‘CF.region =
CurrentUser.CF.favorite-region’ (pseudo code).
Can this really be done ?

Thanks in advance.

View this message in context: http://www.nabble.com/Querying-tickets-based-on-current-user-custom-field-tp21702520p21746982.html