---
title: "Applying Column & Row level filters"
description: "In Eightwire there are several options to restrict the data that is available in a shared datastore without changing the source data structure."
url: "https://eightwire.io/knowledge-base/applying-column-row-level-filters/"
category: "Architecture"
generated: "2026-09-16"
---
# Applying Column & Row level filters

> In Eightwire there are several options to restrict the data that is available in a shared datastore without changing the source data structure.

## Datastore options: Row level filters

**Browse a Datastore** to view an object to apply row level filters.

![Datastore object Filter tab with the Edit Filter popup: Copy data when is equal to Health Provider A, with Ok and Do not filter buttons](https://eightwire.io/_astro/applying-column-row-level-filters-1.BiY3gMP__8Q1mB.webp)

![Decorative horizontal divider line (1600x19 px); no UI content](https://eightwire.io/_astro/applying-column-row-level-filters-2.DYOwF2Ui_63CK1.webp)

## Datastore options: Column level filters

To restrict a **column** from being used in a process, simply untick the 'Use' checkbox and **Save**.

![Datastore Structure tab: the Use checkbox column is highlighted, the CODE row is unticked (marked orange), and the Save button is below](https://eightwire.io/_astro/applying-column-row-level-filters-3.BogR7yRb_Z2bIF40.webp)

The restricted column appears unavailable (marked **Do Not Use**) and cannot be mapped to a destination column.

![Process Mapping panel with CODE listed under Unused source columns and marked Do not use, below the Mapped Columns list](https://eightwire.io/_astro/applying-column-row-level-filters-4.CivnfV46_ZzNjca.webp)

Unmapped columns will not be written to the destination.

A process can be executed successfully - even when source columns are not mapped to a destination.

![Unmapped System Columns showing LastUpdateTime BatchExecuteDate beside Unmapped Destination Columns showing LastUpdateDatTime DATETIME](https://eightwire.io/_astro/applying-column-row-level-filters-5.B3WPx1XM_Z2bOxxR.webp)

## Datastore Queries

Source Datastores connecting to relational databases have a Query tab available which allow you to create custom views of the data to share.

This is a way to apply column level filtering to the data presented in a Datastore.

![Datastore Queries tab, 1 Data Query: Name field Match NGO Candidates to Ministry Clients above a SQL Query editor with a SELECT](https://eightwire.io/_astro/applying-column-row-level-filters-6.Ceduygh-_fKcwg.webp)

## Process filters

Apply a **filter** within a process to control the rows written to a destination.

![Editing Process Mapping panel: the filter icon on the SchemeStatus TEXT mapped column is highlighted with the Add filter tooltip](https://eightwire.io/_astro/applying-column-row-level-filters-7.Cojby3ck_JNHfg.webp)

> *A column does not have to be mapped for a filter to be applied to a dataset*