Re: [rt-users] maintainably tagging custom fields for CSS
Nicholas Clark [EMAIL PROTECTED] writes:
You can find the formal syntax and grammar for CSS2 here:
http://www.w3.org/TR/REC-CSS2/grammar.html
From that definition and the examples given in
http://www.w3.org/TR/REC-CSS2/syndata.html, you can do things like:
ident {nmstart}{nmchar}*
name {nmchar}+
nmstart [a-zA-Z]|{nonascii}|{escape}
nonascii [^\0-\177]
unicode \\[0-9a-f]{1,6}[ \n\r\t\f]?
escape{unicode}|\\[ -~\200-\417]
nmchar[a-z0-9-]|{nonascii}|{escape}
Mmm. Are they serious that upper case ASCII is only allowed in nmstart and
not nmchar?
I should think not. :)
And, indeed, http://www.w3.org/TR/REC-CSS2/grammar.html section D.2
includes the crucial '%option case-insensitive'. IIUC, CSS doesn't
really care about case, except in quoted strings.
--
Espen Wiborg [EMAIL PROTECTED]
On a Canadian two dollar bill, the flag flying over the Parliament
building is an American flag.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Insert blank column in results
Keith; Have you tried selecting NEWLINE from Display Columuns (give it a title of blank if you wish)?? Roy Keith Edmunds wrote: On Thu, 16 Aug 2007 08:56:09 -0400, [EMAIL PROTECTED] said: Doesn't look like the Search Builder UI has a blank element for you to add. What you can do is construct or load your search and then switch to the Advanced page. The lower text box lists the results fields - you can insert blank fields like this: '', Thanks for the suggestion, but it doesn't seem to work. No error, but no blank column output either. Keith ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
Re: [rt-users] Insert blank column in results
On Thu, 16 Aug 2007 08:56:09 -0400, [EMAIL PROTECTED] said: Doesn't look like the Search Builder UI has a blank element for you to add. What you can do is construct or load your search and then switch to the Advanced page. The lower text box lists the results fields - you can insert blank fields like this: '', Thanks for the suggestion, but it doesn't seem to work. No error, but no blank column output either. Keith ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
[rt-users] Slow Query
I have few queries that are extremely slow. I am using RT 3.4.5, Perl
5.8.6, Solaris 10 x86, Apache/1.3.33 (Unix) mod_perl/1.29
mod_ssl/2.8.22 OpenSSL/0.9.7g, mysql 4.0.24, DBIx::SearchBuilder 1.40.
Is there any tweak to fix the slow querry?
Slow Query Logs:
# Query_time: 558 Lock_time: 0 Rows_sent: 0 Rows_examined: 2442535
SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions
Transactions_1, Attachments Attachments_2 WHERE ((Transactions_1.O
bjectType = 'RT::Ticket')) AND ((main.EffectiveId = main.id)) AND
((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( (
(Attachments_2.Content LIKE
'%txcomber%')AND(Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.ObjectId
) ) );
# Query_time: 535 Lock_time: 0 Rows_sent: 1 Rows_examined: 1733112
SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions
Transactions_1, Attachments Attachments_2 WHERE ((Transactions_1.O
bjectType = 'RT::Ticket')) AND ((main.EffectiveId = main.id)) AND
((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( (
(Attachments_2.Content LIKE
'%txcomber%')AND(Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.ObjectId
) ) );
# Query_time: 526 Lock_time: 0 Rows_sent: 1 Rows_examined: 1733130
SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions
Transactions_1, Attachments Attachments_2 WHERE ((Transactions_1.O
bjectType = 'RT::Ticket')) AND ((main.EffectiveId = main.id)) AND
((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( (
(Attachments_2.Content LIKE
'%txcomber%')AND(Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.ObjectId
) ) );
# Query_time: 528 Lock_time: 0 Rows_sent: 0 Rows_examined: 1733137
SELECT DISTINCT main.* FROM Tickets main , Transactions
Transactions_1, Attachments Attachments_2 WHERE
((Transactions_1.ObjectTyp
e = 'RT::Ticket')) AND ((main.EffectiveId = main.id)) AND
((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( (
(Attach
ments_2.Content LIKE '%txcomber%')AND(Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.ObjectId) ) ) O
RDER BY main.id ASC;
# Query_time: 2095 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT GET_LOCK('Apache-Session-d7ca7d5da9351479f35fdc4b88daa536', 3600);
# Query_time: 541 Lock_time: 0 Rows_sent: 1 Rows_examined: 1733137
SELECT COUNT(DISTINCT main.id) FROM Tickets main , Transactions
Transactions_1, Attachments Attachments_2 WHERE ((Transactions_1.O
bjectType = 'RT::Ticket')) AND ((main.EffectiveId = main.id)) AND
((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( (
(Attachments_2.Content LIKE
'%txcomber%')AND(Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.ObjectId
) ) );
RT logs:
[Fri Aug 17 13:16:13 2007] [warning]: Duplicate specification for
option (/opt/rt3/lib/RT.pm:287)
[Fri Aug 17 13:16:13 2007] [warning]: Queue-CustomFields is
deprecated, use Queue-TicketCustomFields instead at
(main:/usr/local/bin/rt:682) at /opt/rt3/lib/RT/Queue_Overlay.pm line
524. (/opt/rt3/lib/RT.pm:287)
[Fri Aug 17 13:16:15 2007] [warning]: Use of uninitialized value in
pattern match (m//) at /usr/local/lib/perl5/5.8.6/Getopt/Long.pm line
315. (/opt/rt3/lib/RT.pm:287)
[Fri Aug 17 13:16:15 2007] [warning]: Use of uninitialized value in
string eq at /usr/local/lib/perl5/5.8.6/Getopt/Long.pm line 317.
(/opt/rt3/lib/RT.pm:287)
[Fri Aug 17 13:16:15 2007] [warning]: Use of uninitialized value in
pattern match (m//) at /usr/local/lib/perl5/5.8.6/Getopt/Long.pm line
686. (/opt/rt3/lib/RT.pm:287)
--
Asif Iqbal
PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
[rt-users] Remove RT signature from subject line
Hi All, I thought I'd seen this somewhere before, but I can't find the answer in my archives or the wiki. I want to use a template to send an e-mail, but I don't want the have the ticket info prepended to the original subject line. All of the e-mail coming into a particular queue address should be either generated by a web app or be a reply to an RT-generated e-mail. If an e-mail comes in that is not related to an existing ticket or is not a new ticket from the web app, it was sent to the wrong address and I want to forward it to what I think the intended address is. I'm able to make the generated mail look like the original mail (original from line, replaced reply-to, original content) except for the [MyOrg #2345] that gets pasted to the front of the subject line. There's probably a trick to sending mail without it, but I haven't stumbled across it yet. Thanks, Gene -- Gene LeDuc, GSEC Security Analyst San Diego State University ___ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
