Hi
I am using the GetAllEntriesByKey method of the notesview class to retrieve a collection of entries. The first argument of the method is an array of 2 items. The view in which i am searching has 5 columns, the first 3 are sorted and the first 2 are categorized. When I use the method in the code with an array of 2 items ( of which I know there are at least 2 entries) the viewentrycollection stays empty. Could it be because the first 2 columns are categorised?
Regards
Subject: GetAllEntriesByKey does not return any entries
That the columns are categorized should not make a difference. More specifics please. Show your code. Talk about the datatypes of the data in the columns and in your code – for instance, are you searching for a text date in a column that contains non-text dates? Talk about precisions of values – for instance, are you searching for a date and time in a column that contains only a date? You understand that the two keys are supposed to match against the same document in column 1 and column 2, not multiple values in the same column. Right?
Subject: RE: GetAllEntriesByKey does not return any entries
Hi
The array I use is of type string. The first column value is from a date/time field and the second clumn from a text field. How can I place that in the array to find the viewentrycollection?
Subject: RE: GetAllEntriesByKey does not return any entries
You will never match a Date column using a String value!
Use an array of type Variant instead. In each element, put a value of an appropriate type for the corresponding column.
I believe to match a date value, you will need to use a NotesDateTime object. So,
Dim keys(0 to 1) as variant
set keys(0) = New NotesDateTime(your date in text form)
keys(1) = "string to search for in column 2 "