• Display TS_ID and TS_UUID in Reports

    Hello! Is there a way to display TS_ID and TS_UUID fields on the SBM UI using the reports? Thanks!
  • How do you change the start date time hour of the day?

    Hi, I'm using SBM 11.4.1 and I have a simple report that suppose to return a list from the advance query below: ("My Start Date" >= Startof_today) and ("My Start Date" Let say today is 13 May 2019, and i created 1 item, and by changing the [My…
  • Can workcenter views and feeds be embedded into other tools?

    Has any one managed to embed workcenter report, views or feeds into other tools or websites? I have managed to do it using iframes and the classic UI URL's. However this obviously rules out any of the newer views and feeds plus the classic UI is on…
  • Reports are taking too long to fetch results in workcenter

    I have a project as "IT Work management" and this projects have two applications as "Work Requests" and "Project Requests" I am creating a listing reports in work center with one application "Work requests" is selected as Report Project. I have used…
  • How to add fields to Built in Reports ?

    Hello Team, could you please help on below issue. When we use the "search" or "Advane search" in search result we are getting only two fields, we want to add more fields like submitted date, submitter etc.. How to add more fields to search result…
  • Is there no such thing as an Items Closed per Month SBM report?

    I created an Items Submitted per Month. Submittal is a built-in option that can be selected in a Duration report. However, I don't see any way of creating an Items Closed per Month report.
  • Scheduled reports does not export all records.

    I am using SBM 11.0.1. I have some scheduled reports which are having more than 5000 records and sending them to email as excel format. The report executed properly and sent email. But that excel does not contain all records. Only first 1000 records…
  • Report that accumulates values?

    I'd like to create an SBM report that shows the cumulative count of issues in a particular state. One example is the "Cumulative Flow Diagram" shown here: brodzinski.com/.../cumulative-flow-diagram.html The X axis is time, the Y axis is the number…
  • How to terminate a report query if the report is cancelled

    I was recently working on a report against several primary tables that have about 1.8 million records. Several iterations of the report would take many minutes to return. That wouldn't work for our clients so I would hit F5 (browser refresh) to cancel…
  • Reporting on which transition was used to reach a completed state?

    Example: Both the "Yes" and "No" transitions both go into the Completed state. I would like to be able to differentiate how each records got to the completed state. Is there a way to do this? I though about creating a field called "Closed by Transition…
  • Filter by a list of comma separated IDs

    Hello, is it possible to filter a Report by a list of comma separated ID's (ISSUEID)? Righ now, I just can filter by the content of the ID, and that return only the Items that contain that string in its ID. For example, if I filter by '001015' the…
  • new calculation date format

    When creating a 'Calculation Column' in a SBM report using dates, when the calculation is added to the report's output, I would like to remove the time portion of the calculation and display only the resulting days.
  • Customise Date format displayed in a report to exclude Time part

    Hi, Maybe I'm missing something simple but I can't figure out a way to do this. One of our users has asked if it is possible to exclude the Time part of certain Date/Time fields in their reports? The fields in Composer are set to store the Date…
  • Report SBM (input / output)

    Hi all, I've been looking for this in sbm manuals, but still can't find it. I need to create I think a report, so that a user can fill 3 or 4 fields, and thru that fields it will generate the report. Example: I have 10 fields, field1, field2, etc... So…
  • How can I run a report showing all the items that are in a specific state for more than 5 days

    I would like to know how create a report to show all active items that are in a specific state (Waiting For Mgmt Approval) for more than 5 days. Our primary table name is IT_RISK. We are in SBM R2 and Oracle 10g.