<HTML xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=utf-8" /><meta name=Generator content="Microsoft Word 12 (filtered medium)" /><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=EN-AU link=blue vlink=purple>
<P><BR /><div class=WordSection1><p class=MsoNormal><span style=color:black>Hello,<o:p></o:p></span></p><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p><p class=MsoNormal><span style=color:black>Just a quick followup, having done some more work on this: I think I am getting a little closer here but I am still running up against some problems. I have modified REST/1.0/search/ticket as follows:<o:p></o:p></span></p><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p><p class=MsoNormal><span style=color:black><%ARGS><o:p></o:p></span></p><p class=MsoNormal><span style=color:black>$restrictUser => undef<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>$query<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>$format => undef<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>$orderby => undef<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>$fields => undef<o:p></o:p></span></p><p class=MsoNormal><span style=color:black></%ARGS><o:p></o:p></span></p><p class=MsoNormal><span style=color:black><%INIT><o:p></o:p></span></p><p class=MsoNormal><span style=color:black>use RT::Interface::REST;<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>my $output = "";<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>my $status = "200 Ok";<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>my $user = new RT::User;<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>$user->Load($restrictUser) if ( defined $restrictUser );<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>$user = $session{CurrentUser} unless ( $user->Id );<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>my $tickets = RT::Tickets->new($user);<o:p></o:p></span></p><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p><p class=MsoNormal><span style=color:black>There are no changes anywhere further down in the file. The error message I am getting is:<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>RT/4.0.6 400 Bad request<o:p></o:p></span></p><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p><p class=MsoNormal><span style=color:black>Invalid query: 'No currentuser at /var/www/ticket.obfuscated.com/sbin/../lib/RT/Base.pm line 139.<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> RT::Base::loc('RT::User=HASH(0x7f14e81bff60)', 'Valid Query') called at /var/www/ticket.obfuscated.com/sbin/../lib/RT/Base.pm line 135<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> RT::Base::loc('RT::Tickets=HASH(0x7f14e81c0068)', 'Valid Query') called at /var/www/ticket.obfuscated.com/sbin/../lib/RT/Tickets_SQL.pm line 339<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> RT::Tickets::FromSQL('RT::Tickets=HASH(0x7f14e81c0068)', 'queue=\'ithelp\'') called at /var/www/ticket.obfuscated.com/share/html/REST/1.0/search/ticket line 93<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> eval {...} called at /var/www/ticket.obfuscated.com/share/html/REST/1.0/search/ticket line 92<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Commands::__ANON__('pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', 'user', 'chriso') called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 138<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x637c348)', 'pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', 'user', 'chriso', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1305<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1295<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Request::comp(undef, undef, undef, 'pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 958<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Request::call_next('RT::Interface::Web::Request=HASH(0x610a820)') called at /var/www/ticket.obfuscated.com/share/html/REST/1.0/autohandler line 54<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Commands::__ANON__('pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', 'user', 'chriso') called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 138<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x638c730)', 'pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', 'user', 'chriso', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1305<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1295<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Request::comp(undef, undef, undef, 'pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', ...) called at /var/www/ticket.obfuscated.com/sbin/../lib/RT/Interface/Web.pm line 568<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> RT::Interface::Web::ShowRequestedPage('HASH(0x6386cc0)') called at /var/www/ticket.obfuscated.com/sbin/../lib/RT/Interface/Web.pm line 318<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> RT::Interface::Web::HandleRequest('HASH(0x6386cc0)') called at /var/www/ticket.obfuscated.com/share/html/autohandler line 53<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Commands::__ANON__('pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', 'user', 'chriso') called at /usr/local/share/perl/5.10.1/HTML/Mason/Component.pm line 138<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x638d0c0)', 'pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', 'user', 'chriso', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1300<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 1295<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Request::comp(undef, undef, undef, 'pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 484<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 484<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/Request.pm line 436<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Request::exec('RT::Interface::Web::Request=HASH(0x610a820)') called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 85<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 85<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Request::PSGI::exec('RT::Interface::Web::Request=HASH(0x610a820)') called at /usr/local/share/perl/5.10.1/HTML/Mason/Interp.pm line 345<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::Interp::exec(undef, undef, 'pass', 'obfuscated', 'query', 'queue=\'ithelp\'', 'restrictUser', 'chriso', 'user', ...) called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 48<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> eval {...} called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler.pm line 48<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::PSGIHandler::invoke_mason('HTML::Mason::PSGIHandler::Streamy=HASH(0x6222bf8)', 'HTML::Mason::FakeApache=HASH(0x631a2d8)', 'HASH(0x375e6d8)') called at /usr/local/share/perl/5.10.1/HTML/Mason/PSGIHandler/Streamy.pm line 52<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> HTML::Mason::PSGIHandler::Streamy::__ANON__('CODE(0x6317778)') called at /var/www/ticket.obfuscated.com/sbin/../lib/RT/Interface/Web/Handler.pm line 263<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> RT::Interface::Web::Handler::__ANON__('CODE(0x6317778)') called at /usr/local/share/perl/5.10.1/Plack/Util.pm line 301<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> Plack::Util::__ANON__('CODE(0x63174d8)') called at /usr/local/share/perl/5.10.1/Plack/Handler/FCGI.pm line 130<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> Plack::Handler::FCGI::run('Plack::Handler::FCGI=HASH(0x6258528)', 'CODE(0x60f4760)') called at /usr/local/share/perl/5.10.1/Plack/Loader.pm line 84<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> Plack::Loader::run('Plack::Loader=HASH(0x622f070)', 'Plack::Handler::FCGI=HASH(0x6258528)') called at /usr/local/share/perl/5.10.1/Plack/Runner.pm line 267<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> Plack::Runner::run('Plack::Runner=HASH(0x5b596b8)', 'CODE(0x60f4760)') called at /var/www/ticket.obfuscated.com/sbin/rt-server.fcgi line 232<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> eval {...} called at /var/www/ticket.obfuscated.com/sbin/rt-server.fcgi line 232<o:p></o:p></span></p><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p><p class=MsoNormal><span style=color:black>Stack:<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> [/usr/local/share/perl/5.10.1/Carp.pm:101]<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> [/var/www/ticket.obfuscated.com/sbin/../lib/RT/Base.pm:139]<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> [/var/www/ticket.obfuscated.com/sbin/../lib/RT/Base.pm:135]<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> [/var/www/ticket.obfuscated.com/sbin/../lib/RT/Tickets_SQL.pm:339]<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> [/var/www/ticket.obfuscated.com/share/html/REST/1.0/search/ticket:93]<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> [/var/www/ticket.obfuscated.com/share/html/REST/1.0/autohandler:54]<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> [/var/www/ticket.obfuscated.com/sbin/../lib/RT/Interface/Web.pm:568]<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> [/var/www/ticket.obfuscated.com/sbin/../lib/RT/Interface/Web.pm:318]<o:p></o:p></span></p><p class=MsoNormal><span style=color:black> [/var/www/ticket.obfuscated.com/share/html/autohandler:53]<o:p></o:p></span></p><p class=MsoNormal><span style=color:black>'.<o:p></o:p></span></p><p class=MsoNormal><span style=color:black><o:p> </o:p></span></p><p class=MsoNormal><span style=color:black>So it seems to get through to running the query in search/ticket, and in Tickets_SQL it gets to the point of returning "Valid Query", however I have problems when it gets to this 'loc' function. Reading suggests to me it is for localization of strings but I flat out do not understand it's logic. If I read Base.pm correctly (and I assume I did not), the loc sub checks if it's passed argument has an OriginalUser property and, if it does, returns the value returned by calling itself on that user... if the argument does have an OriginalUser method it returns an error. This makes it seems as though it will always either return an error or begin an infinite loop. I've added a logger statement right before the loc call in Tickets_SQL.pm to log the value of $Self->OriginalUser->Id and it always logs a value (my id, fwiw) so as far as I can tell there is an OriginalUser property. Any thoughts? <o:p></o:p></span></p></div>
<BR />
<TABLE style="WIDTH: 473px; HEIGHT: 165px" border=0 cellSpacing=0 cellPadding=0 width=473>
<TBODY>
<TR>
<TD style="HEIGHT: 50px" colSpan=3><SPAN style="LINE-HEIGHT: 16px; FONT-FAMILY: Arial, Helvetica, sans-serif; FONT-SIZE: 12px"><span style='font-family:Arial; font-size:11pt; font-weight: bold; '>Chris</span> <span style='font-family:Arial; font-size:11pt; font-weight: bold; '>O'Kelly</span><BR /><SPAN style="FONT-SIZE: 14px"><B><span style='font-family:Arial; font-size:9pt; font-weight: normal; '>Web Administrator</span></B></SPAN><BR /></SPAN></TD></TR>
<TR>
<TD style="WIDTH: 178px" height=112 vAlign=top width=199 align=left><SPAN style="LINE-HEIGHT: 16px; FONT-FAMILY: Arial, Helvetica, sans-serif; FONT-SIZE: 12px"><table class=7f172dc6-f7d4-483a-a4cd-5841754651fbTable><tr><td><span style='font-family:Arial; font-size:x-small; color: #000000; font-weight: bold; '>Minecorp Australia</span></td></tr><tr><td><span style='font-family:arial; font-size:9pt; '>37 Murdoch Circuit</span></td></tr><tr><td><span style='font-family:arial; font-size:9pt; '>Acacia Ridge QLD 4110</span></td></tr><tr><td><span style='font-family:Arial; font-size:9pt; color: #0070C0; '><span style='font-family:arial; font-size:9pt; color: #0070C0; font-weight: bold; '><span style='font-family:arial; font-size:9pt; color: #0070C0; font-weight: bold; '><a href='http://www.minecorp.com.au' title='Minecorp Vehicle Solutions' target=''><span style='font-family:arial; font-size:9pt; color: #0070C0; font-weight: bold; '>minecorp.com.au</span></a></span></span></span></td></tr></table><BR /></SPAN></TD>
<TD style="WIDTH: 290px" height=112 vAlign=top width=250 align=left><SPAN style="LINE-HEIGHT: 16px; FONT-FAMILY: Arial, Helvetica, sans-serif; FONT-SIZE: 12px"><B><table class=7f172dc6-f7d4-483a-a4cd-5841754651fbTable><tr><td width=600px><span style='font-family:Arial; font-size:9pt; font-weight: bold; '>P: 07 3723 1000</span></td></tr><tr><td width=600px><span style='font-family:Arial; font-size:9pt; font-weight: bold; '>M: 0450 586 190</span></td></tr><tr><td width=600px><span style='font-family:arial; font-size:9pt; font-weight: bold; '>E: <a href='mailto:Chris.okelly@minecorp.com.au' title='Click to send email to Chris O'Kelly' target=''>Chris.okelly@minecorp.com.au</a></span></td></tr><tr><td width=600px><span style='font-family:Arial; font-size:9pt; color: #4F81BD; font-weight: bold; '>S: <a href='http://skype.com' title='' target=''>chris.okelly.mvs</a></span></td></tr></table><BR /></B></SPAN></TD></TR></TBODY></TABLE> <IMG id=IMG1 border=0 src="http://oi46.tinypic.com/mw8nbd.jpg" width=430 height=132 /><BR /><BR />
</P></BODY></HTML>