This LiveReport page determines all Orphan Links. An Orphan Link is a link to an already deleted Work Item.
If the linked Work Item is not checked for unresolvable in code (Java, JavaScript, Velocity) it may lead to errors when rendering Wiki/LifeReport pages.
Additionally, it may affect the usability if users don't why they can get Orphan Links.
The extension provides the following sample implementations:
- How you get the Orphan Links with an SQL-Query
- How to open the Work Item Sidebar from within a LiveReport page
- How to integrate sorting and filtering for a Work Item Table without refreshing the page
- How to make changes from a LiveReport page
- How to check if a specific Widget is available
This extension is not only meant to be downloaded and used as is but it can also be used as a blueprint for more effective usability when rendering data in Polarion.
seabay-it.net is specialized in such use cases. Visit our WebSite or send an email to info@seabay-it.net for more information. For any questions related to this extension write to support@seabay-it.net with the subject "Orphan Links Extension".
How to get the Orphan Links with an SQL-Query
SQL queries in Polarion are very helpful when you get the data from one query instead of walking through the whole list of Work Items executing several other methods. In our case, if you don't use SQL, you would need to get all Work Items and check if all the linked Work Items exist. This may take a long time in the bigger repositories. The extension shows you how to get the information from one table.
How to open the Work Item Sidebar from within a LiveReport page
Although it is documented in the Rendering SDK guide we receive many questions from Polarion users on how to show the Work Item sidebar. In the LiveReport page, we show how to do it without calling the API methods - just by providing specific HTML attributes when rendering a table. It even works with tags when to don't want to render a table.
How to integrate sorting and filtering for a Work Item Table without refreshing the page
Polarion users are often asking for responsive data rendering with sorting and filtering on a LiveReport page (not the Work Item Table view). A solution is using a JavaScript library to do the work. We have good experience with an open-source JavaScript library called DataTable. It is widely used and provides a great API. The LiveReport page of the extension gets the necessary libraries directly from the DataTable's home page. If your Polarion server does not have access to the internet you can download the libraries to your installation and adapt the #loadJS() macros accordingly to use them locally.
For the use case of accessing the data from Polarion dynamically using Ajax - just get in touch with us and we can provide some useful examples.
How to make changes from a LiveReport page
Whenever it is needed to change data directly from a LiveReport page the only way to achieve it is to implement an active java widget that gets data from a specific attribute on the LiveReport page. This extension delivers an implementation of this use case.
How to check if a specific Widget is available
In the Page Parameters section, you can select a Project and a list of fields to be displayed. After the parameters are entered, a list of Work Items is shown which checks if the Seabay Orphan Links Extension is installed and you will see a button to start the removal of the Orphan Links from the selected Work Items.