Search code examples
javaxpageslotus-noteslotus-domino

Does getAllDocumentsByKey work in lotus domino if there is a categorized column after the key columns?

I have a notes View that has the first 5 columns categorized and the rest of them as flat. For example:

  1. company
  2. user
  3. year
  4. month
  5. day
  6. project
  7. hours
  8. cost

I want to getAllDocumentsByKey (or getAllEntriesByKey) and my key is a vector of the first 4 columns. So i expect to get all documents for all days below month. Instead i get only the documents of the first category below month (those of day 1 only).

Finally i made a copy of the view with only the first 4 columns as categorized and i used this one to make it work, but is there any solution for this behavior?

Solution

  • In order to use a key to search multiple categories, pass a vector as the key.

    java.util.Vector key = new Vector<String>() //could be Object

key.add("myCo");
key.add("user@myCo.com");
key.add("2012");
key.add("04");
key.add("1");

vw.getAllDocumentsByKey(key, false);