*** 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!