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 wrote:
> 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"
> написал:
>
> > 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:
> >>
> >>
> >> href="/Ticket/Display.html?id=85141">85141
> >>
> >> href="/Ticket/Display.html?id=85141">Develop Admin Queries & Dashboards
> for EHS Queues
> >>
> >> TSG-RT
> >>
> >> cpe...@lbl.gov
> >>
> >> 3
> >>
> >> new
> >>
> >> Requested
> >>
> >> KFCrocker
> >>
> >> 2010-09-10
> >>
> >>
> >>
> >> 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 >
> >> wrote:
> >>
> >> Hi,
> >>
> >> Use "/ALIGN:..." in a format string.
> >>
> >>
> >> On Sat, Oct 16, 2010 at 12:27 AM, Kenneth Crocker
> >> 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" написал: > > 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
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" написал:
> 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 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:
>>
>>
>> 85141
>>
>> Develop Admin Queries & Dashboards
for EHS Queues
>>
>> TSG-RT
>>
>> cpe...@lbl.gov
>>
>> 3
>>
>> new
>>
>> Requested
>>
>> KFCrocker
>>
>> 2010-09-10
>>
>>
>>
>> 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
>> wrote:
>>
>> Hi,
>>
>> Use "/ALIGN:..." in a format string.
>>
>>
>> On Sat, Oct 16, 2010 at 12:27 AM, Kenneth Crocker
>> 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
Improve the module to support multiple ldap servers. Regards, Ruslan. From phone. 2010 10 19 21:24 пользователь "Andrew Marosi" написал: > 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] 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 Sender: ruslan.zaki...@gmail.com Date: Wed, 20 Oct 2010 02:38:33 To: Cc: ; Andrew Best; Subject: Re: [rt-users] Update Ticket Subject on Comment/Reply On Wed, Oct 20, 2010 at 2:16 AM, Kris Germann 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 > Sender: rt-users-boun...@lists.bestpractical.com > Date: Wed, 20 Oct 2010 02:13:06 > To: Andrew Best > Cc: > 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 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
On Wed, Oct 20, 2010 at 2:16 AM, Kris Germann 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 > Sender: rt-users-boun...@lists.bestpractical.com > Date: Wed, 20 Oct 2010 02:13:06 > To: Andrew Best > Cc: > 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 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] 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. <>
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 Sender: rt-users-boun...@lists.bestpractical.com Date: Wed, 20 Oct 2010 02:13:06 To: Andrew Best Cc: 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 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
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 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] '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
> 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] 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) 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] 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 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] 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" > 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
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" 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
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 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
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 >
[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.
[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] 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
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 >
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
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 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:
>
>
> href="/Ticket/Display.html?id=85141">85141
>
> href="/Ticket/Display.html?id=85141">Develop Admin Queries & Dashboards
> for EHS Queues
>
> TSG-RT
>
> cpe...@lbl.gov
>
> 3
>
> new
>
> Requested
>
> KFCrocker
>
> 2010-09-10
>
>
>
> 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
> wrote:
>
> Hi,
>
> Use "/ALIGN:..." in a format string.
>
>
> On Sat, Oct 16, 2010 at 12:27 AM, Kenneth Crocker
> 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.
>
>
>
[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
[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] 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] 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.
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
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.
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:
https://rtqt.lbl.gov/Ticket/Display.html?id=85141>">85141
https://rtqt.lbl.gov/Ticket/Display.html?id=85141>">Develop
Admin Queries & Dashboards for EHS Queues
TSG-RT
cpe...@lbl.gov
3
new
Requested
KFCrocker
2010-09-10
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
mailto:r...@bestpractical.com>> wrote:
Hi,
Use "/ALIGN:..." in a format string.
On Sat, Oct 16, 2010 at 12:27 AM, Kenneth Crocker
mailto: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.
