Hi…
i have a $$SearchTemplateDefault which shows the search results in $$ViewBody field, now i want to access all the records shown in this field so that it can be exported to excell…
How do I go about doing this??
or is there any other way were in i can access the search results?
Subject: Presentation vs. Data
Think of the situation this way: The $$ViewBody field on the form is basically just a container to display the results of the search (presentation). What you want to do is build a method to actually obtain the search results (data) and export them to excel. The simplest way to do this is a LotusScript or Java agent (LS is probably easier unless you are a Java programmer already). You will want to write a LotusScript program to mimic the results you’re seeing in the $$ViewBody field and then export those to the Excel file.
Set up the search using a LotusScript or Java agent and write the results directly to an excel file. You can store the search parameters when the search is run and use those in the LotusScript once the results are displayed on the screen, for instance.
Scrape the output html table from the screen using Javascript and pass it to a LS or Java agent which creates the file (Javascript cannot access the file system directly due to security restrictions in the web browser).
The first method is probably simpler as you will be using Domino objects for everything and there will be no need to deal with the HTML document on the screen at all.