I have a library in SharePoint 2010. The library has folders, each item in the library, including the folder, are tagged with a number (separate column).
When I do an 'OrderBy' the column, the ordering works, however it groups the elements by content type.
<Where>
<And>
<Or>
<Geq>
<FieldRef Name='_ModerationStatus' />
<Value Type='ModStat'>0</Value>
</Geq>
<BeginsWith>
<FieldRef Name='ContentTypeId' />
<Value Type='ContentTypeId'>0x0120</Value>
</BeginsWith>
</Or>
<And>
<Geq>
<FieldRef Name='OrderBy' />
<Value Type='Number'>1</Value>
</Geq>
<Neq>
<FieldRef Name='ID' />
<Value Type='Counter'>1</Value>
</Neq>
</And>
</And>
</Where>
<OrderBy>
<FieldRef Name='OrderBy' Ascending='True' />
</OrderBy>";
The ordering works, but it always groups the results by content type prior to ordering. See the example below, the folders are group and ordered, and the files are grouped and ordered.
Name OrderBy
FolderA 2
FolderB 3
FolderC 4
FileA 1
FileB 5
Is there anyway to solely order the items in the list by the 'OrderBy' column only?