When users sort on a view using a column sort, some entries go away from the view … this is a big view (about 43000 entries) …
The view column is a multiple field column showing just the first entry (could this be the reason???)
Any insight would be appreciated …
Thanks.
Subject: View Sort Columns
Did you resolve this problem?
I have a view that loses documents when I click on a column sort. This view has no categories and no multi-value columns. Each document in the view should be represented by only one line. I do a Select All which gives me a document count of 18036, then I click on a column to resort the view. After the sort, I do a Select All and get a document count of 6714.
Subject: RE: View Sort Columns
I know this is an old post, but just happened to come across it. We have seen this issue also and have found that the view index needs to be deleted and rebuilt. Once that is done, all the documents are displayed as expected.
Subject: View Sort Columns
Since it is such a big view, it would be difficult to tell whether a particular entry was missing, or whether it was just not where you expected to find it.
You say, “The view column is a multiple field column showing just the first entry” I’m not sure what you mean by this. Is the column entry multivalued, or is it the concatenated value of multiple fields?
Depending how the view is sorted before you re-sort, you can expect certain entries to go missing. If the view is categorized or set to display multiple entries on separate rows, your 43000 entries may be only 20000 documents (for example). If you re-sort, you’re likely to end up with only one entry per document, since there’s no way to specify a categorized re-sort.
Specifically, if you re-sort a column whose entries are multivalued, I believe you’ll find it sorts by only the first entry in the multivalue field. Is that what you’re saying? That’s the expected behavior.
Highlight a document that goes missing when you re-sort, then re-sort. The document should stay highlighted so that you can see where it ended up (if not, try actually selecting the document so that you can locate it with F3).