| *** CarlosRuiz has quit IRC | 00:20 | |
| *** aguerra has quit IRC | 00:35 | |
| Not-7634 | [iDempiere] jenkins built #1816 completed (failure) http://ci.idempiere.org/job/iDempiere/1816/ | 02:57 |
|---|---|---|
| *** a42niem has joined #idempiere | 05:19 | |
| *** jdpaniagua has quit IRC | 07:15 | |
| *** jdpaniagua has joined #idempiere | 07:21 | |
| *** tbayen has joined #idempiere | 07:51 | |
| Not-7634 | [IDEMPIERE] hieplq created IDEMPIERE-3222 infowindow create a wrong column class for EntityType column | 09:12 |
| Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3222 | 09:12 |
| Not-7634 | [IDEMPIERE] hieplq updated IDEMPIERE-2989 Attachment set to "None" | 09:28 |
| Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2989 | 09:28 |
| Not-7634 | [IDEMPIERE] hieplq updated IDEMPIERE-2989 status set to "Open" | 09:28 |
| Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2989 | 09:28 |
| Not-7634 | [IDEMPIERE] hieplq updated IDEMPIERE-2989 description set to "WListbox.prepareTable have some issue with where clause {code:java} public String prepareTable(ColumnInfo[] layout, String from, String where, boolean multiSelection, String tableName,boolean addAccessSQL) {code} 1. if we call WListbox.prepareTable with where = null, offcouse we have issue, because sql.append(" WHERE ").append(where); make " WHERE null" 2. | 09:50 |
| Not-7634 | if we call WListbox.prepareTable with where = "" and addAccessSQL = true we get exception detail at "block 1" reason: 1. sql query have form "select ... from ... where " 2. at class AccessSqlParse line {code:java} TableInfo[] info = getTableInfo(m_sql[i].trim()); class {code} it trim end space 3. so at class AccessSqlParse line {code:java} int index = from.lastIndexOf(WHERE); // end at where" {code} it can't detect | 09:50 |
| Not-7634 | where clause and conside where like alias of table let query total wrong ========= I try to find all where use WListbox.prepareTable (both overload function) but no where drop the case. but it still is error. easy to see it by edit class InfoPanel line 415, last parameter become true. and open any info window. {code:java} String sql =contentPanel.prepareTable(layout, from, where,p_multipleSelection, | 09:50 |
| Not-7634 | getTableName(),true); {code} ===== block 1 ====== {code:java} SEVERE: SELECT COUNT(*) FROM ( SELECT i.M_InOut_ID, i.C_BPartner_ID AS C_BPartner_ID, i.MovementDate AS MovementDate, i.DocumentNo AS DocumentNo, i.Description AS Description, i.POReference AS POReference, i.IsSOTrx AS IsSOTrx, i.C_Order_ID AS C_Order_ID FROM M_InOut i WHERE AND i.AD_Client_ID IN(0,1000003) AND i.AD_Org_ID IN(0,1000027,1000007,1000008) AND | 09:50 |
| Not-7634 | (i.M_InOut_ID IS NULL OR i.M_InOut_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 319 AND AD_User_ID <> 100 AND IsActive = 'Y' )) i.IsActive='Y' AND i.IsSOTrx = ? AND i.AD_Client_ID IN(0,1000003) AND i.AD_Org_ID IN(0,1000027,1000007,1000008) AND (i.M_InOut_ID IS NULL OR i.M_InOut_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 319 AND AD_User_ID <> 100 AND IsActive = | 09:50 |
| Not-7634 | 'Y' )) ) a org.postgresql.util.PSQLException: ERROR: syntax error at or near "AND" {code} " | 09:50 |
| Not-7634 | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-2989 | 09:50 |
| *** aaa has joined #idempiere | 10:25 | |
| aaa | what is this supposed to do? anyone know? | 10:25 |
| *** aaa has quit IRC | 10:27 | |
| *** CarlosRuiz has joined #idempiere | 11:38 | |
| *** CarlosRuiz has quit IRC | 11:58 | |
| *** CarlosRuiz has joined #idempiere | 12:11 | |
| *** saman_ has joined #idempiere | 13:58 | |
| saman_ | hi | 13:58 |
| saman_ | I want to use idempiere services in my app but idempiere has model base web services and for example I cant call a service to mange my accounting and so on . | 14:00 |
| saman_ | Am I write? | 14:01 |
| saman_ | I want to user idempiere as project to manage my erp and crm and I call its services without knowing about inner tables and inner structure | 14:02 |
| saman_ | is it possible? | 14:02 |
| saman_ | or I should know data models to call model base web services? | 14:02 |
| saman_ | please help me | 14:09 |
| *** jdpaniagua has quit IRC | 15:29 | |
| *** jdpaniagua has joined #idempiere | 15:34 | |
| *** saman_ has quit IRC | 16:27 | |
| *** saman_ has joined #idempiere | 16:27 | |
| *** saman_ has quit IRC | 16:49 | |
| *** CarlosRuiz has quit IRC | 17:42 | |
| *** jdpaniag_ has joined #idempiere | 17:52 | |
| *** jdpaniagua has quit IRC | 17:54 | |
| *** jdpaniagua has joined #idempiere | 17:56 | |
| *** jdpaniag_ has quit IRC | 17:58 | |
| *** a42niem has quit IRC | 23:36 | |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!