# Query

## Introduction

A query allows you to select a target based on specific criteria. You can associate a segment code with the query results and insert additional data into it. By customizing the search parameters, you can obtain query results tailored to your criteria for work items. A query consists of various conditions that define your search, bringing results in line with the set parameters.

### Query Creation Process

Example Query: Get Salesforce Accounts and print using **Debug**.

1. **Configure the Query:** Drag and drop a **Flow** action. Click **Configure** and provide a description for the flow (e.g., Get SF Accounts Information).

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2F11RzfysrBYmtb43rfzIx%2Fimage.png?alt=media&#x26;token=0559176a-16f3-47bb-8a8e-dae7cfec7f34" alt=""><figcaption></figcaption></figure>

2. Drag and drop a **Query** action. Click **Configure**, select the **Source** as **Salesforce**, and **Object** as **Account**.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FjYOzUj4SRs3ZY0SNyEc3%2Fimage.png?alt=media&#x26;token=f100ca6e-3305-467a-80de-42c8e3d5e3f9" alt=""><figcaption></figcaption></figure>

3. In the configure query section, select **All fields** or choose individual Salesforce fields. Select **All Fields**.
4. **Preview the Results:** Click **Preview** from the **Configure Query** section. The Salesforce objects will be displayed as **Rows** in the **Result** section.
5. **Debug the Query:** Drag and drop a **Debug** action. Click **Configure** and define the variable.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2FzqUOkuc1Ol3rKiJHby5B%2Fimage.png?alt=media&#x26;token=2a13710e-8478-4e83-b6d2-f07f4d5956d5" alt=""><figcaption></figcaption></figure>

6. Click the **fx** icon to access the schema, then drag and drop the **name** schema onto the debug panel. Select the correct **Name** field to display the Salesforce account names.

{% hint style="info" %}
**PRO TIP**

When using the **Debug** action, ensure you select the correct field schema to avoid confusion and ensure accurate data output.
{% endhint %}

#### Run the Integration:

7. Click the **Close** icon and **Save**.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2Fj21VpGNToQ4Njyi8hq1d%2Fimage.png?alt=media&#x26;token=d1ba531c-c07f-4e22-970a-0860a7474d82" alt=""><figcaption></figcaption></figure>

8. Click the **Run** icon to execute the integration.
9. The console will display the executed query and print the Salesforce Account Names.

<figure><img src="https://1036205596-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fv9avy716UiAsS24zOznZ%2Fuploads%2Fax0oWqep7V3d6vZnXdD7%2Fimage.png?alt=media&#x26;token=bb9ae4b0-6534-4dd4-ac6b-e69149adc519" alt=""><figcaption></figcaption></figure>

<details>

<summary>Frequently Asked Questions (FAQ)</summary>

#### 1. Can I use multiple conditions in a single query?

Yes, you can create queries with various conditions to customize your search parameters and obtain results based on specific criteria.

#### 2. How do I preview the results of a query before executing it?

Click the 'Preview' option in the 'Configure Query' section to display all relevant objects in the results section before executing the query.

#### 3. What are the benefits of using queries in workflows?

Queries allow users to select targets based on criteria, customize search parameters, and associate segment codes with query results, enabling efficient data management and workflow automation.

#### 4. What are the different data sources I can query from?

You can query from various data sources, including Salesforce and other JDBC-compliant databases like MySQL, Oracle, and DB2.

#### 5. Can I combine data from multiple objects or tables in a single query?

Yes, you can combine data from multiple objects or tables in a single query in DBSync Cloud Workflow, allowing you to pull and analyze data from different sources simultaneously.

</details>

## Related Content

* [Log Management](https://docs.mydbsync.com/cloud-workflow/dbsync-platform/administration/logs) - This section explains how to manage and view logs in DBSync, helping you troubleshoot and monitor integration processes.
* [Transformation Examples](https://docs.mydbsync.com/cloud-workflow/flow-builder/transform-and-write) - This page offers examples of how to use query transformations in your integration projects within DBSync.