Why Refresh data in GridView ???

(0) Share

Report

Posted on by ismaelivan

578

The gridview is populated from a query, but when is open is updated several times, too when you slide the bar or step on a line, the data is updated. Is there any way to avoid this?

Thank very much!

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Suggested answer

Ajit 8,788 on at

Like (0)

Report
Copy link

Link copied!

And in addition to what Sukrut mentioned, Are you using multiple display methods in that form.

Was this reply helpful? Yes No
Suggested answer

Israel Gonzalez 746 on at

Like (0)

Report
Copy link

Link copied!

Hi Ismael, I think the problem is the query. Can you show a screenshot about that?

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

Son varios métodos (12)

Are methods with a query simple

example

display SalesId obtieneOV(InventSum _InventSum)

{

SalesLine sLine;

select firstOnly SalesId from sLine where sLine.InventRefId == this.inventBatchId;
return sLine.SalesId;
}

Was this reply helpful? Yes No
ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

This the only large query...

display TransDate GetDateSum(InventSum _inventSum)

{

TransDate fecha, fecha1;

InventTrans invTrans;

InventTransOrigin invOrigin;

InventDim invDim;

str sPallet, sItemId;

;

sPallet = _inventSum.wmsPalletId();

select minOf(DatePhysical)

from invTrans

join invDim

join invOrigin

where _inventSum.ItemId == invTrans.ItemId &&

invTrans.InventTransOrigin == invOrigin.RecId &&

invDim.inventDimId == invTrans.InventDimId &&

(invTrans.StatusReceipt == StatusReceipt::Purchased ||

invTrans.StatusReceipt == StatusReceipt::Received ||

invTrans.StatusReceipt == StatusReceipt::Registered) &&

invDim.wMSPalletId == _inventSum.wmsPalletId() &&

(invOrigin.ReferenceCategory == InventTransType::InventTransaction ||

invOrigin.ReferenceCategory == InventTransType::Purch ||

invOrigin.ReferenceCategory == InventTransType::InventLossProfit ||

invOrigin.ReferenceCategory == InventTransType::InventTransfer ||

invOrigin.ReferenceCategory == InventTransType::InventCounting||

invOrigin.ReferenceCategory == InventTransType::ProdLine ||

invOrigin.ReferenceCategory == InventTransType::QuarantineOrder ||

invOrigin.ReferenceCategory == InventTransType::Production )

;

return invTrans.DatePhysical;

}

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I couldn't find field inventBatchId on InventSum datasource.Could you please move this method obtieneOV to the datasource InventDim.

Was this reply helpful? Yes No
Suggested answer

Chaitanya Golla 17,225 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Could you let us know where this display method is residing. If its on the form, please move it to the table InventTrans and cache it on the init method of InventTrans datasource. Also I feel this query can be optimized by reducing the number of joins and introducing fieldlist(like selecting only RecId from tables invDim and invOrigin).

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
Copy link

Link copied!

Your problem is definitely with the display methods. I would like to highlight some of the issues:

1) You are overusing them. You seem to use a lot of display methods which will hog performance.

2) You most likely do not use caching of display methods, from which you could gain enormous performance boost. Read all the relevant posts:

msdn.microsoft.com/.../aa596691.aspx

http://daxture.blogspot.com/2015/05/cache-display-methods-in-ax-2012.html

kashperuk.blogspot.hu/.../tutorial-caching-display-methods.html

3) Based on the above pasted code you are doing inner joins without using the fields for the joined tables after the select statement, so they should be just exists joins since the query criteria does not count (for that you do not have to make it inner joins to fetch the records...).

Was this reply helpful? Yes No
Verified answer

ismaelivan 578 on at

Like (0)

Report
Copy link

Link copied!

I apply the article daxture.blogspot.mx/.../cache-display-methods-in-ax-2012.html

Thank Very much, works more fast!

Was this reply helpful? Yes No