topic Re: retrieve description properties from all documents in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/retrieve-description-properties-from-all-documents/m-p/258719#M211849 <HTML><HEAD></HEAD><BODY><SPAN>I could find a query that displays the results that i wanted correctly. lucene is new to me</SPAN></BODY></HTML> Tue, 11 Sep 2012 13:04:49 GMT sharifu 2012-09-11T13:04:49Z retrieve description properties from all documents https://connect.hyland.com/t5/alfresco-archive/retrieve-description-properties-from-all-documents/m-p/258717#M211847 I have many documents in my share. I want to retrieve all the text in description field from all my documentsHow can I achieve this?I found&nbsp; the information is saved in alf_node_properties table under column string_value however how would i collect this information for each document as the title is Mon, 10 Sep 2012 09:33:04 GMT https://connect.hyland.com/t5/alfresco-archive/retrieve-description-properties-from-all-documents/m-p/258717#M211847 sharifu 2012-09-10T09:33:04Z Re: retrieve description properties from all documents https://connect.hyland.com/t5/alfresco-archive/retrieve-description-properties-from-all-documents/m-p/258718#M211848 <HTML><HEAD></HEAD><BODY><SPAN>What is the reason for not using the regular alfresco services and API:s? Querying the database directly is something that is not recommended. </SPAN><BR /><BR /><SPAN>Why not just issue a lucene search for all nodes inheriting from cm:content with the cm:titled aspect?</SPAN><BR /><BR /><SPAN>/Erik</SPAN></BODY></HTML> Tue, 11 Sep 2012 12:49:21 GMT https://connect.hyland.com/t5/alfresco-archive/retrieve-description-properties-from-all-documents/m-p/258718#M211848 billerby 2012-09-11T12:49:21Z Re: retrieve description properties from all documents https://connect.hyland.com/t5/alfresco-archive/retrieve-description-properties-from-all-documents/m-p/258719#M211849 <HTML><HEAD></HEAD><BODY><SPAN>I could find a query that displays the results that i wanted correctly. lucene is new to me</SPAN></BODY></HTML> Tue, 11 Sep 2012 13:04:49 GMT https://connect.hyland.com/t5/alfresco-archive/retrieve-description-properties-from-all-documents/m-p/258719#M211849 sharifu 2012-09-11T13:04:49Z