• Search-agent doesn't handle hidden columns correctly

    By Stefan Deser 2 decades ago

    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 &quot;&lt;entrydata columnnumber=&quot;&quot;&quot; &amp; Cstr(x-fixvar) &amp; &quot;&quot;&quot; name=&quot;&quot;&quot; &amp; vwSearch.Columns(x).itemName &amp; &quot;&quot;&quot;&gt;&quot;<br/>
                    Print &quot;&lt;text&gt;&quot; &amp; XMLEscape(Cstr(value)) &amp; &quot;&lt;/text&gt;&quot;<br/>
                    Print &quot;&lt;/entrydata&gt;&quot;<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