Fetchxml filter for View to exclude Non-interactive users

If you need to filter out specific records in view results while using fetchxml filter, this tutorial has got you covered. The tutorial addresses a Stack Overflow query about excluding Non-interactive user account records in a user view by using the fetchxml filter.

To understand this filter, it needs to be used on the System user entity, and the field should be "accessmode". Typically, Non-interactive users have an accessmode value of 4, which is what we can use to exclude them from the results, as per this query. The complete fetchxml filter will look like this:

<condition attribute="accessmode" operator="ne" value="4" />

The filter is then applied to the entity using the following fetchxml code:

  <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
    <entity name="systemuser">
      <attribute name="fullname" />
      <attribute name="businessunitid" />
      <attribute name="title" />
      <attribute name="address1_telephone1" />
      <attribute name="positionid" />
      <attribute name="systemuserid" />
      <order attribute="fullname" descending="false" />
      <filter type="and">
        <condition attribute="accessmode" operator="ne" value="4" />
      </filter>
    </entity>
  </fetch>

Overall, this tutorial is a handy guide for anyone looking to filter out specific records from their view results with the fetchxml filter.

Reference Link: https://arundynamix.blogspot.com/2020/12/fetchxml-filter-for-view-to-exclude-non.html