We need to create a smart query in which users can filter by a number of recognition credit fields, including a SUM value for the total amount of recognitions received by each constituent. We need to see one row of results for each constituent - no duplicates. By necessity, since we need a SUM value for constituent recognitions, we need to use a constituent ad-hoc query source view. However, in order to set a field as a smart query filter, it has to be included as an output field in the original ad-hoc query. As soon as we include a recognition credit field in the output, we start seeing duplicates in the results, since most constituents have multiple recognition credits. So, we need to be able to create a ad-hoc query with the filters we need, and then build a smart query where we choose filters that were not part of the output in the original query.