I'm currently fighting my way into the DQL and QRP classes (LotusScript/Java), and found many bad and misleading information as well as missing parts in Designer help. To begin with, there are only examples in the LotusScript area, Java examples are missing altogether.
And the given LS examples are full of mistakes:
Set Query$ = "firstname = 'Annabelle' and lastname = 'Stevens' and 'Personview'.dept = 'Sales'"
Set ResultName = "MySavedResults"
Set ExpireHours = 72
Novices in LotusScript may not be aware that we can't use "Set" when it comes to assigning values to scalar variables...
2nd example is NotesDominoQuery.setNamedVariable:
The method's description isn't of much help, saying:
...The name of a substitution variable specified in a DQL query, after the question mark. So "date_of_birth? is seen as ?date_of_birth in DQL syntax.
Turning to the example below things are getting worse:
TheQuery.Setnamedvariable("lastname", "Stevens")
Set Query$ = "firstname != 'Annabelle' and lastname = "lastname"
Set doccol = TheQuery.Execute(Query$)
The 2nd line here is completely wrong and misleading: either it should be "... and lastname = 'lastname' ", or rather "... and lastname = ?lastname" (which doesn't work for me either, but that's a different story).
In combination with the method's description I assume that it should be "... = ?lastname".
Newly added methods like the ones regarding NamedResultSets "DQL.RemoveNamedResult" and "DQL.RemoveAllQueryNamedResults" are missing altogether at the class description. They are only mentioned in the "What's new in the Domino Designer 12.0.1" area.
There are many more examples. Bottom line is:
An accurate Domino Designer help still is extremely important, esp. if we want to pull in new Designers to support the product (and I bet we want that!). And if there are examples in Designer help (and they are needed!) then please make sure they are accurate and meaningful!
We are working on getting the the code errors fixed. Thanks for raising the issue.
Ad DQL.RemoveNamedResult:
https://help.hcltechsw.com/dom_designer/12.0.0/basic/H_REMOVENAMEDRESULT_METHOD_NDQ.html
DQL.RemoveAllQueryNamedResults:
https://help.hcltechsw.com/dom_designer/12.0.0/basic/H_REMOVEALLQUERYNAMEDRESULTS_METHOD.html
Could not agree more. Anything in the last +10 years is nowhere near up to the standards it used to be in earlier versions. I have wasted so much time over the years attempting to fathom things out. Getting up to speed with the details of XPages was black art rather than an exact science.
Any joined up learning resource is left to the community, but that is too fragmented.