Re: [rt-users] Another Query question: justification of data

2010-10-18 Thread Kenneth Crocker
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 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] custom fields below description

2010-10-18 Thread Ruslan Zakirov
Hi Jason,

You have to reorder code in share/html/Ticket/Create.html. Move call
to EditCustomFields below message box. However, watch your steps as
you have to play nice with HTML tables and make sure markup is still
valid.

Another place to look at is Update.html in the same directory as Create.html.

On Fri, Oct 15, 2010 at 4:05 AM, Jason Edgar  wrote:
> how do I reorder my layout to have my custom fields below the description 
> text-area? Thanks all.
>
> 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] Help with RT::Extension::SLA and BUSINESS::HOURS

2010-10-18 Thread Ruslan Zakirov
Hi,

Have you seen the following:

http://search.cpan.org/~ruz/RT-Extension-SLA-0.03/lib/RT/Extension/SLA.pm#Configuring_business_hours

As you can see your %ServiceBusinessHours looks different. If you need
only one schedule then name it Default and it would be used for all
agreements by default.

On Fri, Oct 15, 2010 at 5:32 AM, Leigh Havas  wrote:
> On 15/10/10 10:49 AM, Slicer085 wrote:
>>
>> Hi There,
>>
>> I have Upgraded to 3.8.8, have installed all the correct modules and
>> things
>> are looking good.
>>
>> I have an issue with the RT::Extension::SLA Extension working with
>> BUSINESS::HOURS.
>> 
>>
>>
>> Any suggestions?
>>
>
> Further to this...
>
> If I set the hours manually in
> /usr/lib/perl5/site_perl/5.8.8/Business/Hours.pm
>
> It works.  But then I cannot set it per/queue.  Unless someone has any other
> solution?
>
> 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] Pressing the ticket Create button twice creates the same ticket twice

2010-10-18 Thread Ruslan Zakirov
Hi,

Try attached patch. Check if it works and let it roll for a while. If
it works and there are no objections from other developers then I'll
push it into the core.

Don't forget to clean mason cache and restart web server.

On Fri, Oct 15, 2010 at 10:33 AM,   wrote:
> Dear list,
>
> My environment:
>
> RT 3.8.8
> Perl 5.8.8
> apache 2.2.8
> FastCGI 2.4.6
> OS: Ubuntu or SuSE (same behaviour)
>
> I have a problem with the ticket creation. The following situation:
>
> A user wants to create a ticket and clicks the create button. Because of a 
> slow network connection the response takes some seconds. The user is 
> impatient and presses the create button again. -> Two tickets with different 
> id's but same content are created. The user can create the same ticket as 
> long as the response from the first create has come back.
>
> This did not occur in RT 3.4.6.
>
> Is there any way to deactivate the create button until the request has 
> finished?
>
> Thanks for any help.
>
> Best regards,
>
> Markus
> 
> T-Systems International GmbH
> SDU Telco NPS
> Vorgebirgsstr. 49
> 53119 Bonn
> Tel: + 49 228 9841 3820
> E-Mail: markus.kum...@t-systems.com
>
> T-Systems International GmbH
> Supervisory Board: René Obermann (Chairman)
> Board of Management: Reinhard Clemens (Chairman), Dr. Ferri Abolhassan, Olaf 
> Heyden, Joachim Langmack, Georg Pepping, Klaus Werner
> Commercial register: Amtsgericht Frankfurt am Main HRB 55933
> Registered office: Frankfurt am Main
> WEEE -Reg.-No. DE87523644
>
> 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-3.8-disable_submit_buttons_to_avoid_multiple_submits.patch
Description: Binary data


[rt-users] RT 3.9 Question on Custom Fields - Type = "Date"

2010-10-18 Thread Kenneth Crocker
To BP Gurus,

I am on 3.8.7 and not wanting to wait for  "Date" Custom Fields, I added
Emmanuel Lacour's code to allow it. This was before 3.8.8 came out.

My *BIG* question is: With the latest RT versions coming out (3.9.x or
whatever), will I have to do a lot of *re-engineering to my
DataBase*(Oracle) to get the Tables relating to CustomFields
(CUSTOMFIELDVALUES,
OBJECTCUSTOMFIELDVALUES, TICKETS) to keep this functionality working?

My second *NOTSOBIG* question is: will we be able to modify the "display
format" for these dates (drop the time from the display) like we do with
regular RT Ticket date fields?

Thanks a *heep* for your time and patience on these questions.

Kenn
LBNL


Re: [rt-users] custom fields (simple?) question - trying again

2010-10-18 Thread Kenneth Crocker
To list,

Sent this before, but no answer. Thought I'd try again.

Back in 3.6 X days, I believe that the only way to "See","Modify" or "Admin"
a Custom Field was by granting that right *to a group* while in the
Config->CustomField screen. I could be wrong, but at any rate, I remember
granting rights to a lot of CF's that way.

I now have 3.8.7and I see these rights while in Config->*Queues->Group
Rights.*

What's the difference? Does one take priority over the other? Are they
redundant?

Thanks in advance.

Kenn
LBNL


Re: [rt-users] Another Query question: justification of data

2010-10-18 Thread Ruslan Zakirov
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] LDAP question in relation to "AutoCreate" option

2010-10-18 Thread Kenneth Crocker
To List,

I'm sure this is documented somewhere, but I can't find it or it isn't clear
to me (I have VERY FOGGY perception due to my ADHD and Auditory processing
disabilities), but I was wondering if LDAP filtering and authorization
occurs first so that if I set the "AutoCreate" option to automatically
create new users as "Unprivileged", then I *still wouldn't be
getting*non-LDAP users or spam into RT.

Thanks in advance.

Kenn
LBNL


Re: [rt-users] Curious about "People" display for unprivileged users

2010-10-18 Thread Kenneth Crocker
Thomas,

Sounds good. It's not really a problem, I just didn't know it existed. I
didn't start administrating RT until 2006.

I'm starting to get REAL Curious and ANXIOUS about 3.9.

Kenn
LBNL

On Mon, Oct 18, 2010 at 12:33 PM, Thomas Sibley wrote:

> On 18 Oct 2010 15:16, Kenneth Crocker wrote:
> > I noticed that on any ticket in our environment (3.8.7) an unprivileged
> > user that is a "requestor" has additional info displayed about them
> > under the Blue box entitled "More about Name of User". I never noticed
> > this before.
> >
> > When did this start happening?
>
> Version control history is useful here.  It appears the first
> incarnation was committed in early 2001 with b406f098.
>
> > Is there a way to turn it off?
>
> Not in 3.8 unless you want to override
> share/html/Ticket/Elements/ShowRequestor.  3.9-trunk already includes
> much more control over this element.
>
> Thomas
>
> > I hate to look like a */dufus/*, but I really never noticed any info on
> > this feature before. Any help would be appreciated.
> >
> > Thanks.
> >
> > Kenn
> > LBNL
>
>


Re: [rt-users] Curious about "People" display for unprivileged users

2010-10-18 Thread Thomas Sibley
On 18 Oct 2010 15:16, Kenneth Crocker wrote:
> I noticed that on any ticket in our environment (3.8.7) an unprivileged
> user that is a "requestor" has additional info displayed about them
> under the Blue box entitled "More about Name of User". I never noticed
> this before.
> 
> When did this start happening?

Version control history is useful here.  It appears the first
incarnation was committed in early 2001 with b406f098.

> Is there a way to turn it off?

Not in 3.8 unless you want to override
share/html/Ticket/Elements/ShowRequestor.  3.9-trunk already includes
much more control over this element.

Thomas

> I hate to look like a */dufus/*, but I really never noticed any info on
> this feature before. Any help would be appreciated.
> 
> Thanks.
> 
> Kenn
> LBNL



[rt-users] Curious about "People" display for unprivileged users

2010-10-18 Thread Kenneth Crocker
To all,

I noticed that on any ticket in our environment (3.8.7) an unprivileged user
that is a "requestor" has additional info displayed about them under the
Blue box entitled "More about Name of User". I never noticed this before.

When did this start happening?

Is there a way to turn it off?

I hate to look like a *dufus*, but I really never noticed any info on this
feature before. Any help would be appreciated.

Thanks.

Kenn
LBNL


Re: [rt-users] how to pre-fill fields?

2010-10-18 Thread Mathieu Longtin
My bad, all access to ARGSRef need to be like this:

   $ARGSRef->{'id'}
   $ARGSRef->{'Subject'}

With the ->.

--
Mathieu Longtin
1-514-803-8977


On Sun, Oct 17, 2010 at 8:48 PM, Jason Edgar  wrote:

> Thanks Mathieu: I got it. An extra $ was needed before ARGSRef from line 3.
> I have no idea what it is for, I followed other examples from the Internet.
> Also the description field is called 'content'. Thanks again.
>
>
> On Sun, 17 Oct 2010 11:35:08 -0400, Mathieu Longtin wrote:
> > <%INIT>
> > my $ARGSRef = $ARGS{'ARGSRef'};
> > if ( not $ARGSRef{'id'} ) { # Check if the ticket is really empty
> > before doing anything   $ARGSRef{'Subject'} ||= 'Default subject';
> > $ARGSRef{'Requestor'} ||= 'mydefa...@requestor.com'; } 
> > <%ARGS> 
>
>
>

RT Training in Washington DC, USA on Oct 25 & 26 2010
Last one this year -- Learn how to get the most out of RT!

Re: [rt-users] RT Query not allowing any Custom Field selection

2010-10-18 Thread Raed El-Hames
Ø  Where did you find that? I don't remember any instructions on having to use 
quotes around a CF name. Did I miss that or did you come by that info via trail 
& error?

Working with RT for 8 years, you come across all sorts :¬)
Roy

From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Kenneth Crocker
Sent: 15 October 2010 20:59
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Query not allowing any Custom Field selection

Raed,

That did it. Where did you find that? I don't remember any instructions on 
having to use quotes around a CF name. Did I miss that or did you come by that 
info via trail & error?

Now, again, I owe you MORE beer. ;-).

Thanks.

Kenn
LBNL
On Fri, Oct 15, 2010 at 9:44 AM, Raed El-Hames 
mailto:raed.el-ha...@vialtus.com>> wrote:
Ken:

Can't see much wrong , the only thing I noticed CF.{DS-SubjectArea} should be 
'CF.{DS-SubjectArea}'
Not sure if it makes any difference
As a first step, I would suggest as you  are directed to the Advanced page, add 
the ' around the CF name and hit apply, then see what happens and if you can 
search, if it works, then the next step is finding out why its not adding ' in 
the first place.

Regards;
Roy

From: 
rt-users-boun...@lists.bestpractical.com
 
[mailto:rt-users-boun...@lists.bestpractical.com]
 On Behalf Of Kenneth Crocker
Sent: 15 October 2010 17:15

To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Query not allowing any Custom Field selection

Raed,

Just keep it up guy, and I'm gonna end up owing you an entire brewery. ;-).

This is what is in "Advance":

( Queue = 'DS-BRS' OR Queue = 'DS-Development' ) AND CF.{DS-SubjectArea} = 
'Expense'

and it won't let me get out of it. If I hit "ShowResults", it just shows ALL 
tickets in those two Queues, regardless of the CF value.

The funny thing is, I checked the DB records and the values are there, the 
OBJECTCUSTOMFIELDVALUES records are there (not disabled) for several tickets, 
the Tickets show the values in Display, Privileges are correct for the group 
I'm in (plus I'm a SuperUser), CF is applied to these Queues (duh, wouldn't see 
them in Display otherwise), etc. All data in the DB seems quite correct. RT is 
being VERY STUBBORN about this.

Any ideas?

Kenn
LBNL
On Fri, Oct 15, 2010 at 2:25 AM, Raed El-Hames 
mailto:raed.el-ha...@vialtus.com>> wrote:
Hi Ken:

It usually throw you into the Advanced tab when the sql generated is not 
properly formatted into FromSQL ..
Can you share what you get in the advanced Query ? it may also be a problem in 
the displayed fields listed in Format.

Regards;
Roy



From: 
rt-users-boun...@lists.bestpractical.com
 
[mailto:rt-users-boun...@lists.bestpractical.com]
 On Behalf Of Kenneth Crocker
Sent: 15 October 2010 00:40
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT Query not allowing any Custom Field selection

To List,

I'm getting a wierd result when trying to create a search looking for a certain 
value in a Custom Field that is applied to a couple Queues.
I check the Queues and add them, no problem. I check the Custom Field and add 
it and I am immediately thrown into "Advanced". Every change I make after that 
cannot be applied. I just end up back in the "Advanced" screen. It acts like 
there is no such Custom FIeld. I tried "Like" and "is" and no joy.

I've checked the Custom Field and it IS applied to those Queues.
The Values ARE available for "Select One"
I am a SuperUser so I should have rights to it, but I went ahead and added 
"AdminCustomField", "ModifyCustomField" and "SeeCustomField" to the group I'm 
in anyway. Still no joy.

When I run an SQL in SQL Navigator against the OBJECTCUSTOMFIELDVALUES Table 
with this code:

select *
from OBJECTCUSTOMFIELDVALUES
where CustomField = 50111
  and (Content = 'Ledger' or Content = 'Expense');

I got 12 records. None are disabled.

I'm in 3.8.7 and Queries without Custom Fields are working fine.

Has anyone noticed this?

Was it mentioned awhile back and I missed it?

Thanks in advance.

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!