Hi
I am trying to create script for the following scenario and was wondering whether someone could help to get my desired outcome
scenario explained below:
'lookup the view, do an FT search on tempdoc.StaffName, if ftsearch returns more than 1 doc found,
' tempdoc.StaffName appears twice, do some processing
'get the role value, the site and the division value from the view column values not the actual field for each of the documents found in the ft serach
'if role is same then do some procesing
'if site is same then do some procesing
'if division is same then do some procesing
i have tried the above as script below:
Dim viewview As NotesView
Dim viewdoc As NotesDocument
Set viewview = currentDb.GetView("ATestV3")
j = viewview.FTSearch( tempdoc.SMStaffName(0), 0 )
Set viewdoc = viewview.GetFirstDocument
counter% = 1
Dim column As NotesViewColumn
Dim people( 1 To 5 ) As Variant
Dim currentpeople As Variant
For i = 1 To j
currentpeople = viewdoc.ColumnValues( 0 )
people( counter% ) = currentpeople
counter% = counter% + 1
Set viewdoc = viewview.GetNextDocument(viewdoc)
Next
currentpeople(1) and currentpeople(2) returns an array of values which I KNOW WILL contain
the value conatined in tempdoc.SMStaffName(0), but how do i do this...i tried item.contains but that did not work....what do i need to do to get the value i require...the issue also here is that
currentpeople(1) may contain for eg:
"John Smith~ACO" but tempdoc.SMStaffName(0)would equal "John Smith" only...so i need to somehow do an @Left in script and then do that @contains in script
But my main aim is to find out if the documents found in ftsearch have values in the column that are similar and not the actual fields for the documents that are similar..hope that makes sense...the driving force of doing the comparisons is the column values in the view..for eg in a view i may have:
Name | Role | Site Based
jim smith | Developer | London
jim smith | Developer | Birmingham
jane candy | Manager | Leeds
I can do an ft search for jim smith which will return 2 documents and i want to get the values in the role column (2nd column) for those docs found in ftsearch and do a some processing if the values are the same which they are (Developers) and do the same for the 3rd column (Role column)
can someone please help.
Thanks in advance
Print this page
