Notes Error while exporting values

HCL Domino Domino Forum
1

Hello,

I am trying to export in to excel the fields which does not contain any values for that I am searching for fields having “” value but it is showing Notes error :Formula Error(Form=“frmsw”&(kwlSupTeam=“SD-TCS”)&(kwlStatus=“”“”))

Can you please help me out how I have to search for fields which does not any values.Its very urgent.

2

Subject: Notes Error while exporting values

Hi Satya,

I am not sure where you got the error.But I would do it this way.

Write the script to fetch each document and check fields of that particular document.

'Initalize Notes Objects=====

Set Session = New NotesSession

Set DB = Session.CurrentDatabase

Set TestColl = DB.UnprocessedDocuments

'Get First Document

Set CurrDoc = TestColl.GetFirstDocument

While Not(CurrDoc Is Nothing )

Forall Items In CurrDoc.Items

If Items.ValueLength = “” Then

end if

End Forall

Set CurrDoc = TestColl.GetNextDocument(CurrDoc)

Wend

With some customisation and later exporting to excel it should work.

Regards,

Varun

3

Subject: Notes Error while exporting values

There’s something wrong with your search formula. It seems that you correctly “escaped” the quotation marks for everything except kwlStatus.

The last part should read kwlStatus=“” and not kwlStatus=“”“”