---
title: entities.leadOpptyDataExRelation
description: Read lead oppty data ex relation records with the leadOpptyDataExRelation repository, and change them with the lead oppty data ex relation mutations. Same records as the REST LeadOpptyDataExRelations entity.
canonical: https://developers.coevera.com/reference/graphql/lead-oppty-data-ex-relation/
section: graphql
verification: schema
generatedFrom: schema f155746 (2026-10-20)
publisher: Coevera
---

# entities.leadOpptyDataExRelation

Read lead oppty data ex relation records with the leadOpptyDataExRelation repository, and change them with the lead oppty data ex relation mutations. Same records as the REST LeadOpptyDataExRelations entity.

REST: [LeadOpptyDataExRelations](https://developers.coevera.com/reference/rest/lead-oppty-data-ex-relations.md).

## Queries

- `getById(entityId: ID!): LeadOpptyDataExRelationEntity` Returns the record with the given id, or null when there is none. Deleted records are returned as well.
- `getByIds(entityIds: [ID!]!): [LeadOpptyDataExRelationEntity!]!` Returns the records with the given ids; ids without a record are left out. Deleted records are returned as well.
- `getAll(limit: Int, offset: Int, filter: LeadOpptyDataExRelationFilterInput, orderBy: [LeadOpptyDataExRelationOrderByInput!], includeDeleted: Boolean): [LeadOpptyDataExRelationEntity!]!` Returns the records that match the filter, paged with limit and offset.
- `getByCriteria(filter: LeadOpptyDataExRelationFilterInput, orderBy: [LeadOpptyDataExRelationOrderByInput!], includeDeleted: Boolean, before: String, after: String, first: Int, last: Int): LeadOpptyDataExRelationEntityConnection` Returns the records that match the filter as a cursor-paginated connection.
- `getChangedFieldsSinceRevision(id: UUID!, revision: Int!): [UUID!]!` Returns the ids of the fields of a record that changed after the given revision. Returns an empty list for entities without change tracking.

## Types

### LeadOpptyDataExRelationEntity (object)

Option selected in a multi-select checkbox field of a lead or opportunity.

- `isDeleteProtected: Boolean!` True when the record is protected against deletion because it must always exist in the space. Deleting a record that is not protected can still fail on other checks. Read-only.
- `id: ID!` Unique identifier of entity.
- `isDeleted: Boolean` Specifies if the entity is considered deleted.
- `modified: DateTime` Last modification time.
- `created: DateTime` Creation time.
- `data: DataEntity` Option selected in the multi-select field; it belongs to the data set given by dataSetId.
- `lead: LeadEntity` Lead on which the option is selected; empty when leadOpptyId is an opportunity.
- `oppty: OpportunityEntity` Opportunity on which the option is selected; empty when leadOpptyId is a lead.
- `dataId: ID!` Id of the selected option.
- `dataSetId: ID!` Id of the data set (the option list of a multi-select field) the selected option belongs to.
- `leadOpptyId: ID!` Id of the lead or opportunity on which the option is selected.
- `revision: Int` Revision when entity was lastly changed.
- `instancePermissions: [EntityPermsEnum!]! (1 args)` Permissions the current user has on this record, out of the requested ones.

### LeadOpptyDataExRelationEntityConnection (object)

Paginated list of LeadOpptyDataExRelation records.

- `pageInfo: PageInfo!` Pagination data for this connection.
- `edges: [LeadOpptyDataExRelationEntityEdge]!` Contains the nodes in this connection.
- `totalCount: Int` Total number of items in the connection.

### LeadOpptyDataExRelationEntityEdge (object)

A Relay edge containing a `LeadOpptyDataExRelationEntity` and its cursor.

- `node: LeadOpptyDataExRelationEntity` The item at the end of the edge
- `cursor: String!` A cursor for use in pagination

### LeadOpptyDataExRelationFilterInput (input)

Filter conditions for LeadOpptyDataExRelation records. Conditions on different fields are combined with AND; use OR, AND and NOT for other combinations.

- `OR: [LeadOpptyDataExRelationFilterInput!]` Matches records that meet at least one of the listed filters.
- `AND: [LeadOpptyDataExRelationFilterInput!]` Matches records that meet all of the listed filters.
- `NOT: LeadOpptyDataExRelationFilterInput` Matches records that do not meet this filter.
- `globalSearchQuery: String` Search term matched against the fields that the global search covers for this entity.
- `id: EntityFilterStringField` Unique identifier of entity.
- `isDeleted: Boolean` Specifies if the entity is considered deleted.
- `modified: EntityFilterDateTimeField` Last modification time.
- `created: EntityFilterDateTimeField` Creation time.
- `dataId: EntityFilterStringField` Id of the selected option.
- `dataSetId: EntityFilterStringField` Id of the data set (the option list of a multi-select field) the selected option belongs to.
- `leadOpptyId: EntityFilterStringField` Id of the lead or opportunity on which the option is selected.
- `revision: EntityFilterNumberField` Revision when entity was lastly changed.
- `data: DataFilterInput` Option selected in the multi-select field; it belongs to the data set given by dataSetId. Matches records where a related record meets these conditions.
- `lead: LeadFilterInput` Lead on which the option is selected; empty when leadOpptyId is an opportunity. Matches records where a related record meets these conditions.
- `oppty: OpportunityFilterInput` Opportunity on which the option is selected; empty when leadOpptyId is a lead. Matches records where a related record meets these conditions.

### LeadOpptyDataExRelationOrderByInput (input)

Sorting of LeadOpptyDataExRelation records. Set exactly one field in each item; list several items to sort by more fields, in order of priority.

- `id: OrderByEnum` Unique identifier of entity.
- `isDeleted: OrderByEnum` Specifies if the entity is considered deleted.
- `modified: OrderByEnum` Last modification time.
- `created: OrderByEnum` Creation time.
- `data: [DataOrderByNestedInput!]` Option selected in the multi-select field; it belongs to the data set given by dataSetId. Sorts by fields of the related record, listed in order of priority.
- `lead: [LeadOrderByNestedInput!]` Lead on which the option is selected; empty when leadOpptyId is an opportunity. Sorts by fields of the related record, listed in order of priority.
- `oppty: [OpportunityOrderByNestedInput!]` Opportunity on which the option is selected; empty when leadOpptyId is a lead. Sorts by fields of the related record, listed in order of priority.
- `dataId: OrderByEnum` Id of the selected option.
- `leadOpptyId: OrderByEnum` Id of the lead or opportunity on which the option is selected.
- `revision: OrderByEnum` Revision when entity was lastly changed.

Types several repositories share, such as `PageInfo` and the filter fields, are in the [types index](https://developers.coevera.com/reference/graphql/types.md). The [SDL](https://developers.coevera.com/graphql/schema.graphql) has the whole schema in one file.

## Example

```graphql
query FirstLeadOpptyDataExRelations {
  entities {
    leadOpptyDataExRelation {
      getByCriteria(first: 3, orderBy: [{ modified: Desc }]) {
        totalCount
        edges { node { id modified } }
      }
    }
  }
}
```

```bash
curl 'https://{region}.api.coevera.com/api/v100/app/space/{space_id}/graphql/public' \
  --user "$COEVERA_API_KEY:$COEVERA_API_SECRET" \
  --header 'Content-Type: application/json' \
  --data '{"query":"query FirstLeadOpptyDataExRelations { entities { leadOpptyDataExRelation { getByCriteria(first: 3, orderBy: [{ modified: Desc }]) { totalCount edges { node { id modified } } } } } }"}'
```