topic Re: Want SQL query to find Noderef. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/want-sql-query-to-find-noderef/m-p/284433#M237563 <HTML><HEAD></HEAD><BODY><SPAN>Why do you not use a Lucene query? There is a whole search subsystem in Alfresco to do this kind of thing "easily".</SPAN></BODY></HTML> Fri, 12 Jun 2015 15:28:46 GMT rjohnson 2015-06-12T15:28:46Z Want SQL query to find Noderef. https://connect.hyland.com/t5/alfresco-archive/want-sql-query-to-find-noderef/m-p/284432#M237562 Hi Team,I want a list of Noderefs on which custom aspect "abc" and custom property "xyz" are available. Query should give a list of noderefs in which, this custom property "xyz" has a value in Lower Case. I have made below query but it did not help me much.select * from alfresco.alf_node_properties Thu, 11 Jun 2015 11:47:53 GMT https://connect.hyland.com/t5/alfresco-archive/want-sql-query-to-find-noderef/m-p/284432#M237562 hardik_thakkar 2015-06-11T11:47:53Z Re: Want SQL query to find Noderef. https://connect.hyland.com/t5/alfresco-archive/want-sql-query-to-find-noderef/m-p/284433#M237563 <HTML><HEAD></HEAD><BODY><SPAN>Why do you not use a Lucene query? There is a whole search subsystem in Alfresco to do this kind of thing "easily".</SPAN></BODY></HTML> Fri, 12 Jun 2015 15:28:46 GMT https://connect.hyland.com/t5/alfresco-archive/want-sql-query-to-find-noderef/m-p/284433#M237563 rjohnson 2015-06-12T15:28:46Z