SELECT vsf_Demoas selection formula, where "vfs" stands for "View Selection Formula". In large applications that results in a rather nice performance. Downside of the approach: you need to compute these values on each alteration of a document (but that's not too hard). You can use this method even to retrofit existing applications to improve performance. These are the steps:
SELECT @Allones) to point to that field
getWFDefinition(...), getApprovers(...), resolveRole(...)etc. What calls would make sense in an engine warrants a post on its own. Then code against the API (this is called contract first programming). This way it doesn't matter if your storage backend changes and you can keep the considerations for storage separate from the considerations for your applications. In Domino such an API would be best implemented using the Extensibility API (that's what XFlow is doing). Now to the storage options:
John Doe, my assistant developer, can always be found hard at work in his cubicle. John works independently, without wasting company time talking to colleagues. John never thinks twice about assisting fellow employees, and he always finishes given assignments on time. Often John takes extended measures to complete his work, sometimes skipping coffee breaks. John is an individual who has absolutely no vanity in spite of his accomplishments and profound knowledge in his field. I firmly believe that John can be classed as a high-calibre employee, the type which cannot be dispensed with. Consequently, I duly recommend that John can be promoted to executive management, and a proposal will be executed as soon as possible.
This site is in no way affiliated, endorsed, sanctioned, supported, nor enlightened by Lotus Software nor IBM Corporation. I may be an employee, but the opinions, theories, facts, etc. presented here are my own and are in now way given in any official capacity. In short, these are my words and this is my site, not IBM's - and don't even begin to think otherwise. (Disclaimer shamelessly plugged from Rocky Oliver)
© 2003 - 2013 Stephan H. Wissel - some rights reserved as listed here:
Unless otherwise labeled by its originating author, the content found on this site is made available under the terms of an Attribution/NonCommercial/ShareAlike Creative Commons License, with the exception that no rights are granted -- since they are not mine to grant -- in any logo, graphic design, trademarks or trade names of any type. Code samples and code downloads on this site are, unless otherwise labeled, made available under an Apache 2.0 license. Other license models are available on written request and written confirmation.