Outline entry and negative hide-when formulas?

HCL Domino Domino Forum
1

Hello,

I know that other people had the same problem… but I’ve not been able to find an answer on this forum.

I want to hide outline entries based on the value of a field in my form (my outline is embedded in a form below that field). If I use “positive” hide-when, everything works fine. But if I use this:

fieldValue != “test”

…my entry is hidden even if fieldValue is in fact equal to test. I also tried these:

!(fieldValue = “test”)

@If(fieldValue=“test”; @false;@true);

…nothing is working.

Do someone ever found a workaround for this?

Other posts:

http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/9c084055d21bccd485256b280064d4a3?OpenDocument&Highlight=0,hide,outline,uwe

http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/ced111792652d99a85256b26006e2e8d?OpenDocument&Highlight=0,hide,outline,negative

http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/e69ebcc1b0b4413585256bb100450fd3?OpenDocument

2

Subject: Outline entry and negative hide-when formulas?

Try using @IsMember & @IsNotMember functions

3

Subject: RE: Outline entry and negative hide-when formulas?

Thanks for your answer… but unfortunately, I have the exact same problem with @IsMember/@IsNotMember.

I have a field on my form called “section”. This field could have many different values (at least ten).

I want to hide an entry like this:

section != “schedule”

… but it’s not working.

And this way:

@IsNotMember(“schedule”; section)

… is not working too.

My entry is hidden even if my section is worth “schedule” or not.

If I do the opposite:

section = “schedule”

@IsMember(“schedule”; section)

… this is working the “usual” way.

My entry is hidden when section is set to schedule… and shown otherwise.

As soon as you put a negative condition, it always hide the entry… even if it should not.

It’s really a bug in the hide-when of outline entry. I’m just looking for a workaround, but have no idea how I could do this otherwise.

Thanks!

Pascal

4

Subject: Try: !(section = “schedule”)

5

Subject: RE: Try: !(section = “schedule”)

Thank you, but I have already tried that (see the top post)… and it doesn’t work.

Any other idea?

6

Subject: RE: Outline entry and negative hide-when formulas?

I’ve just tried it myself, and there is no bug here. It works fine for me. Admittedly I’m using 6.5.3, but I have no reason to believe there has been a change in this area recently.

The code that decides whether to hide the outline entry doesn’t know or care whether a formula is “negative” – that’s a subjective judgment on your part, not a matter of syntax. Whether the formula works can’t possibly depend on this, any more than it can depend on whether the formula is “elegant”.

I can think of a couple of things that might be causing your problem.

Hiding happens correctly based on the value that’s in the field when you open the document (“”) but the hidden entry doesn’t appear when you change the field to “test” because you failed to refresh the form after the field changed.

The field doesn’t have the value that you think it does, e.g. because it uses a keyword synonym and you’re testing for the display text rather than the actual value, or because it’s a Names field and stores the canonical name (“CN=…/O=…”) instead of the abbreviated name that it displays.

If the above doesn’t clue you in to a solution, then you need to describe the field and your formulas in greater detail and give the actual formulas you are using, not other formulas which resemble them somewhat.

7

Subject: RE: Outline entry and negative hide-when formulas?

I thought I gave all the details… but here’s more.

I have an outline embedded into a form. Just above the embedded outline, I have a “Computed For Display” field with the following formula: @UrlQueryString(“section”).

I receive a “section” parameter into the URL. (Could have many different values, including “schedule”, “prod report”, “budget”, …)

In my outline, I have the same amount of entries (“schedule”, prod report", “budget”, …).

On the “schedule” entry, I have the following hide-when formula

section!=“schedule”

With this formula, my entry is hidden even if “section” is worth “schedule”… which is incorrect.

If I do this opposite on my “shedule” hide-when:

section=“schedule”

Then, my entry is hidden when my field is worth “schedule”, which is correct, and shown when the field is worth “prod report”, which is correct too.

So, It may be a “subjective judgment” on my part, but how do you explain it?

As for your two suggestions:

1- I don’t have to refresh the page, since my field is evaluated before the outline. (my field is above that outline). I used that same technique to create “dynamic” embedded view from a parameter in the URL.

2- The value does have the correct value, I see it on the page, and when using a “positive” condition, the hide-when works as expected.

As a final note, I wrote in the main post some links to other people experiencing the same problem. I’m using 6.04… we don’t have 6.5.x yet… maybe that problem was fixed in 6.5.

Unless you prove me wrong, I still think that this is a major bug.

Thanks!

8

Subject: RE: Outline entry and negative hide-when formulas?

Ah. The important piece of missing information is that this is a web app. Now I can reproduce your issue.

I’ve been doing some experimenting to try to find out what the exact behavior of the problem is, and I can’t get any kind of hide formula to work correctly unless it somehow comes down to field = “value”.

The best workaround I was able to come up with, is to create a second field, CFD, with a formula such as:

@Trim(@Replace(“schedule”: “prod report”: “budget”: …; Section; “”))

Then you can use = to compare with this field.