This is such a simple task - I’m pulling my hair out here… I’ve used notesviewentrycollection many times in the past - but I just can’t understand why I can’t get all the entries for a key.
The view is categorized by the first 3 columns (all in ascending order). I’m trying to get allentriesbykey(“13”,True).
I can see them in the view, and I even tried rebuilding the index. What am I missing? Why won’t this work?
Subject: Why does my notesviewentrycollection only return 1 entry???
Make sure all the fields are of the same datatype you are trying to lookup.If the fields are text, you need to lookup for “13”, if they’re numbers you need to lookup for 13, etc…
Subject: RE: Why does my notesviewentrycollection only return 1 entry???
Thanx - actually the first column that I am keying on is a formula @text(SlsRep). When the “13” didn’t work, I changed the column formula to be just SlsRep (which is numeric)and then tried 13 - but I ended up with the same result.
Subject: RE: Why does my notesviewentrycollection only return 1 entry???
What happens when you enter 13 from the keyboard, where does the cursor in the view jump?
Subject: RE: Why does my notesviewentrycollection only return 1 entry???
It takes me to the collapsed category entry for 13.
Subject: RE: Why does my notesviewentrycollection only return 1 entry???
Hmm, so your first column is categorized.Try making a new lookup view, which has only 1 column, which is sorted ascending and not categorized.
Subject: A brand new view worked fine…
The other view must have been corrupted - but you wouldn’t know it by looking at it. That cost me a couple hours - thanx for your help.
Subject: RE: A brand new view worked fine…
Categorized columns are sometimes very wierd, sometimes they show up keywords which no document has in their fields, I don’t know exactly where and how that info is cached. A view rebuild (Shift-F9) will not fix them either.