Add filter to delphi master table depending if value is found in detail

I have a Delphi Program that displays data from a Mongo table hosted at mLab Master and Details in devexpress grid, detail are part of a sub-document from master. Not all values are in all subdocuments. I would want to add filters to show or not to show master’s rows depending if a value is true or false or found or not found in the detail sub document. The way to do this would first need to compile a list of all the values in the detail label. And adding a Intuitive GUI to enable this filter. With time new subdocuments may be added and it should automatically be added to filter Please include blueMagic in your response and don’t bid over a hundred. I would send you a link to the current program.