title: FetchXML link entity including null values
body: <p>I'm trying to query CRM using FetchXML. Here is the query to account entity, this returns me 10 records, here <em>new_primaryactivityname</em> field has <code>NULL</code> for few records.</p>
  <pre><code>&lt;fetch mapping=&quot;logical&quot; version=&quot;1.0&quot;&gt;
    &lt;entity name=&quot;account&quot;&gt;
      &lt;attribute name=&quot;accountid&quot; /&gt;
      &lt;attribute name=&quot;name&quot; /&gt;
      &lt;attribute name=&quot;new_primaryactivity&quot; /&gt;
    &lt;/entity&gt;
  &lt;/fetch&gt;
  </code></pre>
  <p>Now i want to link it with another entity to get a new field, i want to do <code>LEFT OUTER JOIN</code> like in sql, to keep the <code>NULL</code> values while linking, so i provided link type as outer and i applied a filter for few conditions.</p>
  <pre><code>&lt;fetch mapping=&quot;logical&quot; version=&quot;1.0&quot;&gt;
    &lt;entity name=&quot;account&quot;&gt;
      &lt;attribute name=&quot;accountid&quot; /&gt;
      &lt;attribute name=&quot;name&quot; /&gt;
      &lt;attribute name=&quot;new_primaryactivity&quot; /&gt;
      &lt;link-entity name=&quot;stringmap&quot; from=&quot;attributevalue&quot; to=&quot;new_primaryactivity&quot; alias=&quot;new_primaryactivity_lookup_name&quot; link-type=&quot;outer&quot;&gt;
         &lt;attribute name=&quot;value&quot; /&gt;
      &lt;/link-entity&gt;
      &lt;filter type=&quot;and&quot;&gt;
          &lt;condition entityname=&quot;new_primaryactivity_lookup_name&quot; attribute=&quot;attributename&quot; operator=&quot;eq&quot; value=&quot;new_primaryactivity&quot; /&gt;
          &lt;condition entityname=&quot;new_primaryactivity_lookup_name&quot; attribute=&quot;objecttypecode&quot; operator=&quot;eq&quot; value=&quot;999&quot; /&gt;            
      &lt;/filter&gt;
    &lt;/entity&gt;
  &lt;/fetch&gt;
  </code></pre>
  <p>The result(less than 10 records) ignores the records with <em>new_primaryactivityname</em> as <code>NULL</code>, what am i missing in FetchXML query?</p>
  <p>I do not have much access to to system other than use FetchXML, i referred few suggestions to use tool in help building FetchXML query but i can't do it due to restrictions.</p>