spacer
cornerspacercorner

Improvements to Solution Tables and Grids

by Rob Vignerot Employee on 06-10-2011 05:55 AM - last edited on 06-30-2011 01:24 PM by

Keeping on the theme of customer requested enhancements in 9.1, we have a few related items that we have improved at your request for Solution Tables and grids.  Firstly, we have extended our libraries to allow you to include Solution Tables within your libraries.  This will allow you to build re-usable packaged components including whatever custom storage you might need in a simple deployable package.

Library Solution Table.PNG

Secondly, we’ve enhanced the solution table to include allow integer columns to be marked as Identity columns.  These identity columns use an auto-incremented number and can easily be used for primary keys.  By adding this, we’ve reduced the need to have separate DB scripts to be deployed along with your BPM Solution.  This works for both SQL Server and Oracle.  For SQL Server, we use the standard Identity feature in SQL Server.  In Oracle, when the table is created we create a matching sequence along with an insert trigger to generate the data.

Identity Column.PNG

For our grids, we’ve added a nice new feature to allow for default values for new rows in grids that was requested by Bill Tanner among others.  Populating new rows with default values is a very common need for form designers and by adding this, we have cut down on the amount of client side scripting our form designers need to write and we’ve made form design even easier.  You’ll find a new property for all columns in an editable grid for a default value.  You can use any custom expression, which is evaluated on the form load.  I’m sure a very common use case will be using the FolderID.

Column Default Value.PNG

 

Sound good?  This is just a few of the minor changes in this release.  Stay tuned for more.

Announcements
New Phone Numbers and Email Address for Customer Support
US: +1 800-970-5209
International: +1 585-424-2339
BPSSupport@opentext.com

Why and How to Register

How to Be Notified of New Releases

How to Suggest Product Enhancements

Custom Avatars

Metastorm BPM 7.6.4 Hotfix 2 (7.6.4.2) is now available for download in the 'Patches' section of the Knowledge Center here.

Metastorm BPM Widgets Release 2 for OpenText Smart Business Workspace Version 9.1 and Metastorm BPM 9.1.3 is now available for download in the 'Patches' section of the Knowledge Center here. For more information see this post.

Metastorm BPM 9.1 SR3 (9.1.3) is now available for download in the 'Patches' section of the Knowledge Center here. For more information see this post.

Metastorm BPM 9.1.2 Hotfix 2 (9.1.2.2) is now available for download in the 'Patches' section of the Knowledge Center here.

Note: Software and documentation are now in the Knowledge Center (KC) located here.

Have a question about the Community Site? Contact Us

line spacer line
spacerFollow Metastorm on:
spacer Twitter YouTube Blog iTunes LinkedIn Metastorm Community Central, MC2
spacer Copyright © 2011 OpenText Corporation. All Rights Reserved.spacer About Metastormspacer Privacyspacer Legalspacer Site Mapspacer RSSspacer Contact Us
Microsoft Gold Certified Partner
Powered by Windows Azure
line spacer line