Query Settings

Last updated on
1 December 2016

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

Page status: No known problems

You can: