iam working on a client - based project…there is a view with its first column ‘Project Code’ is categorized and sorted.Now the rest of the columns includes ‘project name’ , ‘report date’,etc
What i need to do,when the user selects any ‘Project Code’(i have done @dbcolumn in this) then there is another field ‘Date’ on the form,when user selects the date then further the documents should be filtered and respective documents should be retrieved?
For e.g.-
If i select ‘1000’(project code) and put ‘january’ in the date field …then all the documents of january only that falls in the category of ‘1000’ project code should be retrived and not others which are also in the same category but in some other ‘report date’…pls help me…
somebody give me the code of doing this…i tried alot using alldocumentsbykey but it is giving me wrong documents…i mean all the documents of different category also…
Subject: How to search the documents by lotus script using some Keyword in a view which is already sorted and categorized in view?pls help me its really urgent
I would use a Search on the database to get what you want into a document collection. If you want to present the final list to a user then I would copy the document collection into a Folder. Check the syntax - for example I forget if it’s “&” inside the search string or “and”
Dim s as New NotesSession
Dim db As NotesDatabase
dim dc as NotesDocumentCollection
dim fld as NotesView
dim doc as NotesDocument
Dim ss as String
’ Doc is the dcoument which has the values selected by the user
’ You will probably want to empty the folder first.
. . . Call dc.PutAllInFolder(“FolderName”)
end if
Of course you might want to add more to the searchstring (ss) to limit the documents selected. For example:
form = “formname”
Maybe you only want documents of a particular status.
Look at your selection criteria for your view to help limit the number of documents returned.
Alternatively I would work with a second view as Carl suggest.
I normally suggest you have hidden views used by the system doing look ups. Then user views that maybe categorized, sorted as the users want to see them.
Subject: How to search the documents by lotus script using some Keyword in a view which is already sorted and categorized in view?pls help me its really urgent
Well you need multiple sorted columns in the view. First is your category, second is the month etc.
You need to pass an array to the GetAllEntriesByKey method
Search this forum for GetAllEntriesByKey and array for more details
Showing your code will also help people to help you.