A real tricky notes view problem

HCL Domino Domino Forum
1

I know that there must be a solution to this but I can’t find it !!

I am trying to test something out so I have created a database with some football match documents in it. These document relate to matches played and as such they have a ‘homeTeam’ and an ‘awayTeam’ field.

What I would like to do is to create a view that has all the teams categorised in column 1. In column 2 I would then like to categorise each teams documents ‘home’ and ‘away’.

Sounds easy but I can’t do it !!

I have managed to do the first part by creating a text list and then categorising the column:

@Explode(homeTeam + “,” + awayTeam;“,”)

What I can’t do though is to get the second column to be categorised home and away.

Can anyone help ?

Thanks

Paul

2

Subject: a real tricky notes view problem …

In your Categorised column try

A := HomeFieldName + “\ Home”;

B := AwayFieldName + “\ Away”;

A : B

3

Subject: thanks to you both

both solutions work, i never knew you could create your own columns …

4

Subject: Possible solution

I don’t think you can do this directly. Column 2 can only have one value (or set of values) in the view. You cannot have the same document in a view twice with different column values, which is what you would need.

You may be able to get the same effect by using a single column with a cascading category. Try …

(homeTeam+“\Home”) : (awayTeam+“\Away”)

This will create two values in column one. HomeTeam\Home and AwayTeam\Away. The \ tells Notes to create a sub-category within the same column.