| |
Results |
|
SBM 11+: Creating Query Views for Advanced Reports (SBM Advanced XML Report)
|
SBM 11+: Creating Query Views for Advanced Reports (SBM Advanced XML Report )
|
|
|
|
Dim CM: How to create a simple user defined report (RUR) for advanced reporting capabilities
|
Dim CM: How to create a simple user defined report (RUR) for advanced reporting capabilities
|
|
|
|
Advanced SQL for report filter for dates prior to today
|
Example of Advanced SQL for SQL Server for a filter on a date field that is the last 60 days: @ where TS_SUBMITDATE between getdate()-60 and getdate()
|
|
|
|
Advanced SQL report to list issues that have attachments
|
Build Number(s): 5029 and higher How do I report on issues that have attachments?
|
|
|
|
Advanced SQL report to show items owned by Deleted users
|
Build Number(s): 5.0 and higher How do I report on deleted users?
|
|
|
|
RLC: How to get a list of all active Manual Tasks and their related Release Package (SBM Advanced XML Report)
|
Out of the box, you cannot build a report that shows information about the Manual Tasks and also information about the related Release Packages. However, you can use the SBM Advanced XML Report feature to create a special report.
|
|
|
|
SBM Advanced XML Report: Every row says "[Deleted Field]" in the data rows of the report
|
NOTE: This document only applies to reports that were created by using the SBM Advanced XML Reporting feature described in KB S141342 . When creating/updating a new XML report (which could take several attempts to get right), some fields may suddenly change, and the data in each row of the report will say [Deleted Field].
|
|
|
|
How to query for Null values in Sub Relational Fields using Advanced SQL option in Reports.
|
@where XXX_PRIMARYTABLENAME.TS_SINGLERELATIONALFIELD in (select TS_ID from XXX_AUXTABLENAME where TS_SUBRELTARGET is null) XXX_PRIMARYTABLENAME = The name of the Primary Table you are reporting on where the Sub Relational Field was added. TS_SINGLERELATIONALFIELD = The name of the Relational Field where the Sub Relational Field points to.
|
|
|
|
RLC: How to get a list of Requests that are attached to a Release Package (SBM Advanced XML Report)
|
In Release Control, you can attach business requests, development requests, and other requests to a Release Package. The requests could come from SBM, Dimensions, and any number of other sources. However, when building any kind of report , you do not have access to the information on the Requests tab. This document will help to setup a report that will give access to the information on the Request tab.
|
|
|
|
SBM Advanced XML Report: Every row says "(None)" and drill down shows the message "CField::Html encountered an unhandled field named MY_LINKED_ITEMS." (Multi-relational field)
|
If the report contains a multi-relational field, every row in the report may return "(None)" for the value. Also, when you click a row and open the drill down details for that item, the value will display as:
|
|
|
