Gooinf through 2 sorted columns

HCL Domino Domino Forum
1

Hello, I am trying to get some documents in a sorted view. the first two columns in this view are categories, the first is year and the second is the month. Let’s say the first category is 2007 and the second is January and february. I am able to get all the documents in January with this code:

Set view = db.GetView(“Life”)

Set vc = view.GetAllEntriesByKey(“2007”, False)

Problem is, what do I do to get the documents under february?

I think I am close but i can’t seem to figure out what I am missing.

Thanks

2

Subject: Gooinf through 2 sorted columns

Hi Philip,

You will need to use an key array like in the code below.

Dim key(0 to 1) as String

Set view = db.GetView(“Life”)

Key(0) = “2007”

Key(1) = “February”

Set vc = view.GetAllEntriesByKey(Key, False)

Hope this helps.

Best Regards,

Munish Kaushik

3

Subject: RE: Gooinf through 2 sorted columns

It worked! Thanks =)