Hi i have document library having custom column named INDEX of type Number and there is some folders and documents in document library like
I have created CAML query to get item having maximum Index value.
query += "<Where>";
query += "<IsNotNull>";
query += "<FieldRef Name='INDEX'/>";
query += "</IsNotNull>";
query += "</Where>";
query += "<OrderBy >";
query += "<FieldRef Name='INDEX' Ascending='FALSE' />";
query += "</OrderBy>";
itemQuery.Query = query;
In result i am getting is below which is wrong.
In result all folders are displaying and then files are displaying.
Excepted result should be like below.
Can anyone help me in this issue?