Skip to Main Content
HCL Domino Ideas Portal

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

Status Needs Review
Workspace Domino Designer
Categories LotusScript
Created by Guest
Created on May 9, 2022

Missing documentation for NotesDominoQuery class

Currently working my way through DQL and QRP topics. Tried to get a catch on NamedResults and was wondering for a couple of days why I couldn't get it to work:

I'm working on a simple query like

Set nQuery = myDb.CreateDominoQuery()

sQuery = "taskNumber >= 10000 AND taskNumber <= 20000

Database in question resides on a server, contains 500k documents and is FT indexed.

Running an explain from my client in debug mode is giving me the expected results:

sExplainResult = nQuery.explain(sQuery)

as well as running a simple execute:

Set docCol = nQuery.execute(sQuery)

If however I try to make use of a NamedResult I receive a runtime error:

Set docCol = nQuery.execute(sQuery, "docset1", True, 48)

Error returned is

"Domino Query execution error: invalid arguments"

If however I run the same code as a server agent, or if I run that code in a local replica of the database from my client, then the code works as expected; on the server console I see a message telling me that the Named Result was created/rewritten successfully.

Similar behaviour I see when trying to use Named Variables.

It looks as if we had the same rule here that we have with NotesQueryResultsProcessor: code cannot run in a remote client.

If it is a problem to make this work remotely then it can't be helped (although I think it would makle sense at least for debugging situations...). But then it MUST be documented properly in online AND offline help!

  • Attach files
  • Guest
    May 12, 2022

    This links to the problem, that the designer documentation has a lot of gaps. Especially an updated help database is wanted.