---
title: "Bulk Deleting Flow Data"
slug: "bulk-deleting-flow-data"
updated: 2021-03-12T15:06:15Z
published: 2021-03-12T15:06:15Z
canonical: "documentation.decisions.com/bulk-deleting-flow-data"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Bulk Deleting Flow Data

Example Lab ArticleWhile Example Lab projects are resources for public use, articles and assets are not actively maintained. Screenshots and features are from the specified version below. These references may become dated as new versions are released.

---

## Overview

| ## Example Lab Details |
| --- |
| **Version** | 6.4.0 |
| **Root Folder** | Example Lab - Clear Stored Work Flows |
| **Modules** | None |
| **Dependencies** | None |

This Example Lab project demonstrates how to bulk delete Flow data stored in the WorkFlow.

---

## Explanation

This project contains a Flow that uses the Get All step in order to obtain a list of Flow data from the WorkFlow. The output data from the Get All step is then passed into a ForEach Step. The ForEach step then iterates through each item in the list and deletes it. Each item is deleted by using the Raw SQL Step. The Raw SQL Step contains the command "delete FROM flow_state_storage_data where flow_tracking_id='Item.primary_flow_tracking_id'" which deletes each item run through the ForEach step.

Reference Articles[Raw SQL Step](https://documentation.decisions.com/docs/en/raw-sql-step)  
[ForEach Step](https://documentation.decisions.com/docs/en/processing-lists-of-items-with-the-foreach-step)

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/Screen%20Shot%202020-09-29%20at%2010.16.35%20AM.png)

---

## Project Download

The examples attached were developed to be instructional and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact services@decisions.com. Import the project below to a Decisions environment on version 6.4.0 or later using our [Importing/Exporting](https://documentation.decisions.com/docs/exporting-and-importing-overview) article.  
  
  
[ExampleLab[ClearStoredWorkFlows].zip](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/ExampleLab%5BClearStoredWorkFlows%5D.zip)

---