Styjun

how to write the below mnonodb query in the matchoperation I have tried the options $exists but did not get the desired results hence raised it.
so the solution is definitely different to the links referred to mark it as duplicate.

db.rsc_installtion_status.aggregate([
 $lookup :
 
 from:"vmdetails",
 localField:"hostname",
 foreignField:"hostname" ,
 as:"rscinstall"
 
 ,
 
 $match: "rscinstall": $eq: [] 
 
 ])

so far the code which i have is

LookupOperation lookupOperation = LookupOperation.newLookup().from("vmdetails").localField("hostname").foreignField("hostname").as("rscInstall");

i am not able to put the match criteria

 MatchOperation matchOperation = Aggregation.match(Criteria.where("rscinstall").equals(null));

Updated Answer -- I have tried the options which

 String lookupquery = "$lookup :from:"vmdetails",localField:"hostname",foreignField:"hostname"as:"rscinstall"";
 String matchquery = " $match: "rscinstall": $eq: [] ";
 String projectquery = "$project:"rscinstall":0";
 String outquery = "$out:to:"RscInstallArchive", mode: "replaceDocuments"";

 AggregationOperation lookupOpertaion = new CustomProjectAggregationOperation(lookupquery);
 AggregationOperation matchOperation = new CustomProjectAggregationOperation(matchquery);
 AggregationOperation projectOperation = new CustomProjectAggregationOperation(projectquery);
 AggregationOperation outOperation = new CustomProjectAggregationOperation(outquery);
 Aggregation aggregation = Aggregation.newAggregation(lookupOpertaion, matchOperation,projectOperation);

Custom Aggregation

public class CustomProjectAggregationOperation implements AggregationOperation 

private String jsonOperation;

public CustomProjectAggregationOperation(String jsonOperation) 
 this.jsonOperation = jsonOperation;


@Override
public Document toDocument(AggregationOperationContext aggregationOperationContext) 
 return aggregationOperationContext.getMappedObject(Document.parse(jsonOperation));