Get the Categorized Column value

HCL Domino Domino Forum
1

Hi,

I facing one problem. In my database there is one form on which there are 3 field which stores the Approver names say Approver1, Approver2, Approvr3. Similarly there are 3 fields which stores the duration that each approver took to approve the document say Duration1, Duration2, Duration3.

Now I want to create a view where first coulmn should be categorized & should display the approver’s name. Second column should display the duration like this

App1

– Duration (3 hrs)

– Duration (2 hrs)

App2

– Duration (1 hrs)

– Duration (5 hrs)

App3

– Duration (4 hrs)

I created the view categorized on the Approver name by providing column formula as “Approver1:Approver2:Approver3” in the first column. but I am able to display the duration related to approver, in the second column.

Based on the Category value say “App1” I want to pickup the duration stored in one of the duration fields.

So could somebody pls tell me how to get the Categorized Column value? or is there any alternet way to do the same thing.

Thanks & Regards,

Chaitanya

2

Subject: Get the Categorized Column value

Chaitanya,

This is a fairly common type of problem and unfortunately there is no simple solution. One solution is to have your document spawn tiny (hidden) response docs which would each carry a single value (or row) of data from your multi-value fields. Then it’s easy to display those tiny docs in the view. But this has drawbacks of its own.

No easy solution,

raphael

3

Subject: RE: Get the Categorized Column value

There is a very simple & easy solution to this

Have only one column categorised

field1 + “\”+ field2

And then something in the second column to be there for clicking on (“open here” or a title or something)