Why doesn't this view selection formula work?

HCL Domino Domino Forum
1

SELECT Form = “VacRequestHourly” | Form = “VacRequestNotes” & Type = “Vacation” & ( @Contains(@DbColumn( “Notes”:“NoCache” ; “” : “”; “(Employee Info by Title)” ; 2 );Employee ))

What I do is to show all vacation requests created by either of two forms, whose employee names are in the second column of another view.

This is kind of a join operation.

Thanks!

2

Subject: Why doesn’t this view selection formula work?

You can’t use @dbcolumn in a view selection, I believe.

3

Subject: RE: Why doesn’t this view selection formula work?

So how can I “join” two views together? Thanks!

4

Subject: RE: Why doesn’t this view selection formula work?

The quick answer is that you can’t. You’d have to really be creative on how to do this… maybe writing some script to do a db search and then forming your own “view” using javascript and html and ajax (just some of the possibilities). The only way you could do this in Notes is if you used some of the new DB2 functionality (not for the faint of heart).

Remember, Notes keeps an index for every view. They are not dynamic in the way that you are trying to make them.

5

Subject: RE: Why doesn’t this view selection formula work?

Thanks, get it.