| *** hieplq has joined #idempiere | 05:00 | |
| *** a42niem has joined #idempiere | 06:30 | |
| *** nmicoud has joined #idempiere | 07:45 | |
| Not-4af | [IDEMPIERE] norbert.bede updated IDEMPIERE-3167 assignee set to "Norbert Bede" | 12:21 |
|---|---|---|
| Not-4af | [IDEMPIERE] http://idempiere.atlassian.net/browse/IDEMPIERE-3167 | 12:21 |
| hieplq | hi nmicoud did you query path of attachment file on oracle? what's function to use | 12:27 |
| hieplq | i try select extract(XMLTYPE.createXML(BINARYDATA , 871, null, 0, 0), 'attachments/entry[@file]') FROM AD_Attachment x WHERE x.AD_Attachment_ID=1000202; but it just return XMLTYPE | 12:27 |
| hieplq | i final can parse it by use | 13:07 |
| hieplq | select | 13:07 |
| hieplq | attachInfo.filePath, attachInfo.fileName | 13:07 |
| hieplq | FROM | 13:07 |
| hieplq | AD_Attachment x, | 13:07 |
| hieplq | XMLTABLE('attachments/entry' | 13:07 |
| hieplq | passing XMLTYPE.createXML(BINARYDATA , 871, null) | 13:07 |
| hieplq | COLUMNS filePath varchar2(4000) PATH '@file', | 13:07 |
| hieplq | fileName varchar2(4000) PATH '@name') attachInfo | 13:07 |
| hieplq | WHERE x.AD_Attachment_ID=1000202; | 13:07 |
| *** Nefril has quit IRC | 13:17 | |
| nmicoud | hello hieplq, sorry didn't see you message :( but i never did that, cool you succeed :) | 13:33 |
| hieplq | thanks for consider nmicoud oracle have too much document, so hard to swimming inside it :) | 13:35 |
| nmicoud | :D | 13:35 |
| *** mbozem has joined #idempiere | 15:48 | |
| *** mbozem has quit IRC | 16:14 | |
| *** nmicoud has quit IRC | 16:22 | |
| *** hieplq has quit IRC | 18:40 | |
| *** a42niem has quit IRC | 18:54 | |
| *** silphium has joined #idempiere | 20:33 | |
| *** a42niem has joined #idempiere | 21:39 | |
| *** jdpaniagua has quit IRC | 21:59 | |
| *** jdpaniagua has joined #idempiere | 21:59 | |
| *** a42niem has quit IRC | 23:00 | |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!