I am not very Notes savy and wonder if someone can help me. I am trying to create a view, and one of the selection criteria is the value of a column in another view (ideally from another DB, but I can copy the necessary info if it is only possible from the same DB). How do I get that value to use in my selection criteria? I tried @dbcolumn, but after researching, documentation suggested that formula will not work in Selection Criteria. Any suggestions would be greatly appreciated!
thank you
Subject: View Selection Criteria
Jake, a view selection formula only selects documents based on the data in the documents within the database in which you create the view. You cannot specify data from another source.
Subject: RE: View Selection Criteria
Thank you for your response, that’s what I was afraid of.
Subject: RE: View Selection Criteria
If you want that value, you can create a computed field in the form, grab the value into this database from another using a dblookup thing as computed formula. Then can use that value in the view selection formula.
In order to update all documents, use the computed formula in an agent, with last line as FIELD “created Field” := dblookup value. Run this agent on all the selected documents in the view so that all will have that new value now. This value now can be used in selection formula like
select created Field = “value” so that only these will be displayed.
Subject: RE: View Selection Criteria
Thank you, the problem I see with that is that my value changes on a month to month basis, so I will have to update all the documents every month. I am going to attempt to solve using LotusScript in the QueryOpen event to dynamically assign the SelectionFormula. If that doesn’t work I will sell all my Domino servers and switch to a SQL Server & .NET solution.