Inconsistent data in reports built using ReportBuilder

Hi Arne -

The report I am seeing issues in queries for a list of work items with a certain field set -

the work item is new work item we created for our project [Change Request report type]
the field we query for is a date field [called Planned Deployment Date]

The report lists the Change Requests with Planned Deployment Date set, grouping the Change Requests based on date/time. We see that the Status attribute [using default RTC Status attribute for the WI] is incorrect - even when the report is initially opened. We have seen CRs where the status has been modified over 3 hours ago showing up incorrectly when the report is just opened.

The Report is built using Report Builder.

Best Regards,
Elaine.

Hi Elaine,

please cp. my answer and comment in: https://jazz.net/forum/questions/244235/why-dont-i-see-newly-entered-requirements-into-dng-when-immediately-generating-a-report-using-jazz-reporting

Basically in JRS the report builder will use either Data Warehouse or LQE as its data source. Depending on the tables you can run a report against Data Warehouse that fetches life data from the repository but most reports run against tables where the DCC pushes data in frequently (e.g. every hour or so). In LQE the cycles are typically faster and data is synched to the index every 60 seconds or so.

It pretty much depends on the exact report and data source. Can you share some more details?

- Arne

Report Builder reports are not built using live data directly from RTC.  They will be using either the data warehouse or LQE as the data source.  The data warehouse data will be refreshed likely by DCC jobs  (or depending on your version of RTC, possibly the older ETL's).  You will want to check with your administrator to see how often the data is refreshed in your warehouse.