I don't see a URL field in any of the HD* tables??

Thanks

Answer Summary:
There isn't an explicit URL field in the table, you need to generate it yourself as part of the email message and use the HD_TICKET.ID field for the ticket ID to append to the URL for your KBOX. If your select statement gets HD_TICKET.ID as TICKETID, then in the email message you would include: http:///adminui/ticket.php?ID=$ticketid
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Community Chosen Answer

3

There isn't an explicit URL field in the table, you need to generate it yourself as part of the email message and use the HD_TICKET.ID field for the ticket ID to append to the URL for your KBOX.

If your select statement gets HD_TICKET.ID as TICKETID, then in the email message you would include:

http://<your KBOX servername>/adminui/ticket.php?ID=$ticketid

 

Answered 04/11/2012 by: chucksteel
Red Belt

  • Thanks! So obvious... sigh.
Please log in to comment

Answers

0

HD_TICKET look for the ID, it will use PHP to generate the URL.

If the Ticket ID / Ticket TICK:0021, it will display as http://k1000/adminui/ticket.php?ID=21

Answered 04/11/2012 by: Aaron Cool
Red Belt

Please log in to comment
Answer this question or Comment on this question for clarity

Share