---
schema_version: "1"
id: 031342bc7d53d92d8fb74a57922b66777996920f481086575a87193c78ed6465
title: Qualifier Options for Salesforce Connect Adapter for GraphQL
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/graphql_qualifiers_options.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.graphql_qualifiers_options.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ff5cbc7bcef2e7780dddfdbd594e0b228a3cc63d6b73d0f9d12fb41f923a250b
description: We recommend you use the default global id in the GraphQL schema to construct the external ID of an external object.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Qualifier Options for Salesforce Connect Adapter for GraphQL

We recommend you use the default global id in the GraphQL schema to construct the external ID of an external object.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition">
      <colgroup>
        <col>
      </colgroup>
      <tbody>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic and Lightning Experience (not for high-data-volume
            external objects)</td>

        </tr>
        <tr class="">
          <td class="slds-cell-wrap" style="vertical-align:top;">
            <p>Available in: <strong>Developer</strong> Edition</p>
            <p style="margin-bottom:0;">Available for an extra cost
              in: <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong>
              Editions</p>
          </td>

        </tr>
      </tbody>
    </table>

```
TableQualifier ::= 
    "tableName": "phyiscalTableName" |
    "keyColumns": [" keyColumnName"(, "keyColumnName")*] ||
    "columns": {NamedColumnQualifier(, NamedColumnQualifier)*}     

NamedColumnQualifier ::= 
    "columnName": {ColumnQualifier(, ColumnQualifier)*}

ColumnQualifier ::=
    "virtual": (true | false) |
    "values": [ValueDefinition(, ValueDefinition)*]
    
ValueDefinition ::=
    {ValueQualifier,( ValueQualifier)*} 

ValueQualifier ::=         
    "definition": "functionDefinition" |
    "columnOrder": ["columnName"(, "columnName")*]
```

- `TableQualifier`: Specific set of properties that are used to identify a table.
- `NamedColumnQualifier`: Default value for the columnName is `NamedColumnQualifier`’s column name. If the `ColumnQualifier` is virtual, `columnName` is not specified.
- `ColumnQualifier`
    - `virtual`: If true, the field doesn't physically exist in the external data source. Default value is _false_. Virtual fields are defined using the `values` formula.
    - `values`: A list of candidate Salesforce formula functions that derive the field value from other fields.
- `ValueDefinition`: Contains an array of value qualifiers.
- `ValueQualifier`
    - `definition`: A candidate value defined using Salesforce formula functions. A formula function can be a constant expression or can depend on one or more field values.
    - `columnOrder`: The lexical field order of the derived field value. The lexical order determines the field sort order in SOQL.

![Example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_example.png)

Example

This is a sample table qualifier generated for an external ID based on the `id` field of the MyOrder table.

```
{
    "columns": {
        "ExternalId": {
            "virtual": true,
            "values": [
                {
                    "definition": "SUBSTITUTE(RIGHT(id,LEN(id)-17),"\\\\-","-")"
                }
            ]
        },
        "id": {
            "values": [
                {
                    "definition": ""Postgres_MyOrder-"&SUBSTITUTE(ExternalId,"-","\\\\-")"
                }
            ]
        }
    }
}
```

#### See Also

- [Manage Qualifiers and External IDs for Salesforce Connect Adapter for GraphQL](https://help.salesforce.com/s/articleView?id=platform.graphql_manage_qualifiers_extids.htm&release=264.0.0&type=5 "When you sync a database table to create a Salesforce external object, a table qualifier is automatically generated. The qualifier constructs an external ID for the external object based on the global id field in the GraphQL schema. You can also configure the external ID based on any of the ID field types in the GraphQL schema.")