I need to include a value from a parent document in a view showing the child documents. To do this, I created a field on the child document and then added code to the parent document's QuerySave event that updates the new field on any existing child documents. Works great once the parent doc has been saved, but how do I update the thousands of existing documents?
I tried creating an agent and using @Command([ToolsRefreshSelectedDocs]), which did save all the records but did not seem to call QuerySave. I also tried using the LotusScript code in QuerySave in an agent, but that doesn't work because I can't reference the Notesuidocument. Should one of these methods work? Is there another method?