The power of OData and the ease with which you can interrogate your data and draw out insights from it makes the new API a game-changer when it comes to enterprise reporting with SpiraPlan. For instance, you can turn the data results into a pivot table to tell you how many open bugs and enhancements there are, in total, in each portfolio. The OData query API allows you to do anything with the data you want.
Joining different views/tables of data together.In addition to this simple example you can use OData to perform common query needs: With OData we can join these together to get a merged set of data: The main query is Incidents, and the secondary query is IncidentStatuses. For example, imagine for each incident that we want to get extra information about its status. If we want to connect them together, we can use OData's query capabilities. In this example, we might have two different queries that are completely independent from each other. In addition to loading entire views, the OData protocol allows dynamic querying of the live data source: With this approach, you can connect Excel and Spira together using OData and view data from Spira live in Excel. If you choose the option to load the data, you will see the following: Transform Data: this puts the data into Excel's Power Query so that you can manipulate the data that Spira sends to Excel.Load: this loads the whole view, with all records, into a new Excel sheet in the current workbook.To see all the data you have two options: You can access pretty much all the information in your application, across all its products and templates, from these views: There is a lot here and a lot to explore. Once Excel connects to SpiraPln you see a popup "Navigator" where you can see all the different data views you can access ("query"). In this article we will be using Excel to illustrate how you can use OData, but in reality you can use any reporting tool that supports OData, for example Microsoft PowerBI.Įxcel comes with a built-in Power Query tool that can connect to OData APIs such as SpiraPlan 6.9: the top 5 most closed then reopened bugs in a product (or program)Ĭonnecting Excel to SpiraPlan using OData.get the most recent test run for each test case against each requirement assigned to a sprint.a list of how long ago each open task was assigned to the current owner.a pie chart of how many users are members of each of SpiraPlan's products.What sort of insights can you get with OData and SpiraPlan reporting views? Here are some examples: If you can fiddle with a spreadsheet, you can stich tables of data from SpiraPlan ("joins" in database language) to get just the data you need. With OData you don't need to be a SQL expert to generate rich and dynamic insights into your data. Tools like Excel, PowerBI, Tableau support OData and can therefore communicate with SpiraPlan to access this data with just a few clicks. Whenever you use OData in SpiraPlan you are communicating through a secure intermediary (the application itself) to get data from read-only reporting views. Exclusive to SpiraPlan (6.9+), with OData you can directly query the raw data in your database in a secure and safe way. For further information, please see our shipping page by clicking here.OData is an open protocol that lets you easily query data, over the web. Please Note: International Shipping costs can vary depending on the weight/size of the item and your location. Please Note: 1) International Shipping costs can vary depending on the weight/size of the item and your location and 2) Shipping Framed Extra Large (A1 Size Posters) Internationally is not available at this time. If you wish, you can have your Posters sent Express Delivery at a small additional charge. Framed Posters are flat packed with multiple layers of padding to ensure that your package arrives in perfect condition. Unframed Posters are sent rolled in a sturdy mailing tube to protect them from creasing. According to Australia Post, orders from the USA, Canada, New Zealand and Europe can take up to 25 working days to arrive (from the date posted).
Delivery takes approximately 2/9 working days (from the date posted). All Orders will be sent with an Australia Post Tracking Number.
All Posters ordered over the weekend/public holiday will usually be shipped within the following 3 business days. We Ship Worldwide within 72 Hours (excluding weekends and public holidays).
0 kommentar(er)
