In SharePoint 2010 I want to display a document library view from a record-centre in another site collection and the best option seems to be Lists.asmx GetListItems and a DataFormWebPart.
I want to sort on Person columns so I set up a basic test with a vanilla document library in one site collection and a publishing site in another. I used Lists.asmx and a DataFormWebPart and switched-on Sorting by column.
If I attempt to filter on the ows_Editor column I receive the message:
"This column type cannot be filtered"
Is it possible to get this working? If not, is there a better way of presenting data from a record centre?