I've set up a database view that joins two tables and sets the where condition, but I'd eventually like to do this by group by in the case of two tables one-to-many, but apparently the where clause column of the database view doesn't work with SQL, so group by doesn't work.
So I tried to apply business rule on this database view, set before and query,
I used group by in the script field, but it seems that the business rule doesn't work because the before query of the business rule doesn't work on the before query of the database view. Is it because the before query of the business rule can't intervene in the content of the databaseview? Is there any way to solve this?
