public string GetDocumentId()

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;
        }