Read only view objects based on a group by clause using named view criteria
G'day.
I have a read only view object which selects eight columns from three tables.
As well, I have an order by clause declared below.
There is also a group by clause which groups on 7 of the columns.
Now, I wish to declare a named view criteria on the view object and make use of around 20 or so bind variables which I've defined against the view object.
In the Edit View Criteria dialog box, I am only able to select columns which I have selected ( the aforementioned eight ). I would like to be able to add items to the criteria where I'm matching non-selected columns to some of the bind variables.
Is there a way to add view criteria to match on columns that you do not select in the query ? And still allow the group by clause to work successfully?
Regards,
Greg
Edit: Forgot to mention I'm running JDev 11.1.1.5 on an 11g database.
Edited by: Greg Block on 17/10/2011 14:31