Equivalent @DbColumn in Lotus Script

HCL Domino Domino Forum
1

I have a categorised view and would like to retrieve all unique entries from the categorised column.

How can this be accomplished using Lotus Script?

2

Subject: Equivalent @DbColumn in Lotus Script

Just use your @DbColumn formula in an Evaluate as in…

Dim results as Variant

Dim cmd as String

cmd = {@DbColumn(“”:“NoCache”; “”; “myView”; 1)}

results = Evaluate(cmd)

ForAll r in results

…

End Forall

Since you are retrieving from a categorized column, the results should already be unique.

3

Subject: Equivalent @DbColumn in Lotus Script

Straight from Designer help for @DbCoumn:

Language cross-reference

ColumnValues property of LotusScript NotesDocument class

GetColumn method of LotusScript NotesView class

ColumnValues property of Java Document class

getColumn method of Java View class