Unify and manage your data

Relationship fields indexed for Elastic search

Learn more about the fields that are indexed for Elastic search.

Let's take a look at a list of fields that are indexed for relations. The following table lists these fields:

FieldTypeEntity Mapping (RelationTO)DescriptionPresent by default?Example - how to filter
idkeyword$.uri (short)Relationship IDYesequals(id,'relations/00Eusjv')
timestampdate$.createdTimeYesgt(timestamp,1694167276)
typekeyword$.type.uri (short)Relationship typeYesequals(type,'configuration/relationTypes/Family')
tagstext_multifields$.tagsNocontains(tags,'ANY_TAG')
attributesobject$.attributes.{attributeName}Collection of the relationship attributesYes

Specific attribute:

startsWith(attributes.FirstName,'YO')

Search over all attributes:

equals(attributes,'CLOSED')

attributes_end_datedate$.crosswalks.deleteDateDate when relation stops being activeNogt(attributes_end_date,'1622487600000')
__locationgeo_point$.type.geoAttributesNoexists(__location)
geoLocationgeo_shape$.type.geoAttributesRelationship geolocation attributeNorange(geoLocation,'12.43,64.85','1')
businessProcessDataobject$.businessProcessDataCollection of attributes related to business processesNorange(businessProcessData.ANY_ATTR,'15','18')
consolidatedRatingtext$.consolidatedRatingNogt(consolidatedRating,'10')
startObjecttext$.startEntityURI (short URI)ID of startObject entityYesequals(startObject,'entities/130xSPbo')
endObjecttext$.endEntityURI (short URI)ID of endObject entityYesequals(endObject,'entities/130xSPbo')
crosswalks_countlong$.crosswalks.size()Count of crosswalksYesgt(crosswalks_count,'10')