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
Subject: 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”
Subject: 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