title: Sharepoint : Accesing a file by its name from a .NET app. Over 5000 items isue. Need an index by file "Name" column?
body: <p>I am developing a .net application to process information in sharepoint.
  There are over 5000 items in the sharepoint library I work with.</p>
  <p>I wrote a CAML filter to handle the &gt;5000 items problem. It works fine when I use the &quot;Modified&quot; column to filter, but if I use the &quot;Name&quot; column instead, I keep getting the &gt; 5000 error message.</p>
  <p>example1:</p>
  <pre><code>camlQuery.ViewXml = &quot;&lt;View&gt;&lt;Query&gt;&lt;Where&gt;&lt;Geq&gt;&lt;FieldRef Name='Modified'/&gt;&lt;Value Type='DateTime'&gt;2020-11-02T15:08:15Z&lt;/Value&gt;&lt;/Geq&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;/View&gt;&quot;
  </code></pre>
  <p>example2:</p>
  <pre><code> 'camlQuery.ViewXml = &quot;&lt;View&gt;&lt;Query&gt;&lt;Where&gt;&lt;Geq&gt;&lt;FieldRef Name='LinkFilename'/&gt;&lt;Value Type='Text'&gt;002-000000.pdf&lt;/Value&gt;&lt;/Geq&gt;&lt;/Where&gt;&lt;/Query&gt;&lt;/View&gt;&quot;
  </code></pre>
  <p>The only difference I see is that &quot;Modified&quot; is an indexed column .
  I tried to create an indez for &quot;Name&quot; column with the sharepoint online menu, but this column name (&quot;Name&quot; nor &quot;LinkFilename&quot; ) doesn't apear between the posibilities.</p>
  <p>How can I create an Index for &quot;Name&quot; column? .</p>
  <p>thanks</p>