Registered: 1158198299 Posts: 5,507
Reply with quote
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.