Information générale
Titre:
Using a HAVING in view builder
Hi all,
I seem to be missing something when trying to use the view builder. Here is what I want to add to a SELECT to show a customer with 3 or more records in the customer table:
GROUP by customer_id HAVING count(*) > 2
The view builder's "having" builder allows me to enter the "count(*)" in the field name expression, the ">" in the comparison field and the "2" in the example field. It just won't allow me to save. Any suggestions?
Gary Foster
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement