As i got "column-shifts" on the NotesView2-table in my browser on certain views, using the search resp. the search-agent "agtSearchView", i found out, that the agent doesn't handle hidden columns correctly.
The prblem is, that although categories were ignored, hidden columns were not. I've got a small workaround, that fixes that problem and points out the thing, as i hope:
(Starts ca. at line 70)
Dim fixvar As Integer<br/>
fixvar = 0<br/>
Forall value In entryResult.ColumnValues<br/>
If Not vwSearch.Columns(x).isCategory And Not vwSearch.Columns(x).isHidden Then <br/>
Print "<entrydata columnnumber=""" & Cstr(x-fixvar) & """ name=""" & vwSearch.Columns(x).itemName & """>"<br/>
Print "<text>" & XMLEscape(Cstr(value)) & "</text>"<br/>
Print "</entrydata>"<br/>
Else <br/>
If vwSearch.Columns(x).isHidden Then<br/>
fixvar = fixvar + 1<br/>
End If<br/>
End If<br/>
x = x + 1<br/>
End Forall<br/>
Also: if one column doesnt contain anything but a static formula, i.e. a constant (!), (e.g.: "CustomIcon.gif" to display the same icon on every entry of the column) then we've got another problem, cause ColumnValues doesn't return anything for this, as the help pages say:
"A column value is not returned if it is determined by:
- A formula containing a UI-only function such as @IsExpandable or @DocNumber.
- A constant."(!)
Therefore i don't know, how to change it - ColumnValues seems to be insufficient to handle this issue .
Kind regards,
Stefan