on 06-06-2008 2:47 PM
Good morning all,
We have a simple query that shows current month's on hand quantity that greater than 0. We use one variable that return current month/year, and another condition which return on hand quantity > 0.
When we transported this query from DEV to PROD, it displayed correct data. But when we execute it agian on the second day, we still got yesterday's data.
We tried to save this query to a new one, and transported to PROD; it worked agian. But next day same thing happened! Query result did not get refreshed.
Does anyone know why is it? Any solutions? Thanks a lot in advance!
in your QA/Prod system, are you laoding the data every day. There a chance that either data is not loaded daily or even if data is being loaded daily, there is no new data.
Please check and see the result again.
Thanks..
Shambhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If the data is getting updated daily in the DSO, then your query must get the latest data. Try to close the query and reopen it once again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.