Refining a document collection

HCL Domino Domino Forum
1

Goal:1. Create a document collection from a view which shows a specific project type based on the year input from the user.

  1. Further refine that document collection so that I can have separate collections for the different status options. (i.e. Proposal Submitted and Proposal Signed)

  2. Compute the value of the fee field for each of the different project status option. (i.e. the total value for all proposals of status “Proposal Submitted” for the year input is XXX dollars.)

Problem:

  1. This item has been accomplised using separate views for each project type and then using GetAllDocumentsByKey to sort out those that match the user-input year - no problem.

  2. This document collection can be refined based on the status using Call.FTSearch, but this does not leave me with a variable equating to the document collection created by the Call.FTSearch in order to traverse them and pull out the fee field.

Is there a way to refine a document collection such that the result can be accessed?

I am quite new to LotusScript, so please forgive the question if it is elementary, but I have read through Help, a LotusScript book, and many posts without finding a solution.

Any help is appreciated.

Regards,

Megan Taylor

2

Subject: Have you considered using a view?

  1. Categorize the first column by “Status”.2. Categorize the second column by “Year”.

  2. In a third, uncategorized column, calculate the fee:

rate:=@if(Status=“Status1”;0.4;Status=“Status2”;0.25;…);

rate * Cost;

  1. Total the third column.
3

Subject: Refining a document collection

Hello Megan Taylor,

        I also faced almost similar problem. Have you got any solution for that problem? Can u please send me the details? I got an error message "There is no current search result to refine". I'm fresh to LS. Please help me boss.

Dhanya.