Views query: do not show rows where column value is unique.

By admin , 26 October, 2024

Tags

views

/**
* Implements hook_views_query_alter().
*/
function MYMODULE_views_query_alter(ViewExecutable $view, QueryPluginBase $query) {
 // Do not show rows where CID is unique.
 if ($view->id() === 'MYVIEW_default') {
   $where_clause = 'cid IN (SELECT cid FROM {YOUR_TABLE_NAME} GROUP BY cid HAVING COUNT(*) > 1)';
   $query->setWhereGroup('OR', 0);
   $query->addWhereExpression(0, $where_clause);
 }
}