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
--------------------------jone@abc.com

BBC
------------------kevin
--------------------------kevin@bbc.com

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

Abc Company
------------------Jone
--------------------------jone@abc.com
------------------kevin
--------------------------kevin@bbc.com



BBC

------------------Jone
--------------------------jone@abc.com
------------------kevin
--------------------------kevin@bbc.com

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:

CompanyJoneJone@abc.com
BBCKevinKevin@bbc.com
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 BBCKevenKeven@bbc.com 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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close