#idempiere IRC log for Thursday, 2018-02-08

*** a42niem has joined #idempiere06:52
*** nmicoud has joined #idempiere07:39
*** silphium has quit IRC07:51
*** nmicoud has quit IRC08:09
*** nmicoud has joined #idempiere08:09
*** CarlosRuiz has joined #idempiere09:14
Not-ff68[IDEMPIERE] ViniMoraes updated IDEMPIERE-361711:52
Not-ff68[IDEMPIERE] hi @Carlos Ruiz , can you explain how you made it work? i added this style in my theme.css.dsp {code:css} .my-style, .my-style input { background-color: #C5E1A5; } {code} and I created a css style with a style line with inline style value equals: @sclass=my-style but didn't work. I have also tried with !important, and I got the same result11:52
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-361711:52
aguerraHello every body13:41
*** CarlosRuiz has quit IRC16:00
*** CarlosRuiz has joined #idempiere16:18
*** nmicoud has quit IRC16:46
*** CarlosRuiz has quit IRC18:38
*** silphium has joined #idempiere19:12
Not-ff68[IDEMPIERE] david.podhola updated IDEMPIERE-361820:52
Not-ff68[IDEMPIERE] Sorry, it should probably not be into the PEER REVIEW, it was probably my bug done on my phone. I also know already to how to push it to the production :-)20:52
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-361820:52
*** ChanServ has quit IRC20:57
*** ChanServ has joined #idempiere21:31
*** moon.freenode.net sets mode: +o ChanServ21:31
*** a42niem has quit IRC23:37
Not-ff68[IDEMPIERE] pritesh.shah17 created IDEMPIERE-3635 Cache getLookupInfo method to avoid multiple queries execution23:40
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363523:40
Not-ff68[IDEMPIERE] pritesh.shah17 updated IDEMPIERE-3635 Attachment set to "MLookupDto.java"23:40
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363523:40
Not-ff68[IDEMPIERE] pritesh.shah17 updated IDEMPIERE-3635 description set to "{code:java} MLookupFactory.getLookupInfo(Properties ctx, int WindowNo, int TabNo, int Column_ID, int AD_Reference_ID) {code} executes {code:java} "SELECT c.ColumnName, c.AD_Reference_Value_ID, c.IsParent, vr.Code " + "FROM AD_Column c" + " LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) " + "WHERE c.AD_Column_ID=?" {code}23:50
Not-ff68everytime. I believe for each column_id retrieved values would remain same. Can we cache them? I am using older version of idempiere, so could not create patch, however is the code sample for caching and attached is the DTO class. *MLookupFactory.java* {code:java} private static CCache<Integer, MLookupDto> s_cacheRefLookup = new CCache<Integer, MLookupDto>("MLookupDto", 30, 60); // 1h {code} {code:java} public static23:50
Not-ff68MLookupInfo getLookupInfo(Properties ctx, int WindowNo, int TabNo, int Column_ID, int AD_Reference_ID) { String ColumnName = ""; int AD_Reference_Value_ID = 0; boolean IsParent = false; String ValidationCode = ""; // MLookupDto mLookupDto = s_cacheRefLookup.get(Column_ID); if(mLookupDto!=null){ return getLookupInfo(ctx, WindowNo, TabNo, Column_ID, AD_Reference_ID, Env.getLanguage(ctx), mLookupDto.getColumnName(),23:50
Not-ff68mLookupDto.getAD_Reference_Value_ID(), mLookupDto.isParent(), mLookupDto.getCode()); } String sql = "SELECT c.ColumnName, c.AD_Reference_Value_ID, c.IsParent, vr.Code " + "FROM AD_Column c" + " LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) " + "WHERE c.AD_Column_ID=?"; PreparedStatement pstmt = null; ResultSet rs = null; try { pstmt = DB.prepareStatement(sql, null); pstmt.setInt(1,23:50
Not-ff68Column_ID); // rs = pstmt.executeQuery(); if (rs.next()) { ColumnName = rs.getString(1); AD_Reference_Value_ID = rs.getInt(2); IsParent = "Y".equals(rs.getString(3)); ValidationCode = rs.getString(4); } else { s_log.log(Level.SEVERE, "Column Not Found - AD_Column_ID=" + Column_ID); } } catch (SQLException ex) { s_log.log(Level.SEVERE, "create", ex); } finally { DB.close(rs, pstmt); rs = null; pstmt = null; }23:50
Not-ff68mLookupDto = new MLookupDto(ColumnName, AD_Reference_Value_ID, IsParent, ValidationCode); s_cacheRefLookup.put(Column_ID, mLookupDto); MLookupInfo info = getLookupInfo(ctx, WindowNo, TabNo, Column_ID, AD_Reference_ID, Env.getLanguage(ctx), ColumnName, AD_Reference_Value_ID, IsParent, ValidationCode); return info; } {code} "23:50
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363523:50
Not-ff68[IDEMPIERE] pritesh.shah17 updated IDEMPIERE-3635 status set to "Peer Review Queue"23:50
Not-ff68[IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-363523:50
*** silphium has quit IRC23:52

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