cancel
Showing results for 
Search instead for 
Did you mean: 

Query results did not get freshed

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi, Shambhu:

We do load it daily. We compared the query data with DSO data, they are not match. The new query we just created mathced with Production data.

Answers (1)

Answers (1)

Former Member
0 Kudos

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.