MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder

Published on 24 September 16
2173
0
1
In Composite Data window we will be using Multiple dataobjects.

How to retrieve these dataobjects if they have retrieval arguments for each/some of the individual dataobjects present in the composite datawindow ?

In this case I am using 2 datawindows
1/ Items --> Retrieval Argument will be Item ID --> Freeform datawindow in Picture
2/ Transactions --> Retrieval Argument will be Transaction Item ID --> Tabular datawindow in picture
3/ Actually there will be 3 objects including Composite datawindow
composite datawindow + other dataobjects which it has
We will pass the arguments to Composite datawindow and the individual arguments we need to map while creating the composite datawindow
Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 1
Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 2
Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 3
4/ Now you have the set of retrieval arguments which you have defined for all the dataobjects of the Compositedatawindow
5/ Now click on the each individual dataobject and map its retrieval arguments with appropriate retrieval args which you setup for the composite datawindow like below -
Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 4
6/ That's it. You need to do the same procedure for other dataobjects
7/ Now retrieve the composite datawindow with all the retrieval args

// To explain Simply I am just hard coding the values

this.settranobject(sqlca)
this.retrieve(1,2)

// To supress retrieval arguments you can use responsewindow,openwithparm and PowerObject functionality

// Below I have give the list of items and list of transactions that my application has
// in composite datawindow report I have the report for item no 1 and transaction number 2 (as per the retieval args which I have passed to the CompositeDW)
Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 5
Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 6
The output will look like below
Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 7







In Composite Data window we will be using Multiple dataobjects.

How to retrieve these dataobjects if they have retrieval arguments for each/some of the individual dataobjects present in the composite datawindow ?

In this case I am using 2 datawindows

1/ Items --> Retrieval Argument will be Item ID --> Freeform datawindow in Picture

2/ Transactions --> Retrieval Argument will be Transaction Item ID --> Tabular datawindow in picture

3/ Actually there will be 3 objects including Composite datawindow

composite datawindow + other dataobjects which it has

We will pass the arguments to Composite datawindow and the individual arguments we need to map while creating the composite datawindow

Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 1

Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 2

Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 3

4/ Now you have the set of retrieval arguments which you have defined for all the dataobjects of the Compositedatawindow5/ Now click on the each individual dataobject and map its retrieval arguments with appropriate retrieval args which you setup for the composite datawindow like below -

Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 4

6/ That's it. You need to do the same procedure for other dataobjects 7/ Now retrieve the composite datawindow with all the retrieval args

// To explain Simply I am just hard coding the values
this.settranobject(sqlca)

this.retrieve(1,2)

// To supress retrieval arguments you can use responsewindow,openwithparm and PowerObject functionality

// Below I have give the list of items and list of transactions that my application has

// in composite datawindow report I have the report for item no 1 and transaction number 2 (as per the retieval args which I have passed to the CompositeDW)

Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 5

Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 6

The output will look like below

Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder - Image 7

This blog is listed under Development & Implementations and Data & Information Management Community

Related Posts:
Post a Comment

Please notify me the replies via email.

Important:
  • We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
You may also be interested in
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top