Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #1 
http://processmapping.com.au/freestuff/freemetastormbpm9solutions/ProcessMappingLibrary.html

So far we have looked at using a Scripted Business Object to allow us to create grids with dynamic queries. We used this in the 'Query Folder' admin form.

In this example, we have created the DataSet for the Business Object manually. The data could come from any source we wished, and be cached or refreshed at will (as we saw in the previous example). In this case we list all teh variables for a folder, along with their values.

Previously we used some cumbersome Transact SQL in a stored procedure to build a UNION with one SQL query for each variable. This worked, but was not ideal for a number of reasons.

In this version of the Process Mapping Library, we have removed the stored procedure, and used a Scripted Business Object to do the work for us. It selects all the data for the folder, and then creates a row in the underlying Table of the Business Object. As the grid is only ever used at a stage, we do not bother with caching.

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!