in Amazon.QLDB.DMVSample.Api/Services/MetadataService.cs [36:44]
public string GetDocumentId(TransactionExecutor transactionExecutor, string tableName, string identifer, string value)
{
IIonValue ionValue = this.valueFactory.NewString(value);
IResult selectResult =
transactionExecutor.Execute($"SELECT metadata.id FROM _ql_committed_{tableName} AS p WHERE p.data.{identifer} = ?", ionValue);
IEnumerable<string> documentIds = selectResult.Select(x => x.GetField("id").StringValue).ToList();
return documentIds.Any() ? documentIds.First() : string.Empty;
}