It fetches the rows in tree structure, but i need them order by creation_time desc with group by the tree structure. But if I used the order by creation_time desc this qry fetches the rows in reverse tree structure.
Also, without ordering by creation_time ,it inserts new row(at 1st level) after the 3rd row( in result above) instead of first row.( if i insert a row, it will be queried by this query for display - 8 , 0, 2/11/1 , -8000 should be fetched as a first row in the query).
The query should fetch the rows
order by creation_time desc and grouped by tree.
please suggest a solution
02-07-2001, 03:29 PM
Hi Satish did you define creation_time as a 'DATE' field ?