---
schema_version: "1"
id: 37ae9ecaf382cd173becbf78cdc12fd63f4633077efeffe0bbaf8283eb9b823e
title: Considerations When Converting Query Types
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_step_conversion_to_saql.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_step_conversion_to_saql.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1e9709090b91da6d714acf57529a80873060f72b59d627d9d63249af5fb2fa97
description: CRM Analytics treats query types differently. Before you convert an aggregate or aggregateflex query type to saql, review the following implications.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Considerations When Converting Query Types

CRM Analytics treats query types differently. Before you convert an `aggregate` or `aggregateflex` query type to `saql`, review the following implications.

Unlike the `aggregateflex` query type, the `saql` query type provides limited support when the actual number of query results exceeds the limit that a query can return.

- When performing a search in a list widget, a `saql` query type doesn’t find values that aren’t returned in the first batch of query results.
    
    ![The search bar appears above the list of values.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_dashboards_remotesearch_textsearch.png)
- CRM Analytics doesn’t apply initial selections for a `saql` query type if the selected value isn’t returned in the first batch of query results. For example, you set an initial selection on the Account Name field. When you open the dashboard, assume the corresponding widget shows only 2,000 of 100,000 accounts. If the initial selection isn’t one of the 2,000 returned accounts, CRM Analytics doesn’t apply the initial selection to the dashboard.

For more information about how to use the `limit` JSON parameter to configure the maximum number of results that each query type can return, see [steps JSON](https://developer.salesforce.com/docs/analytics/bi-dev-guide-json/guide/bi-dbjson-steps-properties.html).