*** silphium has joined #idempiere | 00:10 | |
*** silphium has quit IRC | 06:10 | |
*** pradeep_ has joined #idempiere | 06:24 | |
*** pradeep_ has left #idempiere | 06:26 | |
*** lakshmanan has joined #idempiere | 06:29 | |
*** a42niem has joined #idempiere | 07:35 | |
*** nmicoud has joined #idempiere | 07:43 | |
*** nmicoud has left #idempiere | 08:38 | |
*** nmicoud has joined #idempiere | 08:39 | |
*** CarlosRuiz has joined #idempiere | 09:09 | |
*** a42niem has quit IRC | 09:12 | |
*** a42niem has joined #idempiere | 09:36 | |
*** Junior has quit IRC | 12:22 | |
Not-ff68 | [IDEMPIERE] hieplq updated IDEMPIERE-3617 | 14: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-3617 | 14:33 |
*** psnebc has joined #idempiere | 14:56 | |
psnebc | hello, question what is the next stable release (LTS) for iDempiere ( coming out next time ) | 14:57 |
nmicoud | (hi) Probably v6.1 on 31 october | 15:00 |
psnebc | @ nmicoud good info thanks | 15:01 |
*** psnebc has quit IRC | 15:02 | |
*** nmicoud has quit IRC | 16:53 | |
*** aguerra has quit IRC | 18:07 | |
*** aguerra has joined #idempiere | 18:20 | |
*** aguerra has quit IRC | 18:26 | |
*** aguerra has joined #idempiere | 18:40 | |
*** aguerra has quit IRC | 18:44 | |
*** aguerra has joined #idempiere | 18:48 | |
*** aguerra has quit IRC | 19:02 | |
*** aguerra has joined #idempiere | 19:37 | |
*** aguerra has quit IRC | 19:42 | |
*** Junior has joined #idempiere | 19:48 | |
*** aguerra has joined #idempiere | 19:57 | |
*** aguerra has quit IRC | 19:59 | |
*** Junior has quit IRC | 20: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 execution | 21: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 Ruiz | 21:13 |
Not-ff68 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3635 | 21:13 |
Not-ff68 | [IDEMPIERE] pritesh.shah17 updated IDEMPIERE-3635 | 21:15 |
Not-ff68 | [IDEMPIERE] Perfect, thank you! | 21:15 |
Not-ff68 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3635 | 21: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 InventoryValue | 21:31 |
Not-ff68 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3636 | 21: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 ON | 21: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(" AND | 21:32 |
Not-ff68 | iv.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 ("UPDATE | 21:32 |
Not-ff68 | 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 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(" AND | 21:32 |
Not-ff68 | 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(" 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 * FROM | 21:32 |
Not-ff68 | T_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-3636 | 21: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-3636 | 21:32 |
Not-ff68 | [IDEMPIERE] carlosruiz_globalqss created IDEMPIERE-3637 Invoice vendor re-price is not recalculating taxes | 22:20 |
Not-ff68 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3637 | 22: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 taxes | 22: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-3637 | 22:21 |
Not-ff68 | [iDempiere5.1] jenkins built #79 completed (success) http://ci.idempiere.org/job/iDempiere5.1/79/ | 22:26 |
*** CarlosRuiz has quit IRC | 23:14 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!