# Filter SharePoint content

> important  **IMPORTANT**: The Sitefinity SharePoint connector is deprecated and not supported. For more information, see [Deprecated capabilities in Sitefinity CMS](https://www.progress.com/documentation/sitefinity-cms/deprecated-capabilities-in-sitefinity-cms).

To apply a filter to items that come from SharePoint to Sitefinity CMS, perform the following:

1. Click *Administration*» *Settings*» *Advanced*» *SharepointConnector*» *\<your site name>* » *List mappings* » *\<your list mapping name>* » *SharePoint filter*.\
   Under *SharePoint filter*, you can create as many filter conditions, as needed, and connect them with a logical operator. The logical operator must be *AND* or *OR*. For example, you can create one filter condition – Country equals USA, and another logical condition Country equals UK. These filter conditions are linked with the logical operation that you enter in *SharePoint filter*.
2. To create a filter condition, under *SharePoint filter*, click *Filter conditions* » *Create new*.  Fill out the following properties:
   * In *Field name*, enter the name of the SharePoint list’s column.\
     For example, column `Country`.
   * In *Comparison operator*, enter `==` for equal or `!=` for not equal.
   * In *Field value*, enter the filter value.\
     For example, enter `Canada`.
   * In *Default filter field value*, enter one of the following:

     * If your comparison operator is *==*, enter the same value that you have entered in *Field value* field.
     * If your logical operator is *!=*, enter a value that is different from the value, you have entered in *Field value* field.

     This field is required, in cases of two-way synchronizations.\
     For example, if you have set a SharePoint filter *Country == Canada*, all items in SharePoint that have their *Country* equal to *Canada* are synchronized in Sitefinity CMS. However, if you create an item in Sitefinity CMS and leave its country field empty, this item will be automatically assigned the default value *Canada*. This way, when the item is synced from Sitefinity CMS to SharePoint, it will be again synced back to Sitefinity CMS. If the item is not assigned a default value and its country field remains empty, it will be synched to SharePoint with empty *Country* field and when it is modified in SharePoint, it cannot be synced back to Sitefinity CMS, because it does not meet the filter conditions – *Country == Canada*.
3. In *Field type full name*, enter the full .NET Framework type that corresponds to the SharePoint type.\
   Sitefinity CMS supports the following types:

    <table>

<thead>
<tr>
<th>SharePoint field type</th>
<th>Full .NET Framework type name</th>
</tr>
</thead>
<tbody>
<tr>
<td>

<code>ContentTypeId</code>

</td>
<td>

<code>System.String</code>

</td>
</tr>
<tr>
<td>

<code>Text</code>

</td>
<td>

<code>System.String</code>

</td>
</tr>
<tr>
<td>

<code>Lookup</code>

</td>
<td>

<code>System.String</code>

</td>
</tr>
<tr>
<td>

<code>URL</code>

</td>
<td>

<code>System.String</code>

</td>
</tr>
<tr>
<td>

<code>Choice</code>

</td>
<td>

<code>System.String</code>

</td>
</tr>
<tr>
<td>

<code>MultiChoice</code>

</td>
<td>

<code>System.String</code>

</td>
</tr>
<tr>
<td>

<code>Note</code>

</td>
<td>

<code>System.String</code>

</td>
</tr>
<tr>
<td>

<code>Integer</code>

</td>
<td>

<code>System.Int32</code>

</td>
</tr>
<tr>
<td>

<code>Counter</code>

</td>
<td>

<code>System.Int32</code>

</td>
</tr>
<tr>
<td>

<code>ModStat</code>

</td>
<td>

<code>System.Int32</code>

</td>
</tr>
<tr>
<td>

<code>Number</code>

</td>
<td>

<code>System.Double</code>

</td>
</tr>
<tr>
<td>

<code>Currency</code>

</td>
<td>

<code>System.Decimal</code>

</td>
</tr>
<tr>
<td>

<code>DateTime</code>

</td>
<td>

<code>System.DateTime</code>

</td>
</tr>
<tr>
<td>

<code>Boolean</code>

</td>
<td>

<code>System.Boolean</code>

</td>
</tr>
<tr>
<td>

<code>Guid</code>

</td>
<td>

<code>System.Guid</code>

</td>
</tr>
</tbody>
</table>
4. Click *Save changes*.