OrangeScape Developer Community

A community for Application Developers on OrangeScape's Platform-as-a-Service

Featured Blog Posts (6)

Enable workflow for model

Current behavior:
Workflow will be enabled for all the models which are newly created. The workflow by default contains Start and End activities. But ProcessInstance will not be created for Start, so you can't see the newly created items in the worktop (which will be in Start activity). So currently there is no way you can goto the list of items which are in Start activity.

Proposed behavior:

Now workflow is an option for the model. So for…

Added by adhi on October 25, 2010 at 12:06pm — 7 Comments

Difference between len() and datalength() mssql

If you want to just get number of characters excluding blanks you would use LEN() function, while in all other cases DATALENGTH().

Please find more information about the same in the following links :


Added by VM.Hanitha on October 8, 2009 at 10:28am — No Comments

Edit Preferences [Configuring A Button Or Deleting ] Is not working in IE6 or IE7


There is problem in Internet 6.0 and Internet 7.0 where you cannot delete the button nor configure a button in edit preference.


check the link

and 4.0 download MSXML Service Pack 2… Continue

Added by Anbarasan on November 19, 2008 at 7:58pm — No Comments

Concatenate string column values for a given group into a comma (or any character) separated list of values in SQL Server 2005+

Sometimes we need to convert (concatenate) string column values for a given group into a comma (or any character) separated list of values.


We have a table as below:

We want an output as below:

here is one way of doing this in Ms-SQL 2005/2008 using FOR XML PATH(”)

Select NoteID, STUFF ((SELECT ',' + a.Comments

from Notes a where a.NoteID = b.NoteID… Continue

Added by Dwarakanath Cheyyur on May 20, 2009 at 9:09pm — 1 Comment

Hot fix for inbox search


If a model contains a string parameter for which save in database property is set to be false then inbox search won't work for those models. It will throw error like..

Unknown column 'Error_msg' in 'where clause' (for MySQL)"

ORA-00904: "Error_msg": invalid identifier (for Oracle)

Invalid column name 'Error_msg' (for SQLServer)

The above errors may vary depends upon the database which you are using.…


Added by Santhosh Ponnusamy on May 25, 2009 at 4:00pm — No Comments

To Capture User Log Information (Login Time, Logout Time, Viewed Models / Reports)

The following are the suggested ways to capture User Log Information:

* In change the following properties as mentioned as follows: location:(\\OrangeScape\Server\DimensionServer\server\default\deploy\A-dimension-portal.ear\portal-ejb.jar


log.user.paths=true (Approximate Line Number:…

Added by Santhosh Ponnusamy on May 21, 2009 at 9:30pm — No Comments

© 2018   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service