]project-open[ : @This Wiki
Portrait

Welcome, Unregistered Visitor

Contact ·  Index · Login · Register
 

Contents

Remote Training
Support
SaaS Service

6 registered users
 in last 24 hours

]po[ Helpdesk & ITSM PL/SQL API

The following PL/SQL API functions are related to the ]po[ helpdesk and ITSM functionality.

 

­ 

Configuration Item PL/SQL API

 

Please refer to the configuration item object type documentation for details on the object and the data model.

 

­Function Returns Arguments Description
[im_conf_item__delete] integer integer Destructor
[im_conf_item__name] varchar integer Name function
[im_conf_item__new] integer integer, varchar, timestamptz, integer, varchar, integer, varchar, varchar, integer, integer, integer Constructor
[im_conf_item_name_from_id] varchar integer Shortcut function to return the name of the object.
[im_conf_item_nr_from_id] varchar integer Shortcut function to return the conf_item_nr of the object.
­ ­

  ­

The following API functions allow to associate configuration items to projects, indicating that the configuration item has been modified as part of the project. Please refer to the [configuration item - project relationship] documentation for details on the functionality.

 

­
Function Returns Arguments Description
[im_conf_item_project_rel__delete] integer integer Destructor (specifying the relatinship_id).
[im_conf_item_project_rel__delete] integer integer, integer Destructor (specifying the conf_item_id and the project_id).
[im_conf_item_project_rel__new] integer integer, varchar, integer, integer, integer, integer, varchar, integer Constructor

 

Release Items PL/SQL API

 

Please refer to the [release item object type] documentation for details on the object and the data model.

 

Function Returns Arguments Description
[im_release_item__delete] integer integer Destructor
[im_release_item__delete] integer integer, integer Destructor
[im_release_item__new] integer integer, varchar, integer, integer, integer, integer, varchar, integer, integer Constructor

 

Helpdesk Ticket PL/SQL API

 

Please refer to the ITSM module overview and the helpdesk ticket object type documentation for details on the object and the data model.

 

Function Returns Arguments Description
[im_ticket__classify] integer integer, text, text PL/SQL function to classify the ticket into the ticket hierarchy and optionally assign the ticket to a specific queue.
[im_ticket__delete] integer integer Destructor
[im_ticket__name] varchar integer Name function
[im_ticket__new] integer integer, varchar, timestamptz, integer, varchar, integer, varchar, integer, integer, integer Constructor

 

Ticket Queue PL/API

 

Please refer to the ITSM module overview and the [ticket queue object type] documentation for details on the object and the data model.


Function Returns Arguments Description
[im_ticket_queue__delete] integer integer Destructor
[im_ticket_queue__new] integer integer, varchar, varchar, varchar, timestamptz, varchar, varchar, integer, integer, timestamptz, varchar, varchar Constructor

 

Ticket-Ticket Relationship PL/API

 

The ticket-ticket relationship allows associating problem tickets with issue tickets, and tickets with other tickets in general.


Function Returns Arguments Description
[im_ticket_ticket_rel__delete] integer integer Destructor (providing a relationship_id)
[im_ticket_ticket_rel__delete] integer integer, integer Destructor (providing two ticket_id's)
[im_ticket_ticket_rel__new] integer integer, varchar, integer, integer, integer, integer, varchar, integer Constructor

Please take a moment to complete this form to help us improve our service.

Note:
Please only provide feedback in regards to content this page shows. For support inquiries please refer either to the Community Support forum at Sourceforge or check out our 'Professional Support'

Did this page help you to achieve your goal?

 Yes  No  Don't know

Please provide us with comments to improve this page:

How useful is the information?

 1  2  3  4  5
Not
useful
      Extremely
useful
 
  

Explore

Installers
Demo Server
Modules & Functionality
Packages
Business Processes supported
FAQ's

Help

Getting started
User Manuals
Configuration Manuals
Community Support
Professional Support

News

News
Twitter
RSS Community / Sourceforge
Register for Newsletter

Get in touch

Contact
Register



Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 2.0 Generic License - Privacy Policy