---
title: "Building Dynamic Queries via Merge Text"
slug: "building-dynamic-queries-via-merge-text"
updated: 2022-11-28T21:22:30Z
published: 2022-11-28T21:22:30Z
canonical: "documentation.decisions.com/building-dynamic-queries-via-merge-text"
---

> ## 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.

# Building Dynamic Queries via Merge Text

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.16.1 |
| **Root Folder** | Example Lab - Building Dynamic Queries via Merge Text |
| **Modules** | None |
| **Dependencies** | None |

This Example Lab demonstrates how to merge text when handling string lists using the Raw SQL and Join Strings steps.

---

## Explanation

In this example, the Flows below demonstrate how to merge text when handling string lists. The Flows below take in an email address as input, then runs a query to return any matching results.

Reference Articles[Raw SQL Step](https://documentation.decisions.com/docs/raw-sql-step)  
[Custom Merge [NVelocity]](https://documentation.decisions.com/step-library/docs/custom-merge-nvelocity)

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1628533313925.png)

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1628533372166.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.16.1 or later using our [Importing/Exporting](https://documentation.decisions.com/docs/importing-and-exporting-projects) article.  
  
[ExampleLab[DynamicQuery].zip](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/ExampleLab%5BDynamicQuery%5D.zip)