[rt-users] Installation woes

[John Paul Hayes]

Hi all!

Just a quick one here.
I obtained a fresh copy of RT and tried to install it on my linux server.
However, the installation failed when trying to change permissions.

Now as a result, mysql and ssh have all failed.

Has anybody come across this before?

Any help would be much appreciated!

regards

John
___
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] DB Query

[John Paul Hayes]

Hi All,

Thank you for the help, very much appreciated.

On 5/9/07, Steen Olesen <[EMAIL PROTECTED]> wrote:


 Hi,

In our RT we have a ticket-custom field holding the Customer Id. The
following SQL shows the number of tickets per customer id:

select
   objcf1.content CustomerId, count(*) TicketCount
from
   tickets,   customfields cf1, objectcustomfieldvalues objcf1
where
   objcf1.objectid=tickets.id
   and objcf1.objecttype='RT::Ticket'
   and objcf1.customfield=cf1.id
   and cf1.name='Customer ID'
   and tickets.status in ('new','open','stalled','offer')
group by
   objcf1.content
The syntax for the SQL may vary depending on the database (we're running
Oracle).

/Steen

 --
*From:* [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED] *On Behalf Of *John Paul Hayes
*Sent:* Tuesday, May 08, 2007 6:25 PM
*To:* rt-users@lists.bestpractical.com
*Subject:* [rt-users] DB Query

Hi All,

I am running a script with accesses the rtdb directly (for speed
purposes). One of the requirements is that I have to
find any ticket what was resolved with a custom field entry selected.

Does anybody know off hand how to link a ticket id to the custom field
entry id in the db?

Thanks in advance,
JP




--

"If you make people think they're thinking, they'll love you; but if you
really make them think they'll hate you."

— Don Marquis





--

"If you make people think they're thinking, they'll love you; but if you
really make them think they'll hate you."

— Don Marquis
___
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] DB Query

[John Paul Hayes]

Hi All,

I am running a script with accesses the rtdb directly (for speed purposes).
One of the requirements is that I have to
find any ticket what was resolved with a custom field entry selected.

Does anybody know off hand how to link a ticket id to the custom field entry
id in the db?

Thanks in advance,
JP




--

"If you make people think they're thinking, they'll love you; but if you
really make them think they'll hate you."

— Don Marquis
___
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] Attachments

[John Paul Hayes]

Hi All,

I'm currently developing a form which performs some basic ticket
manipulations
eg,  set priority, due date etc...
Now the requirement to add attachments has arisen on this form.

I've searched the archives for relevant information on this but I cannot
find any.
So hence this post.

Has anybody developed such a form with this functionality before?
If so, would they be kind enought to point me in the right direction.

Thank you in advance,
Jp
___
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] Forwarding attachments

[John Paul Hayes]

Hello All,

Just a quick question, is it possible to forward received e-mails with
attachments to external addresses without loosing the original
attachement?

Thanks in advance,
jp

___
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