This discussion is archived
5 Replies Latest reply: Nov 21, 2012 2:04 AM by user404 RSS

Query from Multiple tables to be displayed in UI

969250 Newbie
Currently Being Moderated
JDEVELOPER : 11.1.1.4.0

I have a query from the DB person as shown below. With that I have to make an ADF screen using ADF BC. The query is based on 4 tables.
Select abc.a 
      ,ijk.i
      ,mno.m
      ,abc.b 
      ,abc.c
      ,abc.d
      ,abc.e
      ,abc.f 
      ,abc.g
      ,pqr.p||'-'||pqr.q
      ,xyz.x
      ,abc.h
      ,pqr.s
From   abc    
      ,pqr
      ,xyz
      ,mno
      ,ijk
Where  pqr.p=xyz.x
And    abc.a=pqr.p
And    xyz.x=mno.m
And    ijk.k=mno.m
In the UI I need a table with all the fields as read only and one field pqr.s as editable. THESE TABLES NEED NOT HAVE RELATIONSHIPS DEFINED AT DATABASE LEVEL. So what should be the approach taken by me.

Should I directly create a ViewObjects from this Query.
Or
Should I create separate Entity and ViewObjects for all these 4 tables. Then how do I make a join based on all these table... for the UI purpose.

In short I need an how to go about for this.

Edited by: 966247 on Nov 20, 2012 9:44 PM

Edited by: 966247 on Nov 20, 2012 9:44 PM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points