Query Settings
Drupal 7 will no longer be supported after January 5, 2025. Learn more and find resources for Drupal 7 sites
Some Views may contain duplicate results. There is an option that can help remove duplicates. Open up the "Advanced" section of the view's administration page and in the "Other" section are "Query Settings".
Here there is a checkbox for "Distinct" and another one that appears if it is checked, "Pure Distinct". It may not be clear which to use, but for a new view, it is best to check both options. Some sites that have upgraded from a previous version of Views may have problems with pure distinct, so this option is disabled by default.
Help improve this page
You can:
- Log in, click Edit, and edit this page
- Log in, click Discuss, update the Page status value, and suggest an improvement
- Log in and create a Documentation issue with your suggestion