topic Re: Help needed with this SQL in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/help-needed-with-this-sql/m-p/301504#M254634 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>It is not recommended to write queries directly against the Alfresco database. </SPAN><BR /><SPAN>In the future, alfresco might add/remove few fields during upgrade or service pack / hot-fix</SPAN><BR /><SPAN>I would recommend always read the data by using Alfresco API and manipulate the date in your code.</SPAN><BR /><BR /></BODY></HTML> Wed, 18 Mar 2015 05:04:15 GMT muralidharand 2015-03-18T05:04:15Z Help needed with this SQL https://connect.hyland.com/t5/alfresco-archive/help-needed-with-this-sql/m-p/301503#M254633 I have a parent Node ID and i want to get all its children and few properties of child nodes, this query is not performing for mecan someone review it and tell me there is a better way to do the same thing or can be this be improved so that it performs&nbsp; WITH&nbsp; nodes as ( SELECT childNode.id as id,chi Sat, 14 Mar 2015 16:54:25 GMT https://connect.hyland.com/t5/alfresco-archive/help-needed-with-this-sql/m-p/301503#M254633 arslan 2015-03-14T16:54:25Z Re: Help needed with this SQL https://connect.hyland.com/t5/alfresco-archive/help-needed-with-this-sql/m-p/301504#M254634 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><SPAN>It is not recommended to write queries directly against the Alfresco database. </SPAN><BR /><SPAN>In the future, alfresco might add/remove few fields during upgrade or service pack / hot-fix</SPAN><BR /><SPAN>I would recommend always read the data by using Alfresco API and manipulate the date in your code.</SPAN><BR /><BR /></BODY></HTML> Wed, 18 Mar 2015 05:04:15 GMT https://connect.hyland.com/t5/alfresco-archive/help-needed-with-this-sql/m-p/301504#M254634 muralidharand 2015-03-18T05:04:15Z