How To Grab Data based on User Local
So when a user goes into say "RQM > Test Case Results" and builds a Query to show them all the Test Cases completed today they get a list of all their tests. However, if the user goes into Report builder to develop the same report then the Quantity of the tests that are displayed is different.
The Server hosting the JRS is running In UTC server time. The users could be in any time Zone. How do the develop a JRS Report Builder report that will show them all the test they have run today (their Time Zone) when all the Report builder knows is UTC and the Tester (say in Pacific Time) runs test through out the day. The test run but are logged with UTC time, so when trying to get the data in a report it only takes in count UTC time as the day and not the users local time.
How do we get Report Builder to recognize that user in a Time Zone need to report on todays events, so when they build a report and select the "Today" option it will actually show them the items based upon today in their local Time Zone.
Comments
Fariz Saracevic
FORUM MODERATOR / JAZZ DEVELOPER Jan 19 '18, 4:16 a.m.Hi Richard,
Richard Kissel
Jan 22 '18, 1:51 p.m.We have both DW & LQE as data sources. LQE is based upon the ODS Data Collection which runs every hour and DW is based upon the Data-Mart Data Collection which is nightly. We have tried both Data sources.
Richard Kissel
Jan 22 '18, 1:51 p.m.However that still does not resolve the issue that the collection of the data is put into the DB based upon the server time which is in UTC. So when the user in PST (-8) goes and creates a report and expects to see only today results they only get the results of today based upon UTC time.
In the tool they saw 31 items which was correct (tool changes everything into Local user time) but when they create a report similar in report builder then they saw 34 items because three items from the day before where include because based upon server time they were done the next day.