VoltFormula and Document Selection

HCL Volt MX Go Volt MX Go Tips
1

VoltFormula and Document Selection -

VoltFormula supports the ability to perform document selection using SELECT (formula) within the Iris app. However, before deciding on using this approach within your app, you should consider other options.

  1. For VoltFormula to support SELECT documents using Object Services, it needs to read in all documents into the client and perform the formula against each document to determine selection. For larger DBs, this becomes a performance problem.

  2. Domino Views support Selection Formulas as part of the View definition (Domino Designer). So you can specify on the Domino Server which View records you want to return to the client based on the View Selection formula. This is much more efficient since the selection of documents is happening on the server. Also, simply reading the View records from the client (@All) is providing you with the intended results.

So it is best to perform document selection on the Domino Server. We will have improvements to the selection support in the future, but for now it is best to utilize the Domino Server View selection formula support.