Nsryjdtyk

i have seen other threads for this kind of question but none of the highlighted answers work for me.

The piece of code that throws the error is this

List<Distribution> distributionPublishQueueList = (mongoDb.GetCollection<Distribution>().Find(Builders<Distribution>.Filter.And(

            Builders<Distribution>.Filter.Where(x => x.Status == EntityStatus.Ok),

            Builders<Distribution>.Filter.Where(x => x.IsActive),

            Builders<Distribution>.Filter.Where(x => distinctDistributionIdInPublishQueueList.Contains(x.Id))))).ToList();

The original code was this:

List<Distribution> distributionPublishQueueList = 

   (await mongoDb.GetCollection<Distribution>()

       .FindAsync(x => x.Status == EntityStatus.Ok 

                    && x.IsActive

                    && distinctDistributionIdInPublishQueueList.Contains(x.Id)))

      .ToList();

but i tried to make it more mongo friendly. Both pieces of code above are the same. The list distinctDistributionIdInPublishQueueList is a list of distribution Id's which are strings. So i am trying to find all distributions which Id is inside of that list + the other 2 filters. When i use the contains inside of the filter definition it throws an Unsupported filter exception. But the following code works because i bring the list into local memory and use LINQ against it:

List<Distribution> distributionPublishQueueList = (await mongoDb.GetCollection<Distribution>().FindAsync(x => x.Status == EntityStatus.Ok && x.IsActive)).ToList();

distributionPublishQueueList = distributionPublishQueueList.Where(x => distinctDistributionIdInPublishQueueList.Contains(x.Id)).ToList();

I need to be able to not do this in local memory due to the amount of Distributions that are present in the database. Is there a workaround to using Contains and Any. I have also tried using MongoCSharpDriver In statement and Builders.Filter.In and other variations.

An example error would be as follows. This is the code that is used.

List<Asset> assetList = (await mongoDb.GetCollection<Asset>().FindAsync(

asset => extractAssetsFromContentService.ExtractAssetFromDraftContent(contentAsMarkdown)

.Any(extractedAsset => extractedAsset.AssetId == asset.Id))).ToList();

System.ArgumentException : Unsupported filter: Any(value(System.Collections.Generic.List`1[DocWorks.Common.Transformation.Model.ExtractedAssetModel]).Where(({document}{AssetId} == {document}{_id}))).

this would be the same error except the Any would be 'Contains' when using contains instead of any. Similar to a distribution i cannot bring the assets into local memory. All entities share the same base class which Stores the Ids as follows:

 [BsonRepresentation(BsonType.ObjectId)]

 public string Id { get; set; }