Does anyone know what is the Formula to sort the documents in select statement? For example when creating a view:SELECT FORM = “Form1” SORT???
I don’t want to use Column properties for sorting. This problem also applicable to script coding:
Set notesDocumentCollection = notesDatabase.Search("SELECT FORM = “Form1” SORT???
Gimme back the JDBC driver!
Subject: ? and !
Usually when making a selection for a view you just select which documents to include in the view and sort by using columns and their properties, a column can be hidden from the user. I don’t know of any other way and even if one exists if would possibly clash with the column sorting -idea.
To make a notesdatabase.search resulting in a sorted collection you need to set up an empty collection using notesdatabase.search first and then add documents to that collection so you will most probably be using two collections.
Good luck
Subject: Nope
Can’t be done using default Notes. Nor is there any need for it. You should use column sorting or filtering by FTSearch.
Reason: SQL statements like you want to use only work on relational databases, which Lotus Notes is not (/cry). JDBC drivers convert relational queries to work with the LN db system.