Re: Select whole "Objects"

Thanks alot for all your input.

Using binds or not is not really relevant for the problem (probably we wont, as the statements will be completely different and have to be parsed anyway).

I agree that the thing i want can be compared to Business Objects (or other data object middleware). The problem that occured trying to use something like this was that it seemed not possible to "model" the pretty complex queries i need to get even one "object" (there are decodes, exists, lags/leads and such included). Sadly, as i said before, i am not allowed to change anything in the data sctructure to simplify this.

Nevertheless, we finally decided to implement the following: As some of you suggested, the employee is a sub-object of company. So, in the configuration of my reporting module, i define all these objects and supply queries that represent the. Further i define the connection (columns) that should be used to link one object to the other (just like in Business Objects, i suppose).

Any time the user uses one of the Subobjects columns (either for filtering the data or to display a subobjects column), the whole subselect is inserted into the FROM or WHERE clause. This is pretty similar tho what i tried to do first (and described in my example).. i just simplified the configuration so you get the "object" and "subobject" feeling and (marginally) reduced set of possibilities for the user.

Surprisingly the performance is well and everything works fine.

Many thanks,
  jlaffer Received on Tue Feb 21 2006 - 06:36:43 CST