This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


~Richard Frohipilitjip
Aug 11, 2015, 8:48 AM
27 Posts
topic has been resolvedResolved

View Column with 'Display Multiple Values separately'

  • Category: Domino Designer
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer
  • Tags:
  • Replies: 2

Hi,

i want to schow all permutations of two fields with multiple values.

Column formula is:

Field1 + "/" + Field2

If one document is in the view and every field has 2 values, i would expect 4 lines.

The problem is, that it generates only 2 lines. Domino seems to resolve only one Field and puts a random value of the other field to it.

Does anybody know a solution ?

Uwe

~Fritz Ekfoobergflar
Aug 11, 2015, 1:08 PM
202 Posts
Nope
As they are lists, Item 1 in list one will be prepended Item 1 in list two , example


Values:
Field1
A
B

Field2
D
E

so you would get
A/B
D/E

I think you want Concatenation, permutation (see operations on lists in domino designer help

Concatenation, permutation "A":"B":"C"*+"1":"2":"3"

"A":"B":"C"*+"1":"2"

"A1":"A2":"A3":"B1":"B2":"B3":"C1":"C2":"C3"

"A1":"A2":"B1":"B2":"C1":"C2"


~Richard Frohipilitjip
Aug 11, 2015, 2:35 PM
27 Posts
made it with viewNavigator

Thank you Carl, now i do understand how notes makes it. 

I do need it for matching purposes (all possible permutations should appear). I've solved it with categories:

 

Column1 -> categorized Field1

Column2 -> categorized Field2

Set nav = view.createViewNavFromCategory(contentfield1 + "\" + contfield2)

if not(nav is nothing) then

        'found .....

end if

 

 


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal