Home >FAQ >Folder HelpDesk kalmstrom.com site map icon Site map  

kalmstrom.com FAQ – Folder HelpDesk


Type Usage

Problem Delete tickets from the database. How do I do that?

Delete tickets from the database. How do I do that?

Use the Folder HelpDesk buttons to delete a ticket both from Outlook and from the database.


From the ticket list in the Folder HelpDesk folder you can delete a ticket from Outlook and from the database by using the
Delete button in the Folder HelpDesk toolbar in the Outlook ribbon.










From inside the ticket you can delete it from Outlook and from the database with the X button in the Toolbar strip.




If you have deleted tickets only in Outlook, and wish to delete them from the database later, you have two alternatives:

  • Use the Search Closed Tickets feature and reopen the tickets you wish to delete from the database.

    Then use the Delete button in the Outlook toolbar do delete the tickets.
  • Delete directly in the database.

    Closed tickets have blnClosed = "-1" in an Access database and "1" in an SQL database.

    Use one of these queries:

    Access:
    Delete from tblTickets where strTicketID="[TicketID]"
    Delete from tblTicketMsgs where intTicketID= [TicketID]
    Delete from tblWork where intTicketID= [TicketID]

    SQL:
    Delete from tblTickets where strTicketID='[TicketID]'
    Delete from tblTicketMsgs where intTicketID= [TicketID]
    Delete from tblWork where intTicketID= [TicketID]

    Replace "[TicketID] with the ID of the ticket you want to delete.
Note that tickets that are deleted from the database cannot be seen in the Excel reports.