The following PL/SQL API functions are related to the ]po[ helpdesk and ITSM functionality.
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 |
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 |
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 |
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 |
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 |
Calle Aprestadora 19, 12o-2a
08902 Hospitalet de Llobregat (Barcelona)
Spain
Tel Europe: +34 609 953 751
Tel US: +1 415 200 2465
Mail: info@project-open.com