Avatar of fatihdi

asked on 

I want to obtain the columnvalues of a view how can I do that?

I use viewnavigator and obtain the entry but I need to get the column values of the entry.

How can I do this?

ColumnValues are calculated using formula ,so I guess it is not possible to obtain values with viewNavigator?

Doing that what I want to achieve is that, I need to get the two dates on the form and name of the creater of the form and then compare it to other forms' date and name information,if the person is the same and it has collapsing dates I need to change the color of both records of view so that someone can easily find the problamatic,collapsing records in the view....If I was able to retrieve the information of the records easily with viewNavigator .I was going to do that but I dont know what can be done on this? User generated image
'Below is the code I dont know is there a way to obtaing the column values which there are about 13 columns in the view??

Dim s As New NotesSession
	Dim db As NotesDatabase
	Dim coll	As NotesDocumentCollection
	Dim view As NotesView
	Dim doc	As NotesDocument
	Dim nav As NotesViewNavigator
	Dim entry As NotesViewEntry
	Dim columnvalues(1 To 13) As Variant
	Set db=s.Currentdatabase
	Set view=db.Getview("IzinGenelIK")
	Set nav=view.Createviewnav()
	Set entry=nav.Getfirst()
	Do Until entry Is Nothing

	 Set entry=nav.Getnext(entry)

Open in new window

Lotus IBMDatabases

Avatar of undefined
Last Comment
Avatar of fatihdi

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of fatihdi


I have obtained the columnvalues as I explained in my comment so this question is no longer valid.
Avatar of Sjef Bosman
Sjef Bosman
Flag of France image

Even with a categorized view this is possible. You have to check each entry for isCategory.
Avatar of Bill-Hanson
Flag of United States of America image

Boy! Would it kill ya to wait a few minutes so we can try to help?

Here's how I do @DbColumn in LotusScript:

Dim values As Variant
Dim db As NotesDatabase
Set db = session.CurrentDatabase
values = Evaluate({@Trim(@Unique(@DbColumn("":""; "} + db.Server + {":"} + Replace(db.Filepath, "\", "\\") + {"; "ViewName"; ColumnNumber)))})

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo