Different levels of categories

HCL Domino Domino Forum
1

Hi AllI cannot believe that this has not been answered already but I can’t find it anywhere in the forums.

I have a standard document database but I need to have differing levels of category in the same view. IE

Level 1

Level 2

     Document

Level 1

Level 2

     Level 3

           Document

Level 1

Document

…

OR Alternatively

Level 1

Level 2

           Document

Level 1

Level 2

     Level 3

           Document

Level 1

           Document

How can I do this without having empty lines?? Effectively hidding empty categorisation?

Many thanks - and a very Happy Xmas to the person who gets this right - grin!!!

Tim

tnorris@notesafrica.co.za

2

Subject: Different levels of categories

Your first 3 columns in the view will be categorized and you will choose in columns 2 and 3 to “Don’t display empty categories”.

Done

Good luck.

3

Subject: Different levels of categories

Just use the "" for your multivalued categorized column /field, delimter, this will categorie the view properly.

4

Subject: RE: Different levels of categories

Hi Thank you all for that. Are you saying that I can combine levels of category into one column? Interesting thought as I have them in seperate columns per category. The posting took out all my spacing - so let me that layout again -

Level 1

… Level 2

…Document

Level 1

…Document

Level 1

…Level 2

… Level 3

…Document

Maybe that makes it clearer what I need - but I will definitely try a multivalued category column as well. Thanks for your help

Tim

5

Subject: *This is the approach I use. Works very nicely, and is very flexible.

6

Subject: RE: *This is the approach I use. Works very nicely, and is very flexible.

HiSorry but I am not able to get this right - can you explain in detail how to do this please - Level 1 comes from one field, Level 2 from another and Level 3 from a third and they each display in their own columns. Am I supposed to combine them into a single column with a "" somewhere?

Bit thick today - sorry

7

Subject: RE: *This is the approach I use. Works very nicely, and is very flexible.

You are on the right track. Are all the fields single or multi-valued?

I suppose this would work on single value fields but I did not test it.

First sorted categorized column formula would be something like

FIELD1 + “\” + FIELD2 + “\” + FIELD3

You need to use 2 \ since notes strips one of them out.

8

Subject: *Exactly

9

Subject: RE: *This is the approach I use. Works very nicely, and is very flexible.

Great - got it. Many thanks