Difference between revisions of "CustomField"

From Request Tracker Wiki
Jump to navigation Jump to search
Line 38: Line 38:
== Modify CustomField Value ==
== Modify CustomField Value ==


=== RT 3.6 ===


Use the bulk update option
[[File:Update-CF-Values.png|Updating custom field values on Tickets|thumb|500px]]


=== RT 3.4 ===
There are a number of ways to update a custom field's value depending on the custom field type.


Try the script below based on [http://use.perl.org/~Robrt/journal/25746 this journal entry]. This example renames '[[TaskType]]' values that were 'Sales Call' to 'Prospect' in the 'Sales' queue.
;Tickets
:* Click on the desired ticket, then click on Basics from the submenu or click directly on the Custom Field portlet tab, to bring you to the Modify Ticket page (see screenshot)
:* From the ticket, you can click on Jumbo in the submenu
:* You can also update the custom fields of multiple tickets at once, by running a search, then click on Bulk Update from the submenu


<pre>
; Assets
<nowiki>#!/home/perl/bin/perl
:* Click on the desired asset, then click on Basics from the submenu or click directly on the Custom Field portlet tab, to bring you to the Modify Asset page
use strict;
:* You can also update the custom fields of multiple assets at once, by running a search from within Assets, then click on Bulk Update from the submenu
use warnings;
 
use lib qw(../lib);
; Articles
use RT;
:* Click on the desired article, then click on Modify from the submenu to bring you to the Modify Article page
use RT::Queues;
 
use RT::Tickets;
; Group
use Data::Dumper;
:* Click on the desired group from Admin -> Groups -> Select, this will bring you to the Basics page where you can update the custom field accordingly
 
# CONFIGURATION
; User
my $queue = 'Sales';
:* Click on the desired user from Admin -> Users -> Select, this will bring you to the Modify User page where you can update the custom field accordingly
my $cf_name = 'TaskType';
my $old_value = 'Sales Call'; # NB: This must be a valid value for the CF
my $new_value = 'Prospect';
# END CONFIGURATION
RT::LoadConfig();
RT::Init();
my $tx = RT::Tickets-&gt;new($RT::SystemUser);
my $cf = RT::CustomField-&gt;new($RT::SystemUser);
my $q  = RT::Queue-&gt;new($RT::SystemUser);
$tx-&gt;FromSQL(qq[queue="$queue" and "cf.$queue.{$cf_name}" = '$old_value']);
$q-&gt;Load($queue);
$cf-&gt;LoadByNameAndQueue(Queue =&gt; $q-&gt;Id, Name =&gt; $cf_name);
unless( $cf-&gt;id ) {
  # queue 0 is special case and is a synonym for global queue
  $cf-&gt;LoadByNameAndQueue( Name =&gt; $cf_name, Queue =&gt; '0' );
}
unless( $cf-&gt;id ) {
  print "No field $cf_name in queue ". $q-&gt;Name;
  die "Could not load custom field";
}
my $i=0;
while (my $t = $tx-&gt;Next) {
  print "Processing record #" . ++$i . "\n";
  my $type = $t-&gt;FirstCustomFieldValue($cf_name);
  print "Old Type = $type\n";
  my ($ret, $msg) = $t-&gt;DeleteCustomFieldValue(
    Field =&gt; $cf-&gt;Id,
    Value =&gt; $type
  );
  die "Error deleting old value: $msg" unless $ret;
  $t-&gt;AddCustomFieldValue(
    Field =&gt; $cf-&gt;Id,
    Value =&gt; 'Prospect'
  );
  $type = $t-&gt;FirstCustomFieldValue($cf_name);
  print "New Type = $type\n";
}
</nowiki>
</pre>


== Simple Search Custom Field Values ==
== Simple Search Custom Field Values ==

Revision as of 13:33, 29 March 2019

A Custom Field (CF) is a user defined property that can be applied to various parts of RT. Each custom field has a Name, Description and Type.

Custom Field Types

RT supports the following CF types:

  • Select one value
  • Select multiple values
  • Enter one value
  • Enter multiple values
  • Fill in one text area (of which you can edit the size: ChangeCustomFieldTextAreaSize)
  • Fill in one wikitext area
  • Upload one image
  • Upload multiple images
  • Upload one file
  • Upload multiple files
  • Combobox: Select or enter one value
  • Enter one value with autocompletion
  • Enter multiple values with autocompletion
  • Select date
  • Select datetime
  • Enter one IP address
  • Enter multiple IP addresses
  • Enter one IP address range
  • Enter multiple IP address ranges

You can define global CustomFields or specific to a Queue (see CUSTOM FIELDS IN QUEUES). They can apply to a Ticket, Article, Asset, Group, User or Ticket Transactions.

How to set up a custom field in a nutshell

First, create the Custom Field

  1. Login as one with admin/superuser rights
  2. Go to Admin -> CustomField -> Create
  3. Fill out the form appropriately and click Create
  4. From the submenu, click on "Applies to" and check and save the desired options. Note: This step is not applicable with the Custom Field types, "Groups" or "Users".

Modify CustomField Value

Updating custom field values on Tickets

There are a number of ways to update a custom field's value depending on the custom field type.

Tickets
  • Click on the desired ticket, then click on Basics from the submenu or click directly on the Custom Field portlet tab, to bring you to the Modify Ticket page (see screenshot)
  • From the ticket, you can click on Jumbo in the submenu
  • You can also update the custom fields of multiple tickets at once, by running a search, then click on Bulk Update from the submenu
Assets
  • Click on the desired asset, then click on Basics from the submenu or click directly on the Custom Field portlet tab, to bring you to the Modify Asset page
  • You can also update the custom fields of multiple assets at once, by running a search from within Assets, then click on Bulk Update from the submenu
Articles
  • Click on the desired article, then click on Modify from the submenu to bring you to the Modify Article page
Group
  • Click on the desired group from Admin -> Groups -> Select, this will bring you to the Basics page where you can update the custom field accordingly
User
  • Click on the desired user from Admin -> Users -> Select, this will bring you to the Modify User page where you can update the custom field accordingly

Simple Search Custom Field Values

SearchCustomField

Custom Fields in Email Ticket Creation

OnCreateCheckCF