Hi,
I have an OEAdapter which returns data in temptable and want to assign the temptable data to grid.
How can we assign temptable dataslot to the grid?
[View:/cfs-file/__key/communityserver-discussions-components-files/13/getAuthorizationRecords.p:320:240]
[View:/cfs-file/__key/communityserver-discussions-components-files/13/Query.zip:320:240]
Hi,
When you say, " How can we assign temptable dataslot to the grid?" what we understand is, assigning the temp table to a workstep, where , we can visualize the temp table data in the BPM portal.
Is this correct?
If that is the case, then i did some changes to the getAuthorization.p file and created a sample process(Attached to this post), where you can visualize the temp table data from ttAuthInfo in the BPM Portal
You can deploy the Sample OpenEdge App server project in the bpsbroker and deploy the SampleProcess BPM project in BP Server.
SampleProcess consisst of a BPM process, with the following flow
Start -> OEAdapter -> Workstep -> End
During runtime, temp table process the data and it get displayed in the Workstep.
Let me know, if you have any questions?
Regards,
Jawahar.
Hi Jawahar,
Can you tell me how it can be done? A simple example or resources related to populating the grid with java script code would be great.
Hi Bidhan,
Please refer to following sample, where you can render PDS/TT data in the workstep.
Point to be noted here is, mapping the PDS/TT to Form editor grid is not straight forward way and that was the reason, we are providing you the sample, which can allow you map to PDS/TT data in custom jsp.
The attachment contains
1. DataSetView – BPM Project with OE Adapters configured. You need to deploy the ABL logic to bps broker
2. dataset_view.jar - Copy this jar to <DLC>\oebpm\jboss\webapps\deploy\sbm.war\WEB-INF\lib and start the BP Servers
Steps to Run:
Deploy the BPM process to BP Server
In Portal create an instance, in the DS_View workstep, you can see the PDS/TT data rendered
In the TableDataSetView.spt we have added following lines under the tag
<AtomicWS height="60" name="DS_View" width="….. >
<Datainput>tableDs</Datainput>
<Datainput>datasetDs</Datainput>
<Dataoutput>tableDs</Dataoutput>
<Dataoutput>datasetDs</Dataoutput>
Follow the following steps to use Custom JSP in other process
1. Place the following under the “jsp” folder of your process where your custom JSP resides.
a. DataSetView\TableDataSetView\jsp\js
b. DataSetView\TableDataSetView\jsp\TableDataSetView.jsp
c.DataSetView\TableDataSetView\jsp\paging.jsp
2. Open TableDataSetView.jsp and edit line#14 by adding the names of dataslots (Table (or) Dataset types only) which you want to render in your custom JSP.
3. Include “TableDataSetView.jsp” in your custom JSP by placing the following tag just above the <!—Footer -- > tag.
<jsp:include page="TableDataSetView.jsp"/>
4. Do the step 3 (from above section) to add input and output dataslot to your custom JSP workstep (AtomicWS tag).
5. Deploy and check your pages.
Hope this helps!!!
Regards,
Jawahar.
[View:/cfs-file/__key/communityserver-discussions-components-files/13/PDS_5F00_TT_5F00_Customjsp.zip:320:240]