Find Answers

Filter Search Results
All Operating Systems:
All Products:

All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
CMS-XML SBM 11+: Creating Query Views for Advanced Reports (SBM Advanced XML Report)
SBM 11+: Creating Query Views for Advanced Reports (SBM Advanced XML Report )
CMS-XML 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
CMS-XML 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()
CMS-XML Advanced SQL report to list issues that have attachments
Build Number(s): 5029 and higher How do I report on issues that have attachments?
CMS-XML Advanced SQL report to show items owned by Deleted users
Build Number(s): 5.0 and higher How do I report on deleted users?
CMS-XML 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.
CMS-XML 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].
CMS-XML 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.
CMS-XML 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.
CMS-XML 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:
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Additional Assistance

  • Submit a Case Online
  • FAQs