topic Re: Attachments and Comments in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/attachments-and-comments/m-p/133313#M93626 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I want to filter it by database query to avoid this kind of checks.</BLOCKQUOTE><BR /><SPAN>That isn't offered out of the box unfortunately. You'd need to write your own queries + commands.</SPAN><BR /><BR /><SPAN>Alternatively, you can use the NativeQuery, altough you'd need to create your own subclass since for comments no nativeQuery class exists yet.</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">Also, what is the best way to relate the attachments with comments? to obtain userID and time</BLOCKQUOTE><BR /><SPAN>I'm afraid that's also pretty hard to do, as the text is just generated at runtime and the userid and time is passed …. besides some basic string filtering I can't think of much.</SPAN></BODY></HTML> Fri, 15 Mar 2013 09:27:23 GMT jbarrez 2013-03-15T09:27:23Z Attachments and Comments https://connect.hyland.com/t5/alfresco-archive/attachments-and-comments/m-p/133312#M93625 Hi all!!I found this API excellent by his interfaces and the code itself.But now, I have a question that I can't find answer,&nbsp; across the code or the JavaDoc.When I add an attachment to the proccess, Activiti automaticly adds a comment to that attachment. So, when I ask for comments I get ALL undesi Thu, 14 Mar 2013 14:56:06 GMT https://connect.hyland.com/t5/alfresco-archive/attachments-and-comments/m-p/133312#M93625 jotapdiez 2013-03-14T14:56:06Z Re: Attachments and Comments https://connect.hyland.com/t5/alfresco-archive/attachments-and-comments/m-p/133313#M93626 <HTML><HEAD></HEAD><BODY><BLOCKQUOTE class="jive-quote">I want to filter it by database query to avoid this kind of checks.</BLOCKQUOTE><BR /><SPAN>That isn't offered out of the box unfortunately. You'd need to write your own queries + commands.</SPAN><BR /><BR /><SPAN>Alternatively, you can use the NativeQuery, altough you'd need to create your own subclass since for comments no nativeQuery class exists yet.</SPAN><BR /><BR /><BLOCKQUOTE class="jive-quote">Also, what is the best way to relate the attachments with comments? to obtain userID and time</BLOCKQUOTE><BR /><SPAN>I'm afraid that's also pretty hard to do, as the text is just generated at runtime and the userid and time is passed …. besides some basic string filtering I can't think of much.</SPAN></BODY></HTML> Fri, 15 Mar 2013 09:27:23 GMT https://connect.hyland.com/t5/alfresco-archive/attachments-and-comments/m-p/133313#M93626 jbarrez 2013-03-15T09:27:23Z