#idempiere IRC log for Monday, 2017-01-23

*** hieplq has joined #idempiere05:00
*** a42niem has joined #idempiere06:30
*** nmicoud has joined #idempiere07: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-316712:21
hieplqhi nmicoud did you query path of attachment file on oracle? what's function to use12:27
hieplqi 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 XMLTYPE12:27
hieplqi final can parse it by use13:07
hieplqselect13:07
hieplq  attachInfo.filePath, attachInfo.fileName13:07
hieplqFROM13: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') attachInfo13:07
hieplqWHERE x.AD_Attachment_ID=1000202;13:07
*** Nefril has quit IRC13:17
nmicoudhello hieplq, sorry didn't see you message :(  but i never did that, cool you succeed :)13:33
hieplqthanks for consider nmicoud oracle have too much document, so hard to swimming inside it :)13:35
nmicoud:D13:35
*** mbozem has joined #idempiere15:48
*** mbozem has quit IRC16:14
*** nmicoud has quit IRC16:22
*** hieplq has quit IRC18:40
*** a42niem has quit IRC18:54
*** silphium has joined #idempiere20:33
*** a42niem has joined #idempiere21:39
*** jdpaniagua has quit IRC21:59
*** jdpaniagua has joined #idempiere21:59
*** a42niem has quit IRC23:00

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