Enable sorting of the documents by making headings hyperlinks that will sort documents upon click. Documents should be sorted by alphabetical order eg. for document owner (descending order) and chronoligcal order for date of creation (the most recent at the top). If the heading is ciicked twice, the order is inverted.
The problem is there are many forms using this view. For each form, it selects only particular documents. If i used the option present in view properties i,e Click on Column header to sort, it sorts and displays all the documents present in that view.
Please suggest me how to sort that particular columns without affecting the whole documents present in the view.
Subject: How to sort a column in a view…
Hi, Just right click on the First column or the column Which u want to sort and go to second tab and select the option whether Ascending or Desending.Normally we keep the sorted column as the first column in the view or We normally sort the first column.If u have any doubt,just reply me
Subject: RE: How to sort a column in a view…
ya thats i know… But my problem is different. I am using that view in many forms. In each forms i have to display only few documents and i want to sort out only those documents. But if i go as your suggestion it will sort entire documents and all documents will appear in that view.
Subject: RE: How to sort a column in a view…
You cannot allow sorting on categorized views that are embedded with “show single category”. As you have observed, it breaks the show single category restriction if yuo have sorting.
Hello - Lotus!! Can you fix this some time please?
You could get around the problem with this somewhat inelegant and somewhat problematic solution:
When the form opens, have it copy all the documents from the corresponding category in your view into a folder (be sure to empty it first) which has the sortable columns that you want. The folder would be embedded on your form using Create\Embedded Element\View.
Beware, that this solution does NOT handle multiple instances of the same form open at the same time so it would work OK for web applications, but would definitely not be suitable for a Notes client application.
Subject: RE: How to sort a column in a view…
Not to be a sphincter of any sort, but what’s to “fix”? When you click on a column header to sort, you are making that column the primary sort column for the view – so of course the categorization is going to go away. In order to make sorting in category work, we’d need a mechanism to set the secondary sort column, and that would break the expected behaviour of the “Starts with…” search and so forth. That’s not good either. So we’re not looking at a fix here, but at a major redesign of how UI views are created.
I can’t see a way around this using Notes view indices – one would need to query and return a self-contained result set (which is what your folder work-around does) so that different sorts could be accomplished within the result set. A DB2 Query View ought to be able to do it now, and it is do-able on the web (assuming the category in the view is anything like a reasonable size AND the browser has JavaScript enabled). It should also be a doddle if the XPages design element is exposed to the Notes client (probably post-8.5).
Subject: RE: How to sort a column in a view…
I guess “fix” is the wrong word (my apologies if I ruffled any feathers, that was not my intention at all) - perhaps “add new feature” would be more approriate. It would be really awesome if users could change the sort order of embedded show-single-category views. The user’s expectation is that a view is a view and they do not make a distinction between embedded ones and stand-alone ones - they expect them to all work the same way. I understand the implications of this from a technical prespective - it would be very difficult to do, but that does not detract from the fact that this would be a desirable feature for embedded views.
Subject: RE: How to sort a column in a view…
If Xpages happen in the client (and in the Eclipse-based client, there’s no reason to believe it won’t – even if it was conceived as a web design element), almost all of the old pains should be relieved. It’s not that the structures will change, but the way we access them should; so instead of presenting a view directly, we could present a result set in a view-like container. Since the result grid/table is self-contained as a run-time collection, we ought to be able to manipulate it as needed.
*Note, too, that one can do this as a rich-text table representation in the client now with the aid of a toolset like the Midas Rich Text LSX. It won’t look exactly like a view, and it will have some limitations, but it is doable. I know, that’s not exactly the same thing as having the tool built-in – there’s extra work and money involved – but for anyone who absolutely needs this kind of functionality and can’t use the web (or an applet in the client), it is an option.
Subject: RE: How to sort a column in a view…
Is the embedded view on the web or the client? What formula are you using? Is it a single category web form? Tell us more please.
Subject: RE: How to sort a column in a view…
Its normal… Nothing else…