StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Business Object from Joined Tables
Business Object from Joined Tables
Post Reply
Like
1
Business Object from Joined Tables
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Ger Cannoll
Ger Cannoll
posted 15 Years Ago
ANSWER
Topic Details
Share Topic
Group: StrataFrame Users
Posts: 430,
Visits: 507
I have many requirements to be able to show on a ListView/Combobox the results from multiple joined tables. (e.g.Show Transactions but join in the Stock Description from a joined file). I have gone through a lot of the threads here to get hints , and have it working fine on a Combobox , but would like to ensure there are no Gotchas for any of the other list types , or maybe there is a better way.
1. Say my data is required from two Tables, Tran and Products, where Products gives the description
2. I have set up a 'Dummy' business Object which will be used for ALL my Joined Tables (Query ? Can I do this with just one Dummy Business Object for ALL my lists)
3. I have a Stored Proccdure which Joins the Tables Tran and Products
4. I specify the Dummy Business Object as the BusinessObjectType in the PopulationDataSourceSettings 9With a different Stored procedure depending on the Tables)
(When entering the Columns, I
type in the column names
as they will not be in the buisness Object when it is initially set up)
5. My main concern is that I am using in effect a Multi Table Business Object (whereas when Business Objects are being set up they are limited to One Table only) and wonder if this will cause any problems in SF
Any comments would be helpful
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Business Object from Joined Tables
Ger Cannoll
-
15 Years Ago
Hi Gerard,
To show a field description you can do any of...
Edhy Rijo
-
15 Years Ago
I see no issues with this approach, assuming your just using the dummy...
Greg McGuffey
-
15 Years Ago
As Greg pointed out the only issue is if you try to do an update, add...
Larry Caylor
-
15 Years Ago
That's an excellent idea Larry. I second that suggestion!
Greg McGuffey
-
15 Years Ago
Hi guys. Many thanks for all your comments which I have found very...
Ger Cannoll
-
15 Years Ago
Post Reply
Like
1
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search