It's all about the answers!

Ask a question

How To Grab Data based on User Local

Richard Kissel (30617) | asked Jan 18 '18, 8:08 p.m.
edited Jun 25 '18, 8:39 a.m. by Muralidhar Rajagopal (10114)

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.

Fariz Saracevic commented Jan 19 '18, 4:16 a.m.

Hi Richard,

Could you let us know if you are using DW or LQE? If you are using DW, data are not update in DW immediately. Usually, it takes between 12 - 24 hours depending what DW update frequency your administrator has setup. LQE gives you near realtime data but then you need to enableme configuration management.

I suggest to take a look at the decision tree when to use DW vs LQE

Richard Kissel commented 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 commented 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.

Be the first one to answer this question!

Register or to post your answer.