How to categorize a field with allow multi value in a document? Is it possible

HCL Domino Domino Forum
1

Hi,

I am creating the documents from a file. Each document has a field name “Product” & “Grade” with allow multi value selected.

Each cutomer has a unique document.

each unique cutomer document has n number of products in the Product field with corresponding grades(A, B, C, D etc) in Grade field.

My question is how can i categorize the product value based on the grades for each unique customer document.

ex: For customer John doe, I want to show the products by categorized Grade

+A

abc

xyz

+B

efg

hij

+c

klm

nop

+D

qrs

tuv

Can anyone please let me know how to do this?

Appreciate your help.

sri

2

Subject: RE: How to categorize a field with allow multi value in a document? Is it possible

Looks like you want Multiple values in multiple rows in multiple columns

3

Subject: RE: How to categorize a field with allow multi value in a document? Is it possible

Hi Andrei,

Thanks for the response. I tried this but I am not getting the proper result.

I am getting only one value but there are many values in the filed

+John doe

+A

   Abc

 +B

   Ghi

 +C

  Mno

But I want like this.

+John doe

+A

   Abc

   Def

+B

   Ghi

   Jkl

+C

  Mno

  Pqr

Thanks

sri

4

Subject: RE: How to categorize a field with allow multi value in a document? Is it possible

Here is a screenshot from a view of the same database as in my blog, still with only one document. I added a “Grade” field and gave it the values “A”:“B”:“A”. This is still one document, with the items “3109B”:“4428C”:“5660D”. The item numbers are correctly categorized under the grades that were assigned to them, and in the case where two items received the same grade, they are both displayed in the appropriate view category.The view has three columns – two are categorized, obviously, and the third has the option ticked “Show multiple values as separate entries.”

5

Subject: RE: How to categorize a field with allow multi value in a document? Is it possible

Thanks verymuch for your help. I did get solved. I have used the same categorized methos as you explained and used @explode to get the values.

Thanks again for your help.

sri