]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
  Contact Us
  Project Open Business Solutions S.L.

Calle Aprestadora 19, 12o-2a

E-08907 Hospitalet de Llobregat (Barcelona)

 Tel Europe: +34 932 202 088
 Tel US: +1 415 429 5995
 Mail: info@project-open.com