Identity Manager 9.0 LTS - Web Designer and Web Portal Changes

• The GetToXML function has been removed.

• The Eval function has been removed.

The following Web SQL functions have changed their internal implementation. This may cause unexpected behavior in custom components that rely on details of the old implementation.

• The TranslateColumn function does not recognize % as a place holder character anymore. This change was made to increase performance for the general case, where place holders are not required.

• The Concat function now behaves differently when the input set is empty. In the case where the input does not contain any rows, the result is not NULL but an empty string.

• The GetViPrimaryKey function has been removed. It is no longer necessary to handle the special case where an artificial internal primary key was created for database objects. Use the PrimaryKeyfunction instead.

Due to security considerations, it is not recommended to run arbitrary SQL statements from the web application layer. When the web application is installed on the new application server, an exception is generated when any SQL statements are performed.

This change affects all Database query type collections defined in Web Designer components.

All SQL statements must be encapsulated as predefined SQL statements (QBMLimitedSQL-type objects) and stored in the database. Refer to the One Identity Manager Configuration Guide for more information on how to define predefined SQL statements.

For additional security, predefined SQL statements must be assigned to permission groups. Running of predefined SQL statements always occurs with the permissions of the user who is logged in to the web application can.

Note that WHERE clauses, as well as the WebSQL functions Exists and GetSingleProperty, are not considered arbitrary SQL statements and may be used as before.