- Docs
- API reference
- Endpoints and schemas
- GraphQL
- Selection
Selection
The fields you ask to have back.
What do I want to know about them?
The fields you ask to have back. Nothing arrives that you did not name. A number is a selection too: count, sum and the other math fields stand where a list of rows would stand.
Math fields
Section titled “Math fields”Every record answers these fields. Each one computes a number or a date over one of the record’s connections.
| Field | Arguments | Returns | Description |
|---|---|---|---|
count |
field: String!, conditions: Conditions |
Int |
Counts the related items at the field path, such as operatingLocations. If the path ends at a field, it counts the values of that field that are not null. It returns 0 when nothing matches. |
countDistinct |
field: String!, conditions: Conditions |
Int |
Counts the distinct values at the field path. If the path ends at a relationship, it counts the distinct related items. It returns 0 when nothing matches. |
has |
field: String!, conditions: Conditions |
Boolean |
Returns true when at least one related item exists at the field path, after conditions apply. |
sum |
field: String!, conditions: Conditions |
Int |
Adds up the values at the field path across the related items. It returns 0 when nothing matches. |
min |
field: String!, conditions: Conditions |
Int |
Returns the smallest value at the field path across the related items. |
max |
field: String!, conditions: Conditions |
Int |
Returns the largest value at the field path across the related items. |
avg |
field: String!, conditions: Conditions |
Float |
Returns the average of the values at the field path across the related items. |
collect |
field: String!, separator: String, conditions: Conditions |
String |
Joins the values at the field path into one string, with separator between them. The path must be one relationship and one field, and the default separator is ;. This field works only in a search with output. |
minDateTime |
field: String!, conditions: Conditions |
DateTime |
Returns the earliest date and time at the field path across the related items. |
maxDateTime |
field: String!, conditions: Conditions |
DateTime |
Returns the latest date and time at the field path across the related items. |
In this part
Section titled “In this part”BackgroundTaskSearchmetadataAttributeMetadataRankMetadataMatchedMetadataLegalEntityTieBreakerMetadataPageInfoBrandTieBreakerMetadataBrandNameWebsiteOperatingLocationTieBreakerMetadataOperatingLocationNameRegistrationRolePhoneNumberRecordPersonNameTinEmailAddressRegisteredEntityAddressDeliverabilityWatchlistEntryOperatingLocationOperatingStatusOperatingLocationTechnologiesUsedReviewSummaryOperatingLocationCardTransactionOperatingLocationRevenueQualityOperatingLocationRankOperatingLocationSeasonalityIndexOperatingLocationIsMarketableOperatingLocationLocationTypeWebsiteContentWebsiteTechnologiesUsedWebsiteOnlinePresenceBrandCardTransactionIndustryBrandReviewSummaryBrandRevenueQualityBrandSeasonalityIndexBrandLocationDescriptionBrandIsMarketableBrandActivityLegalEntityNameVerificationTierLegalEntityTypeLegalEntityBankruptcyMediaContentAggregateResultAccountListListSearchInputListConditionsListMaterializationListMaterializationMetricListMaterializationBillingEventDetailFieldAliasColumnCountColumnMappingCreateListUpdateListDeleteListCreateListMaterializationCancelListMaterializationUpdateListMaterializationCreateSuggestionSuggestionBrand projectionsOperatingLocation projectionsCustom projections