Improvements to Solution Tables and Grids

Rob Vignerot

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 /awd/forums/questions/3403668.  This will allow you to build re-usable packaged components including whatever custom storage you might need in a simple deployable package.

Secondly, we’ve enhanced the solution table to include allow integer columns to be marked as /awd/forums/questions/3403871.  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.

For our grids, we’ve added a nice new feature to allow for default values for new rows in grids that was requested by /awd/forums/questions/3401927 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.

 

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