Pass Multiple Retrieval Arguments to Multiple dataobjects in CompositeDataWindow in PowerBuilder
Published on 24 September 16
Venkatesh Guptha
0
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
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 -
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)
The output will look like below
This blog is listed under
Development & Implementations
and Data & Information Management
Community
Related Posts:
Post a Comment
