public final class JoinSpec


This class represents the specifications for the joining operation in search.

Joins are only possible for matching on the qualified id of an outer document and a property value within a subquery document. In the subquery documents, these values may be referred to with a property path such as "email.recipient.id" or "entityId" or a property expression. One such property expression is "this.qualifiedId()", which refers to the document's combined package, database, namespace, and id.

Note that in order for perform the join, the property referred to by getChildPropertyExpression has to be a property with getJoinableValueType set to JOINABLE_VALUE_TYPE_QUALIFIED_ID. Otherwise no documents will be joined to any SearchResult.

Take these outer query and subquery results for example:

Outer result {
  id: id1
  score: 5
}
Subquery result 1 {
  id: id2
  score: 2
  entityId: pkg$db/ns#id1
  notes: This is some doc
}
Subquery result 2 {
  id: id3
  score: 3
  entityId: pkg$db/ns#id2
  notes: This is another doc
}

In this example, subquery result 1 contains a property "entityId" whose value is "pkg$db/ns#id1", referring to the outer result. If you call Builder with "entityId", we will retrieve the value of the property "entityId" from the child document, which is "pkg$db#ns/id1". Let's say the qualified id of the outer result is "pkg$db#ns/id1". This would mean the subquery result 1 document will be matched to that parent document. This is done by adding a SearchResult containing the child document to the top-level parent getJoinedResults.

If getChildPropertyExpression is "notes", we will check the values of the notes property in the subquery results. In subquery result 1, this values is "This is some doc", which does not equal the qualified id of the outer query result. As such, subquery result 1 will not be joined to the outer query result.

It's possible to define an advanced ranking strategy in the nested SearchSpec and also use RANKING_STRATEGY_JOIN_AGGREGATE_SCORE in the outer SearchSpec. In this case, the parents will be ranked based on an aggregation, such as the sum, of the signals calculated by scoring the joined documents with the advanced ranking strategy.

In terms of scoring, if RANKING_STRATEGY_JOIN_AGGREGATE_SCORE is set in getRankingStrategy, the scores of the outer SearchResults can be influenced by the ranking signals of the subquery results. For example, if the getAggregationScoringStrategy is set to:

Referring to "this.childrenRankingSignals()" in the ranking signal of the outer query will return the signals calculated by scoring the joined documents using the scoring strategy in the nested SearchSpec, as in getRankingSignal.

Summary

Nested types

public final class JoinSpec.Builder

Builder for objects.

Constants

static final int

Score the aggregation of joined documents using the average ranking signal.

static final int

Score the aggregation of joined documents using the largest ranking signal.

static final int

Score the aggregation of joined documents using the smallest ranking signal.

static final int

Do not score the aggregation of joined documents.

static final int

Score the aggregation of joined documents by counting the number of results.

static final int

Score the aggregation of joined documents using the sum of ranking signal.

Public methods

int

Gets the joined document list scoring strategy.

@NonNull String

The property expression that is used to get values from child documents, returned from the nested search.

int

Returns the max amount of SearchResult objects to return with the parent document, with a default of 10 SearchResults.

@NonNull String

Returns the query to run on the joined documents.

@NonNull SearchSpec

Returns the search spec used to retrieve the joined documents.

Constants

AGGREGATION_SCORING_AVG_RANKING_SIGNAL

Added in 1.1.0-alpha06
public static final int AGGREGATION_SCORING_AVG_RANKING_SIGNAL = 3

Score the aggregation of joined documents using the average ranking signal.

AGGREGATION_SCORING_MAX_RANKING_SIGNAL

Added in 1.1.0-alpha06
public static final int AGGREGATION_SCORING_MAX_RANKING_SIGNAL = 4

Score the aggregation of joined documents using the largest ranking signal.

AGGREGATION_SCORING_MIN_RANKING_SIGNAL

Added in 1.1.0-alpha06
public static final int AGGREGATION_SCORING_MIN_RANKING_SIGNAL = 2

Score the aggregation of joined documents using the smallest ranking signal.

AGGREGATION_SCORING_OUTER_RESULT_RANKING_SIGNAL

Added in 1.1.0-alpha06
public static final int AGGREGATION_SCORING_OUTER_RESULT_RANKING_SIGNAL = 0

Do not score the aggregation of joined documents. This is for the case where we want to perform a join, but keep the parent ranking signal.

AGGREGATION_SCORING_RESULT_COUNT

Added in 1.1.0-alpha06
public static final int AGGREGATION_SCORING_RESULT_COUNT = 1

Score the aggregation of joined documents by counting the number of results.

AGGREGATION_SCORING_SUM_RANKING_SIGNAL

Added in 1.1.0-alpha06
public static final int AGGREGATION_SCORING_SUM_RANKING_SIGNAL = 5

Score the aggregation of joined documents using the sum of ranking signal.

Public methods

getAggregationScoringStrategy

Added in 1.1.0-alpha06
public int getAggregationScoringStrategy()

Gets the joined document list scoring strategy.

The default scoring strategy is AGGREGATION_SCORING_OUTER_RESULT_RANKING_SIGNAL, which specifies that the score of the outer parent document will be used.

getChildPropertyExpression

Added in 1.1.0-alpha06
public @NonNull String getChildPropertyExpression()

The property expression that is used to get values from child documents, returned from the nested search. These values are then used to match them to parent documents. These are analogous to foreign keys.

Returns
@NonNull String

the property expression to match in the child documents.

See also
JoinSpec.Builder

getMaxJoinedResultCount

Added in 1.1.0-alpha06
public int getMaxJoinedResultCount()

Returns the max amount of SearchResult objects to return with the parent document, with a default of 10 SearchResults.

getNestedQuery

Added in 1.1.0-alpha06
public @NonNull String getNestedQuery()

Returns the query to run on the joined documents.

getNestedSearchSpec

Added in 1.1.0-alpha06
public @NonNull SearchSpec getNestedSearchSpec()

Returns the search spec used to retrieve the joined documents.

If setNestedSearch is never called, this will return a SearchSpec with all default values. This will match every document, as the nested search query will be "" and no schema will be filtered out.