Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

Metastorm BPM forums
Sign up Latest Topics

  Author   Comment  

Avatar / Picture

Posts: 5,507
Reply with quote  #1

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.
Previous Topic | Next Topic

Quick Navigation:

Create your own forum with Website Toolbox!