Re: [rt-users] Another Query question: justification of data
Hi Ken its me again:
Have a look at share/html/Elements/ColumnMap
# This is scary and should totally be refactored -- jesse
my $COLUMN_MAP = {
id = {
attribute = 'id',
title= 'id', # loc
align = 'right',
value = sub { return $_[0]-id }
},
You will see the align = 'right', you can either remove the whole line (I do
n't think it will break anything), or you can simply change the right to left.
Restart the web server and all should be fine.
For me I would remove the align line from there and do this via the css, not
sure which stylesheets you use, If its web2, look in ticket-lists.css for
th.collection-as-table , td.collection-as-table {
padding-right: 0.5em;
}
And add text-align: left; in between {}
This in theory will apply it to all fields within CollectionList.
Regards;
Roy
From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker
Sent: 18 October 2010 22:32
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Another Query question: justification of data
Ruslan,
I can't seem to get that to work. What I REALLY want to do is have ALL Search
results align the Ticket ID to the left. I know most people want a field
defined as Number to align to the right. But Ticket ID is never used in
arithmetic expressions so there's no reason to treat it like any other
character field and align it to the left or the center. Otherwise, it looks way
out of alignment. When I look at the source code generated for the results, I
get:
td class=collection-as-table align=rightba
href=/Ticket/Display.html?id=85141view-source:https://rtqt.lbl.gov/Ticket/Display.html?id=8514185141/a/b/td
td class=collection-as-table ba
href=/Ticket/Display.html?id=85141view-source:https://rtqt.lbl.gov/Ticket/Display.html?id=85141Develop
Admin Queries #38; Dashboards for EHS Queues/a/b/td
td class=collection-as-table TSG-RT/td
td class=collection-as-table cpe...@lbl.govmailto:cpe...@lbl.gov/td
td class=collection-as-table 3/td
td class=collection-as-table new/td
td class=collection-as-table Requested/td
td class=collection-as-table KFCrocker/td
td class=collection-as-table 2010-09-10/a/b/td
So it looks to me like something it automatically inserting align=right in
the collection-as-table. I went to main.css and tried changing
ticket-lists.css and put a change in it (text-align: left;) for the td label
and it seems to get overridden. Do you know where the code is that overrides
ticket-lists.css so I can change that behavior?
Thanks.
Kenn
LBNL
On Mon, Oct 18, 2010 at 12:50 PM, Ruslan Zakirov
r...@bestpractical.commailto:r...@bestpractical.com wrote:
Hi,
Use /ALIGN:... in a format string.
On Sat, Oct 16, 2010 at 12:27 AM, Kenneth Crocker
kfcroc...@lbl.govmailto:kfcroc...@lbl.gov wrote:
To List,
I noticed that when I run a query, the Ticket number seems to be justified
to the right of it's column, but Priority Subject, and others are justified
left. Does anyone know why? Does anyone know how to change that?
Kenn
LBNL
RT Training in Washington DC, USA on Oct 25 26 2010
Last one this year -- Learn how to get the most out of RT!
--
Best regards, Ruslan.
Re: [rt-users] 'Show Results' link / Query Builder occasionally not working properly
Hi,
Issue has been fixed.
Patch:
diff --git a/lib/RT/SQL.pm b/lib/RT/SQL.pm
index 799cf94..946a8ab 100644
--- a/lib/RT/SQL.pm
+++ b/lib/RT/SQL.pm
@@ -68,7 +68,7 @@ my @tokens = qw[VALUE AGGREGATOR OPERATOR OPEN_PAREN
CLOSE_PAREN KEYWORD];
use Regexp::Common qw /delimited/;
my $re_aggreg = qr[(?i:AND|OR)];
my $re_delim = qr[$RE{delimited}{-delim=qq{\'\}}];
-my $re_value = qr[\d+|NULL|$re_delim];
+my $re_value = qr[[+-]?\d+|NULL|$re_delim];
my $re_keyword = qr[[{}\w\.]+|$re_delim];
my $re_op = qr[=|!=|=|=|||(?i:IS NOT)|(?i:IS)|(?i:NOT
LIKE)|(?i:LIKE)]; # long to short
my $re_open_paren = qr[\(];
SHA: 6c44641cd50c4f3ad631f4cb22292bb37a3c6c97
On Fri, Oct 15, 2010 at 3:51 AM, Stuart Browne
stuart.bro...@ausregistry.com.au wrote:
Hi,
Running RT 3.8.8 / DBIx::SearchBuilder 1.56, and have noticed some strange
behaviour with the 'Show Results' link and the Query Builder.
From the 'At A Glance' page, I generally click on 'xx highest priority
tickets I own' to bring up the search result, then click 'Edit Search' and
add 'Priority -2' to show only positive value priority tickets. Thus far,
all is fine (and I understand I can just alter the saved search, but that's
not what I want).
From there, I use the list, going into and out of tickets, sometimes
navigating into Configuration or other areas, then click back on 'Tickets'
and 'Show Results'. For whatever reason, the search is modified to be
'Priority 2'.
Steps to reproduce, and what is shown on the screen:
1. Log In
2. Click on 'xx highest priority tickets I own'
3. Click on 'Edit Search'
4. Use dropdown boxes to add 'Priority' 'greater than' '-2', clicked
'Add these items' (or '... and Search')
- At this point, the query is as follows:
Owner = '__CurrentUser__' AND ( Status = 'new' OR
Status = 'open'
OR Status = 'validating' OR Status = 'WaitExt'
) AND
Queue != 'Holding' AND Priority '-2'
5. Click on any other left-hand menu item
6. Click on 'Tickets'
- Query shown is correct with the '-2' Priority
7. Click on 'Show Results'
At this point, the query has changed to:
Owner = '__CurrentUser__' AND ( Status = 'new' OR Status = 'open'
OR Status = 'validating' OR Status = 'WaitExt' ) AND
Queue != 'Holding' AND Priority 2
If at step 4, you press 'Add these items' 3 times, it also removes the
negative.
I'm not good enough at the internals of the query builder to know why the
state of this field changes 'magically', but it didn't happen in prior
versions.
Has anybody else seen this, or can they reproduce the issue? ;)
Stuart J. Browne
Senior Unix Administrator, Network Administrator
AusRegistry Pty Ltd
Level 8, 10 Queens Road
Melbourne. Victoria. Australia. 3004.
Ph: +61 3 9866 3710
Fax: +61 3 9866 1970
Email: stuart.bro...@ausregistry.com.au
Web: www.ausregistry.com.au
The information contained in this communication is intended for the named
recipients only. It is subject to copyright and may contain legally
privileged and confidential information and if you are not an intended
recipient you must not use, copy, distribute or take any action in reliance
on it. If you have received this communication in error, please delete all
copies from your system and notify us immediately.
RT Training in Washington DC, USA on Oct 25 26 2010
Last one this year -- Learn how to get the most out of RT!
--
Best regards, Ruslan.
[rt-users] How to add into ticket history, that ticket was Forwarded to some email
Hello We are using RT 3.8.4. When someone uses the Forward button within tickets, he can send the info to some emails. But this information is not written in the ticket history, so we don't know that this thing happen. Is there some configuration, that this info will be also visible as a single line within history in tickets ? something like: Forwarded message to xxx.xxx...@.com Miroslav -- View this message in context: http://old.nabble.com/How-to-add-into-ticket-history%2C-that-ticket-was-Forwarded-to-some-email-tp3637p3637.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] exclamation point on email reports
Hi.. I have a report that gets generated daily and when RT emails me the report the subject comes out slight different, it inserts an exclamation point in the subject field: ALL_MANAGER_REVIEW_RESOLV! ED The actual report title is: ALL_MANAGER_REVIEW_RESOLVED Anyone have a clue would could be causing this? -psminusauxf -- View this message in context: http://old.nabble.com/exclamation-point-on-email-reports-tp30001441p30001441.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Multiple LDAP servers with EmailCompletion
I've been searching around but unable to locate the correct parameters for having more than one LDAP server to have EmailCompletion check against. Here's the snippet from my RT_SiteConfig.pm: Set($EmailCompletionLdapServer, dc01.corp.XYZ.com); Set($EmailCompletionLdapBase, dc=corp,dc=XYZ,dc=com); Set($EmailCompletionLdapUser, rtldap); Set($EmailCompletionLdapPass, password); Set($EmailCompletionLdapMinLength, 1); Set($EmailCompletionLdapFilter, (objectclass=user)); Set($EmailCompletionLdapServer, dc02.XYZ2.com); Set($EmailCompletionLdapBase, dc=XYZ2,dc=com); Set($EmailCompletionLdapUser, otherrtldap); Set($EmailCompletionLdapPass, password); Set($EmailCompletionLdapMinLength, 1); Set($EmailCompletionLdapFilter, (objectclass=user)); I have a feeling it doesn't know which set of criteria to match against -and that's why we end up getting sporadic results. We are using RT-Authen-ExternalAuth against the same two LDAP servers, and that's working great for email-ticket creation/requestor creation as well as authentication. Thanks for any help! -Andy
[rt-users] Mobile UI for RTFM?
I know I'm probably dreaming, but now that the mobile UI has wet the appetite, I have a request to search RTFM with the mobile UI. Currently it's not possible...is it something that's easily done? I'm not a Perl guy, but I don't mind tinkering with code. Thanks, Steve
Re: [rt-users] Another Query question: justification of data
Roy,
Thanks. Yea. I think that Id should default to the left anyway, but what
do I know, huh?
I'll make that change.
Kenn
LBNL
On Tue, Oct 19, 2010 at 2:41 AM, Raed El-Hames raed.el-ha...@vialtus.comwrote:
Hi Ken its me again:
Have a look at share/html/Elements/ColumnMap
# This is scary and should totally be refactored -- jesse
my $COLUMN_MAP = {
id = {
attribute = 'id',
title= 'id', # loc
align = 'right',
value = sub { return $_[0]-id }
},
You will see the align = ‘right’, you can either remove the whole line (I
do n’t think it will break anything), or you can simply change the right to
left.
Restart the web server and all should be fine.
For me I would remove the align line from there and do this via the css,
not sure which stylesheets you use, If its web2, look in ticket-lists.css
for
th.collection-as-table , td.collection-as-table {
padding-right: 0.5em;
}
And add text-align: left; in between {}
This in theory will apply it to all fields within CollectionList.
Regards;
Roy
*From:* rt-users-boun...@lists.bestpractical.com [mailto:
rt-users-boun...@lists.bestpractical.com] *On Behalf Of *Kenneth Crocker
*Sent:* 18 October 2010 22:32
*To:* rt-users@lists.bestpractical.com
*Subject:* Re: [rt-users] Another Query question: justification of data
Ruslan,
I can't seem to get that to work. What I REALLY want to do is have ALL
Search results align the Ticket ID to the left. I know most people want a
field defined as Number to align to the right. But Ticket ID is never used
in arithmetic expressions so there's no reason to treat it like any other
character field and align it to the left or the center. Otherwise, it looks
way out of alignment. When I look at the source code generated for the
results, I get:
td class=collection-as-table align=rightba
href=/Ticket/Display.html?id=8514185141/a/b/td
td class=collection-as-table ba
href=/Ticket/Display.html?id=85141Develop Admin Queries #38; Dashboards
for EHS Queues/a/b/td
td class=collection-as-table TSG-RT/td
td class=collection-as-table cpe...@lbl.gov/td
td class=collection-as-table 3/td
td class=collection-as-table new/td
td class=collection-as-table Requested/td
td class=collection-as-table KFCrocker/td
td class=collection-as-table 2010-09-10/a/b/td
So it looks to me like something it automatically inserting align=right
in the collection-as-table. I went to main.css and tried changing
ticket-lists.css and put a change in it (text-align: left;) for the td
label and it seems to get overridden. Do you know where the code is that
overrides ticket-lists.css so I can change that behavior?
Thanks.
Kenn
LBNL
On Mon, Oct 18, 2010 at 12:50 PM, Ruslan Zakirov r...@bestpractical.com
wrote:
Hi,
Use /ALIGN:... in a format string.
On Sat, Oct 16, 2010 at 12:27 AM, Kenneth Crocker kfcroc...@lbl.gov
wrote:
To List,
I noticed that when I run a query, the Ticket number seems to be
justified
to the right of it's column, but Priority Subject, and others are
justified
left. Does anyone know why? Does anyone know how to change that?
Kenn
LBNL
RT Training in Washington DC, USA on Oct 25 26 2010
Last one this year -- Learn how to get the most out of RT!
--
Best regards, Ruslan.
Re: [rt-users] Multiple LDAP servers with EmailCompletion
On 19 Oct 2010 11:52, Andrew Marosi wrote: I’ve been searching around but unable to locate the correct parameters for having more than one LDAP server to have EmailCompletion check against. Here’s the snippet from my RT_SiteConfig.pm: RTx-EmailCompletion doesn't support multiple LDAP servers like ExternalAuth does. The multiple Set() lines for the same configuration variable just overwrite it. Thomas Set($EmailCompletionLdapServer, dc01.corp.XYZ.com); Set($EmailCompletionLdapBase, dc=corp,dc=XYZ,dc=com); Set($EmailCompletionLdapUser, rtldap); Set($EmailCompletionLdapPass, password); Set($EmailCompletionLdapMinLength, 1); Set($EmailCompletionLdapFilter, (objectclass=user)); Set($EmailCompletionLdapServer, dc02.XYZ2.com); Set($EmailCompletionLdapBase, dc=XYZ2,dc=com); Set($EmailCompletionLdapUser, otherrtldap); Set($EmailCompletionLdapPass, password); Set($EmailCompletionLdapMinLength, 1); Set($EmailCompletionLdapFilter, (objectclass=user)); I have a feeling it doesn’t know which set of criteria to match against –and that’s why we end up getting sporadic results. We are using RT-Authen-ExternalAuth against the same two LDAP servers, and that’s working great for email-ticket creation/requestor creation as well as authentication. Thanks for any help! -Andy
Re: [rt-users] Multiple LDAP servers with EmailCompletion
Thanks for the clarification Thomas. Anyone have any ideas on how to accomplish the same result with a different solution? Thanks! -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Thomas Sibley Sent: Tuesday, October 19, 2010 10:16 AM To: rt-us...@bestpractical.com Subject: Re: [rt-users] Multiple LDAP servers with EmailCompletion On 19 Oct 2010 11:52, Andrew Marosi wrote: I’ve been searching around but unable to locate the correct parameters for having more than one LDAP server to have EmailCompletion check against. Here’s the snippet from my RT_SiteConfig.pm: RTx-EmailCompletion doesn't support multiple LDAP servers like ExternalAuth does. The multiple Set() lines for the same configuration variable just overwrite it. Thomas Set($EmailCompletionLdapServer, dc01.corp.XYZ.com); Set($EmailCompletionLdapBase, dc=corp,dc=XYZ,dc=com); Set($EmailCompletionLdapUser, rtldap); Set($EmailCompletionLdapPass, password); Set($EmailCompletionLdapMinLength, 1); Set($EmailCompletionLdapFilter, (objectclass=user)); Set($EmailCompletionLdapServer, dc02.XYZ2.com); Set($EmailCompletionLdapBase, dc=XYZ2,dc=com); Set($EmailCompletionLdapUser, otherrtldap); Set($EmailCompletionLdapPass, password); Set($EmailCompletionLdapMinLength, 1); Set($EmailCompletionLdapFilter, (objectclass=user)); I have a feeling it doesn’t know which set of criteria to match against –and that’s why we end up getting sporadic results. We are using RT-Authen-ExternalAuth against the same two LDAP servers, and that’s working great for email-ticket creation/requestor creation as well as authentication. Thanks for any help! -Andy
[rt-users] Image not showing in Article
Hi there, I followed the steps on the RT Wiki to Add a Format Toolbar to the Wikitext Custom Field. While I have the tool bar and all of the buttons work when I attempt to insert the image I simply see the words uploaded image I am not sure what I did incorrect, unless I am supposed to store the image in a specific file and am not doing that. Any help would be greatly appreciated. Thanks Jesse Heath Oracle Applications Specialist Incredible Technologies, Inc. N. Kennicott Ave. Arlington Heights, IL 60004 (847) 870-7027 x202
[rt-users] Unread messages
Hello, I am fairly new to RT, and am trying to get used to using it in my environment. Is there an easy way for me to view which of my tickets have emails that are unread? I find myself going into the main dashboard, and then checking tickets multiple times a day to see if they have the header at the top saying that there are unread messages. There must be an easier way to see this from the dashboard? Thanks, Kris
[rt-users] How to use RT::CustomFieldValues::External
I have a list of values in a external data (SQL Server) and I want to display them in a custom field as a drop down. I was searching for the solution and found that RT::CustomFieldValues::External can be used for it. But not sure where to specify the data source. Can somebody please send me an example of how to use this extention? Thanks Naweed - The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. This message may be an attorney-client communication and/or work product and as such is privileged and confidential. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message.
Re: [rt-users] Unread messages
Kristofer, Change your RT_SiteConfig.pm file in /opt/rt3/etc to include this setting: *Set($ShowUnreadMessageNotifications, 0); # turn off notice* You'll need to bounce/restart Apache or your VM environment. Kenn LBNL ** On Tue, Oct 19, 2010 at 11:26 AM, Kristofer Pettijohn kristo...@cybernetik.net wrote: Hello, I am fairly new to RT, and am trying to get used to using it in my environment. Is there an easy way for me to view which of my tickets have emails that are unread? I find myself going into the main dashboard, and then checking tickets multiple times a day to see if they have the header at the top saying that there are unread messages. There must be an easier way to see this from the dashboard? Thanks, Kris
Re: [rt-users] Unread messages
Kristopher, You can set that to whatever you want as a Global default, but you can reverse that on an individual basis in Preferences. Kenn LBNL On Tue, Oct 19, 2010 at 12:12 PM, Kenneth Crocker kfcroc...@lbl.gov wrote: Kristofer, Change your RT_SiteConfig.pm file in /opt/rt3/etc to include this setting: *Set($ShowUnreadMessageNotifications, 0); # turn off notice* You'll need to bounce/restart Apache or your VM environment. Kenn LBNL ** On Tue, Oct 19, 2010 at 11:26 AM, Kristofer Pettijohn kristo...@cybernetik.net wrote: Hello, I am fairly new to RT, and am trying to get used to using it in my environment. Is there an easy way for me to view which of my tickets have emails that are unread? I find myself going into the main dashboard, and then checking tickets multiple times a day to see if they have the header at the top saying that there are unread messages. There must be an easier way to see this from the dashboard? Thanks, Kris
Re: [rt-users] Unread messages
Kenneth, I'm sorry, I may have not been clear on my request. I do want it to show the unread message notification. My issue with RT is that it doesn't have a dashboard showing only Tickets that have unread messages so I can quickly go to them. I find myself going into individual tickets to look for that Unread message notification, which seems wasteful of time. From: Kenneth Crocker kfcroc...@lbl.gov To: rt-users@lists.bestpractical.com Sent: Tuesday, October 19, 2010 2:14:04 PM Subject: Re: [rt-users] Unread messages Kristopher, You can set that to whatever you want as a Global default, but you can reverse that on an individual basis in Preferences. Kenn LBNL On Tue, Oct 19, 2010 at 12:12 PM, Kenneth Crocker kfcroc...@lbl.gov wrote: Kristofer, Change your RT_SiteConfig.pm file in /opt/rt3/etc to include this setting: Set($ShowUnreadMessageNotifications, 0); # turn off notice You'll need to bounce/restart Apache or your VM environment. Kenn LBNL On Tue, Oct 19, 2010 at 11:26 AM, Kristofer Pettijohn kristo...@cybernetik.net wrote: Hello, I am fairly new to RT, and am trying to get used to using it in my environment. Is there an easy way for me to view which of my tickets have emails that are unread? I find myself going into the main dashboard, and then checking tickets multiple times a day to see if they have the header at the top saying that there are unread messages. There must be an easier way to see this from the dashboard? Thanks, Kris
Re: [rt-users] Unread messages
Can you do a search with tickets that are last updated by someone who isn't you? Ken On Tue, Oct 19, 2010 at 03:14:41PM -0500, Kristofer Pettijohn wrote: Kenneth, I'm sorry, I may have not been clear on my request. I do want it to show the unread message notification. My issue with RT is that it doesn't have a dashboard showing only Tickets that have unread messages so I can quickly go to them. I find myself going into individual tickets to look for that Unread message notification, which seems wasteful of time. From: Kenneth Crocker kfcroc...@lbl.gov To: rt-users@lists.bestpractical.com Sent: Tuesday, October 19, 2010 2:14:04 PM Subject: Re: [rt-users] Unread messages Kristopher, You can set that to whatever you want as a Global default, but you can reverse that on an individual basis in Preferences. Kenn LBNL On Tue, Oct 19, 2010 at 12:12 PM, Kenneth Crocker kfcroc...@lbl.gov wrote: Kristofer, Change your RT_SiteConfig.pm file in /opt/rt3/etc to include this setting: Set($ShowUnreadMessageNotifications, 0); # turn off notice You'll need to bounce/restart Apache or your VM environment. Kenn LBNL On Tue, Oct 19, 2010 at 11:26 AM, Kristofer Pettijohn kristo...@cybernetik.net wrote: Hello, I am fairly new to RT, and am trying to get used to using it in my environment. Is there an easy way for me to view which of my tickets have emails that are unread? I find myself going into the main dashboard, and then checking tickets multiple times a day to see if they have the header at the top saying that there are unread messages. There must be an easier way to see this from the dashboard? Thanks, Kris
Re: [rt-users] Unread messages
Hello Kristofer, Try to use __UpdateStatus__ column in the format string you use for that search. I know it's not the best way, but close to what you're looking for. On Tue, Oct 19, 2010 at 10:26 PM, Kristofer Pettijohn kristo...@cybernetik.net wrote: Hello, I am fairly new to RT, and am trying to get used to using it in my environment. Is there an easy way for me to view which of my tickets have emails that are unread? I find myself going into the main dashboard, and then checking tickets multiple times a day to see if they have the header at the top saying that there are unread messages. There must be an easier way to see this from the dashboard? Thanks, Kris -- Best regards, Ruslan.
Re: [rt-users] How to use RT::CustomFieldValues::External
Hi, Start from CustomFieldValuesSources config option. Read docs in lib/RT/CustomFieldValues/External.pm and use lib/RT/CustomFieldValues/External/Groups.pm as example. However connecting to MS SQL server on *nix is kinda tricky, so I would recommend you to use something in between, for example a file where you dump values and then read it from RT. Or just write a script that will keep values at sync and run it periodically and don't use CFs with external source at all. The latter is preferred in terms of performance. The only reason is to use external source is if external source changed very often and you can not allow it to be out of sync even for a minute. On Tue, Oct 19, 2010 at 10:16 PM, Ahmed, Mohammed Naweed (LNG-BCT) naweedmohammed.ah...@lexisnexis.com wrote: I have a list of values in a external data (SQL Server) and I want to display them in a custom field as a drop down. I was searching for the solution and found that RT::CustomFieldValues::External can be used for it. But not sure where to specify the data source. Can somebody please send me an example of how to use this extention? Thanks Naweed The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. This message may be an attorney-client communication and/or work product and as such is privileged and confidential. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. -- Best regards, Ruslan.
Re: [rt-users] 'Show Results' link / Query Builder occasionally not working properly
Applied, tested. Beautiful.
Thank you Ruslan.
-Original Message-
From: ruslan.zaki...@gmail.com [mailto:ruslan.zaki...@gmail.com] On
Behalf Of Ruslan Zakirov
Sent: Tuesday, 19 October 2010 23:05
To: Stuart Browne
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] 'Show Results' link / Query Builder
occasionally not working properly
Hi,
Issue has been fixed.
Patch:
diff --git a/lib/RT/SQL.pm b/lib/RT/SQL.pm
index 799cf94..946a8ab 100644
--- a/lib/RT/SQL.pm
+++ b/lib/RT/SQL.pm
@@ -68,7 +68,7 @@ my @tokens = qw[VALUE AGGREGATOR OPERATOR OPEN_PAREN
CLOSE_PAREN KEYWORD];
use Regexp::Common qw /delimited/;
my $re_aggreg = qr[(?i:AND|OR)];
my $re_delim = qr[$RE{delimited}{-delim=qq{\'\}}];
-my $re_value = qr[\d+|NULL|$re_delim];
+my $re_value = qr[[+-]?\d+|NULL|$re_delim];
my $re_keyword = qr[[{}\w\.]+|$re_delim];
my $re_op = qr[=|!=|=|=|||(?i:IS NOT)|(?i:IS)|(?i:NOT
LIKE)|(?i:LIKE)]; # long to short
my $re_open_paren = qr[\(];
SHA: 6c44641cd50c4f3ad631f4cb22292bb37a3c6c97
On Fri, Oct 15, 2010 at 3:51 AM, Stuart Browne
stuart.bro...@ausregistry.com.au wrote:
Hi,
Running RT 3.8.8 / DBIx::SearchBuilder 1.56, and have noticed some
strange behaviour with the 'Show Results' link and the Query Builder.
From the 'At A Glance' page, I generally click on 'xx highest
priority tickets I own' to bring up the search result, then click 'Edit
Search' and add 'Priority -2' to show only positive value priority
tickets. Thus far, all is fine (and I understand I can just alter the
saved search, but that's not what I want).
From there, I use the list, going into and out of tickets, sometimes
navigating into Configuration or other areas, then click back on
'Tickets' and 'Show Results'. For whatever reason, the search is
modified to be 'Priority 2'.
Steps to reproduce, and what is shown on the screen:
1. Log In
2. Click on 'xx highest priority tickets I own'
3. Click on 'Edit Search'
4. Use dropdown boxes to add 'Priority' 'greater than' '-2',
clicked 'Add these items' (or '... and Search')
- At this point, the query is as follows:
Owner = '__CurrentUser__' AND ( Status =
'new' OR Status = 'open'
OR Status = 'validating' OR Status =
'WaitExt' ) AND
Queue != 'Holding' AND Priority '-2'
5. Click on any other left-hand menu item
6. Click on 'Tickets'
- Query shown is correct with the '-2' Priority
7. Click on 'Show Results'
At this point, the query has changed to:
Owner = '__CurrentUser__' AND ( Status = 'new' OR Status =
'open'
OR Status = 'validating' OR Status = 'WaitExt' ) AND
Queue != 'Holding' AND Priority 2
If at step 4, you press 'Add these items' 3 times, it also removes
the negative.
I'm not good enough at the internals of the query builder to know why
the state of this field changes 'magically', but it didn't happen in
prior versions.
Has anybody else seen this, or can they reproduce the issue? ;)
Stuart J. Browne
Re: [rt-users] Update Ticket Subject on Comment/Reply
Hi, I'm not sure why you need this. Doesn't sound like good idea to me. If you can do it automatically (I mean with code) then you can use scrips like Kenneth suggested. If you want to allow users to change subject manually on reply then you have to look into share/html/Ticket/Update.html and hack it to show Subject input field and process it on submit. On Thu, Oct 14, 2010 at 3:21 AM, Andrew Best festi...@gmail.com wrote: Morning all, Is it possible to change/update the subject on a ticket when a user comments or replies? At the moment the staff need to go into the ticket basics and update the subject manually. It would save them time if they could change/fix the subject of a ticket when they are commenting or replying to it. cheers Andrew -- Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic. RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT! -- Best regards, Ruslan.
Re: [rt-users] Update Ticket Subject on Comment/Reply
I actually requested this as well, it would be incredibly useful. I've tried making a scrip for making any correspondence extract subject tag of the email (to RT) and move to ticket TITLE but no luck... Kris Germann Mentor, Sales Technical Support Fibernetics Corp Sent wirelessly from my BlackBerry device on the Bell network. Envoyé sans fil par mon terminal mobile BlackBerry sur le réseau de Bell. -Original Message- From: Ruslan Zakirov r...@bestpractical.com Sender: rt-users-boun...@lists.bestpractical.com Date: Wed, 20 Oct 2010 02:13:06 To: Andrew Bestfesti...@gmail.com Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Update Ticket Subject on Comment/Reply Hi, I'm not sure why you need this. Doesn't sound like good idea to me. If you can do it automatically (I mean with code) then you can use scrips like Kenneth suggested. If you want to allow users to change subject manually on reply then you have to look into share/html/Ticket/Update.html and hack it to show Subject input field and process it on submit. On Thu, Oct 14, 2010 at 3:21 AM, Andrew Best festi...@gmail.com wrote: Morning all, Is it possible to change/update the subject on a ticket when a user comments or replies? At the moment the staff need to go into the ticket basics and update the subject manually. It would save them time if they could change/fix the subject of a ticket when they are commenting or replying to it. cheers Andrew -- Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic. RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT! -- Best regards, Ruslan.
Re: [rt-users] Drop down values hidden
Hello, You didn't notice RT version and browser you're testing with. I see change in RT 3.8.5 that can be related. If you're not on that or newer version then either upgrade or try to use the following patch. http://github.com/bestpractical/rt/commit/c42465fb0d8443905deef2a9c58718c0331980f2 On Thu, Oct 14, 2010 at 12:33 AM, Ahmed, Mohammed Naweed (LNG-BCT) naweedmohammed.ah...@lexisnexis.com wrote: I have a list of drop down boxes on the ticket with Yes/No values in them but when I click on the drop down, the values are overlapped by the controls on the next line, it is not happening with all the combo boxes but a few and it is not looking good as you can see below (When I clicked on IsMainframe Access required? Combo box). Does any body else face this problem or have a solution to it ? Thanks *Naweed * -- * The information contained in this e-mail message is intended only for the personal and confidential use of the recipient(s) named above. This message may be an attorney-client communication and/or work product and as such is privileged and confidential. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail, and delete the original message. * RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT! -- Best regards, Ruslan. image002.jpg
Re: [rt-users] Update Ticket Subject on Comment/Reply
On Wed, Oct 20, 2010 at 2:16 AM, Kris Germann kris_germ...@295.ca wrote: I actually requested this as well, it would be incredibly useful. I've tried making a scrip for making any correspondence extract subject tag of the email (to RT) and move to ticket TITLE but no luck... I don't see how this related to Andrew's question. Have you looked at lib/RT/Action/ExtractSubjectTag.pm ? No idea what you mean by TITLE. Kris Germann Mentor, Sales Technical Support Fibernetics Corp Sent wirelessly from my BlackBerry device on the Bell network. Envoyé sans fil par mon terminal mobile BlackBerry sur le réseau de Bell. -Original Message- From: Ruslan Zakirov r...@bestpractical.com Sender: rt-users-boun...@lists.bestpractical.com Date: Wed, 20 Oct 2010 02:13:06 To: Andrew Bestfesti...@gmail.com Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Update Ticket Subject on Comment/Reply Hi, I'm not sure why you need this. Doesn't sound like good idea to me. If you can do it automatically (I mean with code) then you can use scrips like Kenneth suggested. If you want to allow users to change subject manually on reply then you have to look into share/html/Ticket/Update.html and hack it to show Subject input field and process it on submit. On Thu, Oct 14, 2010 at 3:21 AM, Andrew Best festi...@gmail.com wrote: Morning all, Is it possible to change/update the subject on a ticket when a user comments or replies? At the moment the staff need to go into the ticket basics and update the subject manually. It would save them time if they could change/fix the subject of a ticket when they are commenting or replying to it. cheers Andrew -- Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic. RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT! -- Best regards, Ruslan. -- Best regards, Ruslan.
Re: [rt-users] Update Ticket Subject on Comment/Reply
Here Is it possible to change/update the subject on a ticket when a user comments or replies? When I email a user via RT, the subject starting the initial correspondence is set as the title of that ticket - title being what shows iin the queues (or query results for tickets). What I was wondering is if whether when another user replied via their email client to the ticket I sent to them and changed that subject (meaning added to or deleted text from) if it could change the subject of the entire ticket. I've looked in lib/RT/Action/ but ExtractSubjectTag.pm doesn't exist. Kris Germann Mentor, Sales Technical Support Fibernetics Corp Sent wirelessly from my BlackBerry device on the Bell network. Envoyé sans fil par mon terminal mobile BlackBerry sur le réseau de Bell. -Original Message- From: Ruslan Zakirov r...@bestpractical.com Sender: ruslan.zaki...@gmail.com Date: Wed, 20 Oct 2010 02:38:33 To: kris_germ...@295.ca Cc: rt-users-boun...@lists.bestpractical.com; Andrew Bestfesti...@gmail.com; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Update Ticket Subject on Comment/Reply On Wed, Oct 20, 2010 at 2:16 AM, Kris Germann kris_germ...@295.ca wrote: I actually requested this as well, it would be incredibly useful. I've tried making a scrip for making any correspondence extract subject tag of the email (to RT) and move to ticket TITLE but no luck... I don't see how this related to Andrew's question. Have you looked at lib/RT/Action/ExtractSubjectTag.pm ? No idea what you mean by TITLE. Kris Germann Mentor, Sales Technical Support Fibernetics Corp Sent wirelessly from my BlackBerry device on the Bell network. Envoyé sans fil par mon terminal mobile BlackBerry sur le réseau de Bell. -Original Message- From: Ruslan Zakirov r...@bestpractical.com Sender: rt-users-boun...@lists.bestpractical.com Date: Wed, 20 Oct 2010 02:13:06 To: Andrew Bestfesti...@gmail.com Cc: rt-users@lists.bestpractical.com Subject: Re: [rt-users] Update Ticket Subject on Comment/Reply Hi, I'm not sure why you need this. Doesn't sound like good idea to me. If you can do it automatically (I mean with code) then you can use scrips like Kenneth suggested. If you want to allow users to change subject manually on reply then you have to look into share/html/Ticket/Update.html and hack it to show Subject input field and process it on submit. On Thu, Oct 14, 2010 at 3:21 AM, Andrew Best festi...@gmail.com wrote: Morning all, Is it possible to change/update the subject on a ticket when a user comments or replies? At the moment the staff need to go into the ticket basics and update the subject manually. It would save them time if they could change/fix the subject of a ticket when they are commenting or replying to it. cheers Andrew -- Never be afraid to try something new. Remember, amateurs built the ark, and professionals built the Titanic. RT Training in Washington DC, USA on Oct 25 26 2010 Last one this year -- Learn how to get the most out of RT! -- Best regards, Ruslan. -- Best regards, Ruslan.
Re: [rt-users] Multiple LDAP servers with EmailCompletion
Improve the module to support multiple ldap servers. Regards, Ruslan. From phone. 2010 10 19 21:24 пользователь Andrew Marosi amar...@lamparts.com написал: Thanks for the clarification Thomas. Anyone have any ideas on how to accomplish the same result with a different solution? Thanks! -Original Message- From: rt-users-boun...@lists.bestpractical.com [mailto: rt-users-boun...@lists.bestpractical.com] On Behalf Of Thomas Sibley Sent: Tuesday, October 19, 2010 10:16 AM To: rt-us...@bestpractical.com Subject: Re: [rt-users] Multiple LDAP servers with EmailCompletion On 19 Oct 2010 11:52, Andrew Marosi wrote: I’ve been searching around but unable to locate the correct parameters for having more than one LDAP server to have EmailCompletion check against. Here’s the snippet from my RT_SiteConfig.pm: RTx-EmailCompletion doesn't support multiple LDAP servers like ExternalAuth does. The multiple Set() lines for the same configuration variable just overwrite it. Thomas Set($EmailCompletionLdapServer, dc01.corp.XYZ.com); Set($EmailCompletionLdapBase, dc=corp,dc=XYZ,dc=com); Set($EmailCompletionLdapUser, rtldap); Set($EmailCompletionLdapPass, password); Set($EmailCompletionLdapMinLength, 1); Set($EmailCompletionLdapFilter, (objectclass=user)); Set($EmailCompletionLdapServer, dc02.XYZ2.com); Set($EmailCompletionLdapBase, dc=XYZ2,dc=com); Set($EmailCompletionLdapUser, otherrtldap); Set($EmailCompletionLdapPass, password); Set($EmailCompletionLdapMinLength, 1); Set($EmailCompletionLdapFilter, (objectclass=user)); I have a feeling it doesn’t know which set of criteria to match against –and that’s why we end up getting sporadic results. We are using RT-Authen-ExternalAuth against the same two LDAP servers, and that’s working great for email-ticket creation/requestor creation as well as authentication. Thanks for any help! -Andy
Re: [rt-users] Another Query question: justification of data
Usually numbers are right aligned in tables, but it's not always followed in
rt.
Regards, Ruslan. From phone.
2010 10 19 21:15 пользователь Kenneth Crocker kfcroc...@lbl.gov написал:
Roy,
Thanks. Yea. I think that Id should default to the left anyway, but what
do I know, huh?
I'll make that change.
Kenn
LBNL
On Tue, Oct 19, 2010 at 2:41 AM, Raed El-Hames raed.el-ha...@vialtus.com
wrote:
Hi Ken its me again:
Have a look at share/html/Elements/ColumnMap
# This is scary and should totally be refactored -- jesse
my $COLUMN_MAP = {
id = {
attribute = 'id',
title = 'id', # loc
align = 'right',
value = sub { return $_[0]-id }
},
You will see the align = ‘right’, you can either remove the whole line (I
do n’t think it will break anything), or you can simply change the right
to
left.
Restart the web server and all should be fine.
For me I would remove the align line from there and do this via the css,
not sure which stylesheets you use, If its web2, look in ticket-lists.css
for
th.collection-as-table , td.collection-as-table {
padding-right: 0.5em;
}
And add text-align: left; in between {}
This in theory will apply it to all fields within CollectionList.
Regards;
Roy
*From:* rt-users-boun...@lists.bestpractical.com [mailto:
rt-users-boun...@lists.bestpractical.com] *On Behalf Of *Kenneth Crocker
*Sent:* 18 October 2010 22:32
*To:* rt-users@lists.bestpractical.com
*Subject:* Re: [rt-users] Another Query question: justification of data
Ruslan,
I can't seem to get that to work. What I REALLY want to do is have ALL
Search results align the Ticket ID to the left. I know most people want a
field defined as Number to align to the right. But Ticket ID is never
used
in arithmetic expressions so there's no reason to treat it like any other
character field and align it to the left or the center. Otherwise, it
looks
way out of alignment. When I look at the source code generated for the
results, I get:
td class=collection-as-table align=rightba
href=/Ticket/Display.html?id=8514185141/a/b/td
td class=collection-as-table ba
href=/Ticket/Display.html?id=85141Develop Admin Queries #38; Dashboards
for EHS Queues/a/b/td
td class=collection-as-table TSG-RT/td
td class=collection-as-table cpe...@lbl.gov/td
td class=collection-as-table 3/td
td class=collection-as-table new/td
td class=collection-as-table Requested/td
td class=collection-as-table KFCrocker/td
td class=collection-as-table 2010-09-10/a/b/td
So it looks to me like something it automatically inserting align=right
in the collection-as-table. I went to main.css and tried changing
ticket-lists.css and put a change in it (text-align: left;) for the td
label and it seems to get overridden. Do you know where the code is that
overrides ticket-lists.css so I can change that behavior?
Thanks.
Kenn
LBNL
On Mon, Oct 18, 2010 at 12:50 PM, Ruslan Zakirov r...@bestpractical.com
wrote:
Hi,
Use /ALIGN:... in a format string.
On Sat, Oct 16, 2010 at 12:27 AM, Kenneth Crocker kfcroc...@lbl.gov
wrote:
To List,
I noticed that when I run a query, the Ticket number seems to be
justified
to the right of it's column, but Priority Subject, and others are
justified
left. Does anyone know why? Does anyone know how to change that?
Kenn
LBNL
RT Training in Washington DC, USA on Oct 25 26 2010
Last one this year -- Learn how to get the most out of RT!
--
Best regards, Ruslan.
Re: [rt-users] exclamation point on email reports
Any details on how this report is generated and send out of rt? Regards, Ruslan. From phone. 2010 10 19 19:31 пользователь psminusauxf psminusa...@gmail.com написал: Hi.. I have a report that gets generated daily and when RT emails me the report the subject comes out slight different, it inserts an exclamation point in the subject field: ALL_MANAGER_REVIEW_RESOLV! ED The actual report title is: ALL_MANAGER_REVIEW_RESOLVED Anyone have a clue would could be causing this? -psminusauxf -- View this message in context: http://old.nabble.com/exclamation-point-on-email-reports-tp30001441p30001441.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] Another Query question: justification of data
Ruslan,
I think that makes sense in most cases. The problem is, Ticket Id is not for
arithmetic expression. No addition, no decimal alignment, etc. just a
number. So it is used/displayed like it is a character so I think it would
at least LOOK better if it was aligned to the left. Just an opinion.
Kenn
LBNL
On Tue, Oct 19, 2010 at 6:18 PM, Ruslan Zakirov r...@bestpractical.comwrote:
Usually numbers are right aligned in tables, but it's not always followed
in rt.
Regards, Ruslan. From phone.
2010 10 19 21:15 пользователь Kenneth Crocker kfcroc...@lbl.gov
написал:
Roy,
Thanks. Yea. I think that Id should default to the left anyway, but
what
do I know, huh?
I'll make that change.
Kenn
LBNL
On Tue, Oct 19, 2010 at 2:41 AM, Raed El-Hames
raed.el-ha...@vialtus.comwrote:
Hi Ken its me again:
Have a look at share/html/Elements/ColumnMap
# This is scary and should totally be refactored -- jesse
my $COLUMN_MAP = {
id = {
attribute = 'id',
title = 'id', # loc
align = 'right',
value = sub { return $_[0]-id }
},
You will see the align = 'right', you can either remove the whole line
(I
do n't think it will break anything), or you can simply change the right
to
left.
Restart the web server and all should be fine.
For me I would remove the align line from there and do this via the css,
not sure which stylesheets you use, If its web2, look in
ticket-lists.css
for
th.collection-as-table , td.collection-as-table {
padding-right: 0.5em;
}
And add text-align: left; in between {}
This in theory will apply it to all fields within CollectionList.
Regards;
Roy
*From:* rt-users-boun...@lists.bestpractical.com [mailto:
rt-users-boun...@lists.bestpractical.com] *On Behalf Of *Kenneth
Crocker
*Sent:* 18 October 2010 22:32
*To:* rt-users@lists.bestpractical.com
*Subject:* Re: [rt-users] Another Query question: justification of data
Ruslan,
I can't seem to get that to work. What I REALLY want to do is have ALL
Search results align the Ticket ID to the left. I know most people want
a
field defined as Number to align to the right. But Ticket ID is never
used
in arithmetic expressions so there's no reason to treat it like any
other
character field and align it to the left or the center. Otherwise, it
looks
way out of alignment. When I look at the source code generated for the
results, I get:
td class=collection-as-table align=rightba
href=/Ticket/Display.html?id=8514185141/a/b/td
td class=collection-as-table ba
href=/Ticket/Display.html?id=85141Develop Admin Queries #38; Dashboards
for EHS Queues/a/b/td
td class=collection-as-table TSG-RT/td
td class=collection-as-table cpe...@lbl.gov/td
td class=collection-as-table 3/td
td class=collection-as-table new/td
td class=collection-as-table Requested/td
td class=collection-as-table KFCrocker/td
td class=collection-as-table 2010-09-10/a/b/td
So it looks to me like something it automatically inserting
align=right
in the collection-as-table. I went to main.css and tried changing
ticket-lists.css and put a change in it (text-align: left;) for the td
label and it seems to get overridden. Do you know where the code is that
overrides ticket-lists.css so I can change that behavior?
Thanks.
Kenn
LBNL
On Mon, Oct 18, 2010 at 12:50 PM, Ruslan Zakirov r...@bestpractical.com
wrote:
Hi,
Use /ALIGN:... in a format string.
On Sat, Oct 16, 2010 at 12:27 AM, Kenneth Crocker kfcroc...@lbl.gov
wrote:
To List,
I noticed that when I run a query, the Ticket number seems to be
justified
to the right of it's column, but Priority Subject, and others are
justified
left. Does anyone know why? Does anyone know how to change that?
Kenn
LBNL
RT Training in Washington DC, USA on Oct 25 26 2010
Last one this year -- Learn how to get the most out of RT!
--
Best regards, Ruslan.
