Dynamic View & Dyanmic Column Problem

HCL Domino Domino Forum
1

Hi,

I’m trying to make a dynamic view and dynamic columns but i’m facing a problem in getting the dynamic column value, could anybody help me in achieving what i’m trying to get, here is the code:

formula = {SELECT (Form="fmTASS" & ((ServiceArea1_1="} & AreaCtgry & {" ) | (ServiceArea1_2="} & AreaCtgry & {" ) | (ServiceArea1_3="} & AreaCtgry & {" ) |

(ServiceArea1_4=“} & AreaCtgry & {” ) | (ServiceArea1_5=“} & AreaCtgry & {” ) | (ServiceArea1_6=“} & AreaCtgry & {” )

) )}

Dim vc As NotesViewColumn



Set Vw = Db.GetView("vwTAProductSelection")

Vw.SelectionFormula = formula

Set vc = Vw.Columns(0)

vc.Formula=AreaCtgry      '// I need the value of this variable not AreaCtgry.

Call uiws.ViewRebuild

Based on this value i have other colums that are to be generated also, how could i get the handle of first columns value for other columns generation…pls help.

Thanks & Regards

Vijay Baswal

2

Subject: Dynamic View & Dyanmic Column Problem

Use the ItemName property of the columns you want to reference in other column formulas. Unfortunately ItemName is read-only, so you can’t use it to assign column programmatic names.

3

Subject: Dynamic View & Dyanmic Column Problem

I have been working on dynamic views for a long time now and came to the following: there are only 2 ways to achieve this:

  1. build your view and columns using the appropriate C API functions

  2. build a fixed view and get the variations with the values of fixed fields in its documents

Ad 1) not easy, because the documentation has stopped after R5 (!) and the sample program is not generating enough hidden view-attributes.

Ad 2) e.g. create 10 columns based on fields like: col01, col02 … col10. Then write your code to fill each of these fields as you want them to be.