#idempiere IRC log for Friday, 2018-02-09

*** silphium has joined #idempiere00:10
*** silphium has quit IRC06:10
*** pradeep_ has joined #idempiere06:24
*** pradeep_ has left #idempiere06:26
*** lakshmanan has joined #idempiere06:29
*** a42niem has joined #idempiere07:35
*** nmicoud has joined #idempiere07:43
*** nmicoud has left #idempiere08:38
*** nmicoud has joined #idempiere08:39
*** CarlosRuiz has joined #idempiere09:09
*** a42niem has quit IRC09:12
*** a42niem has joined #idempiere09:36
*** Junior has quit IRC12:22
Not-ff68[IDEMPIERE] hieplq updated IDEMPIERE-361714:33
Not-ff68[IDEMPIERE] hi [~ViniMoraes], you miss "!important;" please look my example {code:css} .docstatus-draft, .docstatus-draft input { background-color: yellow!important; } {code}14:33
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-361714:33
*** psnebc has joined #idempiere14:56
psnebchello, question what is the next stable release (LTS) for iDempiere ( coming out next time )14:57
nmicoud(hi)  Probably v6.1 on 31 october15:00
psnebc@ nmicoud good info thanks15:01
*** psnebc has quit IRC15:02
*** nmicoud has quit IRC16:53
*** aguerra has quit IRC18:07
*** aguerra has joined #idempiere18:20
*** aguerra has quit IRC18:26
*** aguerra has joined #idempiere18:40
*** aguerra has quit IRC18:44
*** aguerra has joined #idempiere18:48
*** aguerra has quit IRC19:02
*** aguerra has joined #idempiere19:37
*** aguerra has quit IRC19:42
*** Junior has joined #idempiere19:48
*** aguerra has joined #idempiere19:57
*** aguerra has quit IRC19:59
*** Junior has quit IRC20:30
Not-ff68[iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-5.1 [+0/-0/±4] https://bitbucket.org/idempiere/idempiere/commits/21:10
Not-ff68[iDempiere] globalqss 84506fc - IDEMPIERE-3635 Cache getLookupInfo method to avoid multiple queries execution21:10
Not-ff68[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3635 status set to "Resolved" -resolution set to "Fixed"21:13
Not-ff68[IDEMPIERE] Hi [~pritesh.shah17], I solved the issue in a different way using the actual caches from column and valrule. I also noticed and fixed non-cached queries on GridTab.setLinkColumnName, MLookupFactory.getListIdentifiers and WEditorPopupMenu Regards, Carlos Ruiz21:13
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363521:13
Not-ff68[IDEMPIERE] pritesh.shah17 updated IDEMPIERE-363521:15
Not-ff68[IDEMPIERE] Perfect, thank you!21:15
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363521:15
Not-ff68[iDempiere5.1] jenkins built #78 completed (success) http://ci.idempiere.org/job/iDempiere5.1/78/21:30
Not-ff68[IDEMPIERE] pritesh.shah17 created IDEMPIERE-3636 Add AD_PInstance_ID in update T_InventoryValue where clause in InventoryValue21:31
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363621:31
Not-ff68[IDEMPIERE] pritesh.shah17 updated IDEMPIERE-3636 description set to "With huge data below query is performing slow, though we are cleaning up temporary table periodically. {code:java} sql = new StringBuilder ("UPDATE T_InventoryValue iv ") .append("SET (Cost, M_CostElement_ID)=") .append("(SELECT c.CurrentCostPrice, c.M_CostElement_ID ") .append("FROM M_Warehouse w") .append(" INNER JOIN AD_ClientInfo ci ON21:32
Not-ff68(w.AD_Client_ID=ci.AD_Client_ID)") .append(" INNER JOIN C_AcctSchema acs ON (ci.C_AcctSchema1_ID=acs.C_AcctSchema_ID)") .append(" INNER JOIN M_Cost c ON (acs.C_AcctSchema_ID=c.C_AcctSchema_ID") .append(" AND acs.M_CostType_ID=c.M_CostType_ID AND c.AD_Org_ID IN (0, w.AD_Org_ID)) ") .append("WHERE c.M_CostElement_ID=").append(p_M_CostElement_ID) .append(" AND iv.M_Warehouse_ID=w.M_Warehouse_ID") .append(" AND21:32
Not-ff68iv.M_Product_ID=c.M_Product_ID") .append(" AND iv.M_AttributeSetInstance_ID=c.M_AttributeSetInstance_ID) ") .append("WHERE EXISTS (SELECT * FROM T_InventoryValue ivv ") .append("WHERE ivv.AD_PInstance_ID=").append(getAD_PInstance_ID()) .append(" AND ivv.M_CostElement_ID IS NULL)"); {code} To improve performance, minor change required is as below between the * * {code:java} sql = new StringBuilder ("UPDATE21:32
Not-ff68T_InventoryValue iv ") .append("SET (Cost, M_CostElement_ID)=") .append("(SELECT c.CurrentCostPrice, c.M_CostElement_ID ") .append("FROM M_Warehouse w") .append(" INNER JOIN AD_ClientInfo ci ON (w.AD_Client_ID=ci.AD_Client_ID)") .append(" INNER JOIN C_AcctSchema acs ON (ci.C_AcctSchema1_ID=acs.C_AcctSchema_ID)") .append(" INNER JOIN M_Cost c ON (acs.C_AcctSchema_ID=c.C_AcctSchema_ID") .append(" AND21:32
Not-ff68acs.M_CostType_ID=c.M_CostType_ID AND c.AD_Org_ID IN (0, w.AD_Org_ID)) ") .append("WHERE c.M_CostElement_ID=").append(p_M_CostElement_ID) .append(" AND iv.M_Warehouse_ID=w.M_Warehouse_ID") .append(" AND iv.M_Product_ID=c.M_Product_ID") .append(" AND iv.M_AttributeSetInstance_ID=c.M_AttributeSetInstance_ID) ") * .append(" AND iv.AD_PInstance_ID=").append(getAD_PInstance_ID())* .append("WHERE EXISTS (SELECT * FROM21:32
Not-ff68T_InventoryValue ivv ") .append("WHERE ivv.AD_PInstance_ID=").append(getAD_PInstance_ID()) .append(" AND ivv.M_CostElement_ID IS NULL)"); {code} "21:32
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363621:32
Not-ff68[IDEMPIERE] pritesh.shah17 updated IDEMPIERE-3636 status set to "Peer Review Queue"21:32
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363621:32
Not-ff68[IDEMPIERE] carlosruiz_globalqss created IDEMPIERE-3637 Invoice vendor re-price is not recalculating taxes22:20
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363722:20
Not-ff68[iDempiere] CarlosRuiz_globalqss pushed 1 commit to release-5.1 [+0/-0/±2] https://bitbucket.org/idempiere/idempiere/commits/22:20
Not-ff68[iDempiere] globalqss 88dd549 - IDEMPIERE-3637 Invoice vendor re-price is not recalculating taxes22:20
Not-ff68[IDEMPIERE] carlosruiz_globalqss updated IDEMPIERE-3637 status set to "Resolved" -assignee set to "Carlos Ruiz" -resolution set to "Fixed"22:21
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363722:21
Not-ff68[iDempiere5.1] jenkins built #79 completed (success) http://ci.idempiere.org/job/iDempiere5.1/79/22:26
*** CarlosRuiz has quit IRC23:14

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!