Re: [rt-users] remote sql server w/ ssl RT make upgrade-database problem
I had the same problem. As I find out the update-database task was trying to connect to the DB using root user, which I don't have access to instead of my RT database user. The upgrade-database was asking for password, but it did not asked for a user which should be used. So made a change in /sbin/rt-setup-database: my $dba_user = my_rt_database_user_name. -- View this message in context: http://requesttracker.8502.n7.nabble.com/remote-sql-server-w-ssl-RT-make-upgrade-database-problem-tp57521p57585.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Different template according to requestor email address
Hello, There are tickets coming from internal users (@interal.aa) and from external users (@gmail.com, @yahoo.com, etc). I want to send different king of template according to requestor address. Subject: {$Ticket-Subject} Content-Type: text/html { if($Ticket-RequestorAddresses =~ /@internal.aa/) { You are internal } else { You are external } } Everything works fine if there are only one requestor (a...@internal.aa or a...@google.com), but if there are situation like this (a...@internal.aa, a...@gmail.com) both, the gmail.com and internal.aa mails get message saying You are internal. How can I separate these to get different messages according to their email address? -- View this message in context: http://requesttracker.8502.n7.nabble.com/Different-template-according-to-requestor-email-address-tp57533.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Custom ticket update page not submiting values
Hello, I'm trying to do a ticket feedback page in SelfService, for user to evaluate the response to the ticket. I took a Update.html code from SelfService/ and changed it to display only the fields that I need. But after clicking the submit button, values of the customfield does not change, I get the Display.html view, but the URL is lef the same: Feedback.html. Logs also don't show any activity, like nothing was happening. How to submit my data so it would update the ticket fields? Here I create a form with 2 customfiels and comment box. /SelfService/Elements/Header, Title =loc('Leave feedback for ticket #[_1]', $Ticket-id) form action=Feedback.html method=post enctype=multipart/form-data name=TicketUpdate input type=quot;hiddenquot; class=quot;hiddenquot; name=quot;Tokenquot; value=quot;lt;% $ARGS{'Token'} % / input type=quot;hiddenquot; class=quot;hiddenquot; name=quot;idquot; value=quot;lt;%$Ticket-Id% / input type=hidden class=hidden name=UpdateType value=response / /Elements/ListActions, actions = \@results % while ( my $CustomField = $CustomFields-Next ) { % if(exists($FeedbackCFs-{$CustomField-Id})) { % my @add = (NamePrefix = 'Bulk-Add-CustomField-', CustomField = $CustomField, Rows = 5, % Multiple = ($CustomField-MaxValues ==1 ? 0 : 1) , Cols = 25, % Default = $ARGS{Add-CustomField-$CustomField-Id-Values} || $ARGS{Add-CustomField-$CustomField-Id-Value}, ); % % my $Values = $Ticket-CustomFieldValues( $CustomField-Id ); % my $count = $Values-Count; tr id=quot;CF-lt;%$CustomField-id%-ShowRow input type=quot;hiddenquot; class=quot;hiddenquot; name=quot;Object-RT::Ticket-lt;%$Ticket-Id%-CustomField-%$CustomField-Id%-Values-Magic value=1 % } % } %} % if($showComment) { %} % $CustomField-Name %: % if($count == 0) { % if ($CustomField-Type eq 'Select') { /Elements/EditCustomFieldSelect, @add % } elsif ($CustomField-Type eq 'Combobox') { /Elements/EditCustomFieldCombobox, @add % } elsif ($CustomField-Type eq 'Freeform') { /Elements/EditCustomFieldFreeform, @add % } elsif ($CustomField-Type eq 'Text') { /Elements/EditCustomFieldText, @add % } elsif ($CustomField-Type eq 'Date') { /Elements/EditCustomFieldDate, @add, Default = undef % } elsif ($CustomField-Type eq 'DateTime') { % # Pass datemanip format to prevent another tz date conversion /Elements/EditCustomFieldDateTime, @add, Default = undef, Format = 'datemanip' % } % } else { % $showComment = 0; % unless ( $count ) { |/l(no value)/amp; % } elsif ( $count == 1 ) { % $print_value-( $CustomField, $Values-First ); % } else { ul % while ( my $Value = $Values-Next ) { li % $print_value-( $CustomField, $Value ); /li % } /ul % } Komentaras: /Elements/MessageBox, Name=UpdateContent, IncludeSignature = 1, %ARGS /Elements/Submit, Label = loc('Submit feedback'), Name = 'SubmitTicket', id = 'SubmitTicket' /form /Elements/ShowHistory, Object = $Ticket, ShowHeaders = $ARGS{'ShowHeaders'}, DownloadableHeaders = 0 Here I check for a submit button click and some do some validation. if ( exists $ARGS{SubmitTicket} ) { my $kokybe = $ARGS{'Bulk-Add-CustomField-102-Values'}; if($kokybe $kokybe =~ /Puikiai/) { $m-callback(CallbackName = 'BeforeDisplay', Ticket = \$Ticket, ARGSRef = \%ARGS); return $m-comp('Display.html', TicketObj = $Ticket, %ARGS); } elsif($kokybe) { my $atsiliepimas = $ARGS{'Bulk-Add-CustomField-103-Value'}; if($atsiliepimas $atsiliepimas =~ /Kita/) { my $komentaras = $ARGS{'UpdateContent'}; if($komentaras) { $m-callback(CallbackName = 'BeforeDisplay', Ticket = \$Ticket, ARGSRef = \%ARGS); return $m-comp('Display.html', TicketObj = $Ticket, %ARGS); } else { push @results, loc('Fill the field Komentaras with your comment'); } } elsif($atsiliepimas) { $m-callback(CallbackName = 'BeforeDisplay', Ticket = \$Ticket, ARGSRef = \%ARGS); return $m-comp('Display.html', TicketObj = $Ticket, %ARGS); } else { push @results, loc('Choose appropriate value for Atsiliepimas'); } } } -- View this message in context: http://requesttracker.8502.n7.nabble.com/Custom-ticket-update-page-not-submiting-values-tp57496.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] Calculate values in charts by percent
Hello, http://requesttracker.8502.n7.nabble.com/file/n57497/box.png How can I add my own functions to this fields set, to be more specific, calculate by percent? Regards -- View this message in context: http://requesttracker.8502.n7.nabble.com/Calculate-values-in-charts-by-percent-tp57497.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training - Boston, September 9-10 http://bestpractical.com/training
[rt-users] No __TimeLeft__ value in search result
Hello, I set my custom search format in RT_SiteConfig like this: This is the time values for the ticket: Created:Tue Feb 18 13:28:25 2014 Starts: Tue Feb 18 13:28:25 2014 Started:Tue Feb 18 13:28:25 2014 Last Contact: Tue Feb 18 13:30:25 2014 Due:Wed Feb 19 00:00:00 2014 Still, the __TimeLeft__ field is always blank. What is the problem? -- View this message in context: http://requesttracker.8502.n7.nabble.com/No-TimeLeft-value-in-search-result-tp56683.html Sent from the Request Tracker - User mailing list archive at Nabble.com. -- RT Training London, March 19-20 and Dallas May 20-21 http://bestpractical.com/training
[rt-users] RT 4.2.1 RSS feed of articles
Hello, Is it possible to make a RSS feed from articles like with the tickets? -- View this message in context: http://requesttracker.8502.n7.nabble.com/RT-4-2-1-RSS-feed-of-articles-tp55950.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Get Queue CustomField value
Hello, I have a queue named AAA. Then there are a custum field for queues - SubUnit with values: a, b, c. Queue AAA has a value 'a' of SubUnit custom field. How can I extract that value? I want to use that value on scrip. -- View this message in context: http://requesttracker.8502.n7.nabble.com/Get-Queue-CustomField-value-tp55642.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Update all tickets of queue
Hello, Is it posible with the help of scrip to do such thing: My Queue has a custom field and when you create a ticket in that queue, the ticket custom field is set by the value of queue custom field value. How can I change all queue tickets custom field value on Queue custom field value change? -- View this message in context: http://requesttracker.8502.n7.nabble.com/Update-all-tickets-of-queue-tp55643.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] Internal authentification only for REST API
Done that. But now REST doesn't require any password at all? Is it also possible to require RT internal auth in specific folder? Thanks in advance. -- View this message in context: http://requesttracker.8502.n7.nabble.com/Internal-authentification-only-for-REST-API-tp55512p55535.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Language bar on RT meniu
Hello, Is it possible or maybe already done somewhere (can't find) to make a language button for user to change his RT language on demand? Regards -- View this message in context: http://requesttracker.8502.n7.nabble.com/Language-bar-on-RT-meniu-tp55510.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Internal authentification only for REST API
Hello, I'm using externat auth source (shibboleth) for my RT installation, which redirect me to the login page, where I need to enter my username and password. While using the REST API, I store my user in RT database, so I could authenticate using database not the external source. But after succesfull authentication via REST API I still get redirected to the external login page. How to fix that? Regards, Andrius -- View this message in context: http://requesttracker.8502.n7.nabble.com/Internal-authentification-only-for-REST-API-tp55512.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Group chart by custom field of Queue
Hello, My queues in RT belong to some sort of departament (custom field). How can I get a chart, showing tickets by departament? What i find out, is that charts are made by ticked dependencies, but not the the dependencies of tickets queues. Thank you in advance. -- View this message in context: http://requesttracker.8502.n7.nabble.com/Group-chart-by-custom-field-of-Queue-tp55477.html Sent from the Request Tracker - User mailing list archive at Nabble.com.