Manage Learn to apply best practices and optimize your operations.

Categorizing views based on related multi-valued fields

How to show related multi-valued fields sorted in a view.

Have you ever faced the problem with multi-valued fields that are related to one another and tried to show them sorted in a view? For example, Field 1 selections drive Field 2 selections and both hold multiple values.




expected result
Org Name Person Name E-Mail Address
------------------------------------------------------

Abc Company
------------------Jone
[email protected]

BBC
------------------kevin
[email protected]

actual shown
Org Name Person Name E-Mail Address
------------------------------------------------------

Abc Company
------------------Jone
[email protected]
------------------kevin
[email protected]



BBC

------------------Jone
[email protected]
------------------kevin
[email protected]

SOLUTION
Create a new field on the form and name it CATEGORIES. This can be a multi-valued field with NL as separator. Make it a combination so that the field value appears like this:

[email protected]
[email protected]
Your view the first column has to be categorized and it has to look up this CATEGORIES field. Preview in Notes and I guess this should work fine. I have just done something like this.

If the preview does not work, first try SHIFT+F9 to rebuild the view index. If that does not work try selecting one document in the view and use Actions --> Categorize. If it shows you an empty prompt, type in [email protected] and then do the SHIFT+F9. This will change the value in the categories field. But since that is a computed field, open the document and refresh it again and you should be in business.

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip library by member Prashul Kumar. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Dig Deeper on Lotus Notes Domino Coding and Development

SearchWindowsServer
Search400
  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/Search400.com community. These cheat ...

SearchDataCenter
SearchContentManagement
Close