Re: [rt-users] Retrieving CustomFields with RT-Jasper
On Mon, Apr 29, 2013 at 06:41:07AM +, Michael Keetman wrote: > Hello, > > I am not entirely sure this is the right forum for this question, however the > only other information I can find about RT-Jasper is in this and the Devel > mailing lists. > > I have managed to install the RT-Jasper and RT-REST packages, and > successfully run a report with the ID and Subject shown (both fields exposed > directly) using Jasper Reports server, however I have had no luck getting any > Custom Fields to return any data. > > Can anyone supply sample JRXML showing how this is done? > > Regards, > > Michael Keetman > I have the exact same problem. The Subject and ID fields can be pulled, but no other global field or custom field is even acknowledged as a valid field. I have not had time to investigate further. If anyone has any ideas...? Regards, Ken
[rt-users] Upgrade from RT 4.0.9 to 4.0.11
I have been running RT 4.0.9 without issue on CentOS 6.4 for a few months. I went through the upgrade and after completed the login screen still have 4.0.9. I then did a fresh install on a VM and the login screen properly shows 4.0.11. Steps: unpacked 4.0.11 then ran ./configure, ran make testdeps and no issues, ran make upgrade then make upgrade-database (showed nothing to be done on DB since 4.0.9), cleared Mason cache and restarted apache. Any ideas if I am missing a step? -- View this message in context: http://requesttracker.8502.n7.nabble.com/Upgrade-from-RT-4-0-9-to-4-0-11-tp53677.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
[rt-users] Collecting info from child tickets (scrip action)
I asked about this once and didn't get a response, 2nd (and final) try…
I'm trying to write a script that pokes around in child tickets. My abridged
version of it:
my $Children = $self->TicketObj->Members();
while( my $childTicket = $Children->Next ) {
my $childId = $childTicket->TargetObj->id;
# Do some other stuff here
}
return 1;
However the above only gives me information about the ticket I started in (i.e.
$self->TicketObj). For whatever reason, the following work as anticipated:
$self->TicketObj->MemberOf();
$self->TicketObj->DependsOn();
$self->TicketObj->RefersTo();
And these simply cough up the same ticket I started with:
$self->TicketObj->Members();
$self->TicketObj->DependedOnBy();
$self->TicketObj->ReferredToBy();
Any ideas? We're running v4.0.4.
Thank you,
-Tyler
Re: [rt-users] Retrieving CustomFields with RT-Jasper
On Mon, Apr 29, 2013 at 10:41 AM, Michael Keetman < michael.keet...@qcn.com.au> wrote: > Hello, > > ** ** > > I am not entirely sure this is the right forum for this question, however > the only other information I can find about RT-Jasper is in this and the > Devel mailing lists. > > ** ** > > I have managed to install the RT-Jasper and RT-REST packages, and > successfully run a report with the ID and Subject shown (both fields > exposed directly) using Jasper Reports server, however I have had no luck > getting any Custom Fields to return any data. > > ** ** > > Can anyone supply sample JRXML showing how this is done? > Isn't it easier to let jasper talk to RT's DB directly? > ** > > Regards, > > ** ** > > *Michael Keetman* > > ** ** > -- Best regards, Ruslan.
Re: [rt-users] Retrieving CustomFields with RT-Jasper
On Mon, Apr 29, 2013 at 08:23:34PM +0400, Ruslan Zakirov wrote: > On Mon, Apr 29, 2013 at 10:41 AM, Michael Keetman < > michael.keet...@qcn.com.au> wrote: > > > Hello, > > > > ** ** > > > > I am not entirely sure this is the right forum for this question, however > > the only other information I can find about RT-Jasper is in this and the > > Devel mailing lists. > > > > ** ** > > > > I have managed to install the RT-Jasper and RT-REST packages, and > > successfully run a report with the ID and Subject shown (both fields > > exposed directly) using Jasper Reports server, however I have had no luck > > getting any Custom Fields to return any data. > > > > ** ** > > > > Can anyone supply sample JRXML showing how this is done? > > > > Isn't it easier to let jasper talk to RT's DB directly? > > Jasper can definitely talk to RT's DB directly very simply. The problem is that then you have to implement RT in the report tool. Using REST makes access trivial. Regards, Ken
[rt-users] Unmerge ticket history truncation
Hi all. I recently unmerged a ticket using 'Set EffectiveId = id where id = ticket# and now one of those tickets has this as it's apparently oldest transaction "Modification of non-creatable array value attempted, subscript -1 at /path/to/perl/lib/perl5/HTML/Quoted.pm line 249". The ticket history is truncated from there onwards. The other ticket is fine. I can see by examining the Transaction and Attachments tables that the content for the hurting ticket is still there and looks fine though I've not validated references / counts etc. Any ideas/suggestions? thanks ram
Re: [rt-users] Upgrade from RT 4.0.9 to 4.0.11
I figured it out. No need to reply. -- View this message in context: http://requesttracker.8502.n7.nabble.com/Upgrade-from-RT-4-0-9-to-4-0-11-tp53677p53682.html Sent from the Request Tracker - User mailing list archive at Nabble.com.
Re: [rt-users] Help - "Deep Recursion on subroutine..."
On 04/26/2013 10:28 PM, Jason Doller wrote: > I've fixed and checked all the potential problems listed, and the > "support" email address may have been the problem. > > However, I've turned off postfix, and I'm still getting the errors > below. I realise I can probably clear a cache to stop this, but with > postfix turned off, nothing is injecting new mails into the system, I'm > concerned that this problem isn't going away. I've also (temporarily) > turned off loop mail forwarding to owner... For those errors to pop up in your logs again, *something* is submitting mail to RT. Look at your access logs for hits to /REST/1.0/NoAuth/mail-gateway.
Re: [rt-users] Collecting info from child tickets (scrip action)
Links have a target and a base (a destination and source), and therefore
can be expressed in two directions. RefersTo is the inverse of
ReferredToBy, and vice versa. In the database, links are stored in as
canonical types and directionality is determined by which object is the
target and which is the base. In the API, directionality and
base/target combinations are exposed through the methods you found.
You're ending up with the same ticket you started with because you're
looking at the wrong end of the link.
On 04/29/2013 08:17 AM, Tyler Harding wrote:
> I asked about this once and didn't get a response, 2nd (and final) try…
>
> I'm trying to write a script that pokes around in child tickets. My
> abridged version of it:
>
> my $Children = $self->TicketObj->Members();
> while( my $childTicket = $Children->Next ) {
> my $childId = $childTicket->TargetObj->id;
> # Do some other stuff here
> }
> return 1;
>
> However the above only gives me information about the ticket I started
> in (i.e. $self->TicketObj). For whatever reason, the following work as
> anticipated:
>
> $self->TicketObj->MemberOf();
> $self->TicketObj->DependsOn();
> $self->TicketObj->RefersTo();
>
> And these simply cough up the same ticket I started with:
>
> $self->TicketObj->Members();
> $self->TicketObj->DependedOnBy();
> $self->TicketObj->ReferredToBy();
>
> Any ideas? We're running v4.0.4.
>
> Thank you,
>
> -Tyler
Re: [rt-users] Upgrade from RT 4.0.9 to 4.0.11
On 04/29/2013 02:28 PM, Carlos Santos wrote: I figured it out. No need to reply. Would you mind including your solution in case someone having the same issue is searching the archives?
Re: [rt-users] Retrieving CustomFields with RT-Jasper
Hi, I have made some progress with this after a good night's sleep. First of all, I pulled in a patch which exposes all the global fields (details here: https://github.com/bboksa/RT-REST/pull/1) (instead of just id, subject and timeworked) Secondly, I spent time with the JRXML and a java debugger, and discovered the main problem is that the customFields is a hashmap supplied to the Reports server. This needs to be dereferenced and cast to the appropriate class (RTCustomField) to access the values. An example: Specification of the field: Then when defining the text field in the report, this then needs to be cast to expose the customField value (in this case a custom field indicating the "Incident Start DateTime") like so: Hopefully this is understandable, and is helpful. I am not a Java programmer by any means, so if anyone here can suggest a better method, I am all ears. Regards, Michael Keetman -Original Message- From: k...@rice.edu [mailto:k...@rice.edu] Sent: Tuesday, 30 April 2013 2:51 AM To: Ruslan Zakirov Cc: Michael Keetman; rt-users@lists.bestpractical.com Subject: Re: [rt-users] Retrieving CustomFields with RT-Jasper On Mon, Apr 29, 2013 at 08:23:34PM +0400, Ruslan Zakirov wrote: > On Mon, Apr 29, 2013 at 10:41 AM, Michael Keetman < > michael.keet...@qcn.com.au> wrote: > > > Hello, > > > > ** ** > > > > I am not entirely sure this is the right forum for this question, > > however the only other information I can find about RT-Jasper is in > > this and the Devel mailing lists. > > > > ** ** > > > > I have managed to install the RT-Jasper and RT-REST packages, and > > successfully run a report with the ID and Subject shown (both fields > > exposed directly) using Jasper Reports server, however I have had no > > luck getting any Custom Fields to return any data. > > > > ** ** > > > > Can anyone supply sample JRXML showing how this is done? > > > > Isn't it easier to let jasper talk to RT's DB directly? > > Jasper can definitely talk to RT's DB directly very simply. The problem is that then you have to implement RT in the report tool. Using REST makes access trivial. Regards, Ken
