<PackageReference Include="Relativity.API" Version="19.5.0" />

ScratchTableSubQuery

public class ScratchTableSubQuery : BaseFieldCondition
A condition that filters based on values found in a scratch table.
public Condition Condition { get; set; }

An optional condition to be used to filter the scratch table.

public string KeyFieldName { get; }

The name of the column of the key field. The key field should contain the Artifact IDs to match against for filtering.

public IScratchTableInfo ScratchTable { get; }

The scratch table with the identifiers for filtering.

public ScratchTableSubQuery(IFieldRef fieldRef, IScratchTableInfo scratchTable, string keyFieldName)

A condition on a field identified by IFieldRef that filters the identifier by the values in the KeyFieldName of the scratch table.

public ScratchTableSubQuery(string fieldName, IScratchTableInfo scratchTable, string keyFieldName)

A condition on a field identified by name that filters the identifier by the values in the KeyFieldName of the scratch table.

public ScratchTableSubQuery(Guid fieldGuid, IScratchTableInfo scratchTable, string keyFieldName)

A condition on a field identified by Guid that filters the identifier by the values in the KeyFieldName of the scratch table.