LiveReport for Set in Form

[sandersbrett]

I see that when a set is in a form a sub table is created that holds the set values. It looks like the seq number can relate the set data back to the entry in the primary table. My question is what is the best way to show all these entries in a live report for oracle.

Simplified Example:


Table One
------------
seq user
1 jdoe
2 bday

SubTable
------------
seq environment
1 test
1 dev
2 test

Desired Output
-------------
seq user environment
1 jdoe test
1 jdoe dev
2 bday test

 

[appnair]

without seeing the structure of the table if I were to guess

select a.seq,a.user,b.environment from table_one a,subtable b where
a.seq=b.seq (this is not right you have to correct it)

Bhupinder has a document in Kb that shows you how Ot populates form data.I use that when I need to work with form data.Not sure if he is covering sets in forms there,but it has very good info

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008

http://www.tek-tips.com/faqs.cfm?fid=2884

http://www.linkedin.com/in/appunair

 

[sandersbrett]

i knew that. my sql skills are a bit rusty. Thanks for the quick reply.