View selection formula doesn't work

HCL Domino Domino Forum
1

Hi,

I’ve got stuck in a simple view selection formula problem here. Scenario is something like below …

There are 4 fields … f1, f2, f3 and f4.

All of those 4 fields should not be blank in a document.

So to get selected and displayed in the view at least one of those 4 fields should have a value in it.

I tried with all of below formulae, but all in vain.

Cond := (ViaSalDia_1 = “” & ViaSalDia_2 = “” & ViaSalDia_3 = “” & ViaSalDia_4 = “”);

!Cond;

(ViaSalDia_1 != “” & ViaSalDia_2 != “” & ViaSalDia_3 != “” & ViaSalDia_4 != “”)

!(ViaSalDia_1 = “” & ViaSalDia_2 = “” & ViaSalDia_3 = “” & ViaSalDia_4 = “”)

View is displaying some documents in which all 4 fields do not have any value.

Apart from this condition, there are other conditions like within the view selection formula …

SELECT ((Form = “ViGaSol”) | (Form = “ViaFor”) | (Form = “ViaSol”)) & !Cond & (ViaEstado=“Aprobada (Enviada a Agencia)”) & (@TextToTime(ViaSalDia_1) >= @Date(2010;10;25)) & (@TextToTime(ViaSalDia_1) <= @Date(2010;10;29))

Thanks a lot in advance. Any suggestion is highly appreciated.

Regards,

Abhishek SenGupta.

2

Subject: Try | instead of &

Try this:ViaSalDia_1 != “” | ViaSalDia_2 != “” | ViaSalDia_3 != “” | ViaSalDia_4 != “”

3

Subject: Solved!

I’m sorry, the problem was there in view cache. I’ve entered Ctrl+Shift+F9 and view is showing desired results.

… :wink: