Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.
For more information and upcoming events around #dominoforever, please visit our Destination Domino Page
Still no joining capabilities...
Just curious to know, how HCL claims that this one has been shipped, but the objects and classes mentioned here do not provide any methods for UNION. And how are we supposed to use this, if there is no documentation available for that?
This feature has shipped with Domino 12.0
https://help.hcltechsw.com/dom_designer/12.0.0/basic/wn_notesqueryresultsprocess_class.html
It is available for preview as part of the Domino V12 beta: https://blog.hcltechsw.com/domino/start-your-engines-hcl-domino-v12-beta-is-here-are-you-ready/
(Notes)QueryResultsProcessor supports multiple database input and computes and merges data by sort criteria. v12 provides UNION with ORDER BY (to provide SQL analogs) support. Joins can be performed across multiple returned entries.
True joins will be supported later.
We're definitely going to be doing this - John Curtis