How to ignore "Not Categorized"

HCL Domino Domino Forum
1

Hi,

I have created a view which contains actioners,description and ImplActioned.

Each of these fields have 20 in turn.

Means actioner1,actioner2,actioner3 and so on.

Simlarly for other fields as well.

ImplActioned field contains whether the particular action has been completed or not.

Now i have to create a view to show all uncompleted actions.

Means

Actioner : Description : Uncompleted

Have to select the values from the document which are all uncompleted.

I have a problem in creating this view.

The formula i have used is.(only for 2 actioners i have given.similarly have to do for 20 actions)

@Trim(@If(ImplActioned1 !=“Actioned”;

(Actioner1 +“\”+ RelRef +“\”+ ImplDesc1);“”) :

@If(ImplActioned1 !=“Actioned”;

(Actioner1 +“\”+ RelRef +“\”+ ImplDesc1);“”));

The problem is when the document contains both action1 and action2 it is categorized properly.

But when the second action is empty it is creating a new section “Not Categorized” in the view which is not required and putting same document again in this section too.

Can anyone tell me how to ignore or what formula should be used for that.

Thanks in advance.

Siva

2

Subject: How to ignore “Not Categorized”

In your formula (I suspect that the latter half should refer to ImplAction2) you do not deal with the situation that the field is empty. So you return an empty string, which is shown in the view as “Not categorized”.

You have to extend your formula to deal with these situations, and do not generate output in these cases.