Chat now with support
Chat with Support

Identity Manager 8.1.4 - Web Designer Reference Guide

The Web Designer editor Web Designer structures and functions The Web Designer object model Working with the Web Designer Web project configuration options Customizing the Web Portal Basics of Web Designer programming Compiling and debugging Monitoring Frequent tasks in the Web Portal

Node types

You will find a detailed description of node types in the One Identity Manager Web Designer Object Model Documentation.

Defining with Web SQL

You can or must select or customize data on many of the Web Designer node types. This data often comes from the database. However, you will not have direct access to the database due to the Model-view-controller architecture of the Web Designer programming model. Instead, you access it through the Web Designer's data layer. You can query this data layer with Web SQL, a SQL-related language.

Web SQL limits to access to SELECT statements. INSERT, UPDATE or DELETE are not supported. JOINS are not supported either in Web SQL.

Query example with Web SQL

You want to view the employees in your department in a grid.

To view data

  1. Load the necessary data from the database table Person into a Web Designer collection.
  2. Create this collection on the grid node.
  3. Using the following Web SQL query, create the individual employee fields you want to display.

    FROM Colleages SELECT CURRENT LastName

Detailed information about this topic

Web SQL functions

Web SQL provides a large number of functions. The most important functions are described briefly in the following. See the Web Designer help for a full description.

Table 56: Overview of the most important Web SQL functions
Function Description
CanDelete, CanInsert These functions allow collection delete and insert permissions to be queried.
CanEdit, CanSee These functions allow edit and view permissions for individual columns of collection rows to be queried.
Count(*) This function queries the number of rows in a collection.
DbCount, Exists Queries the number and existence of rows in a database table. This can be limited with a WHERE clause.
Display, DisplayValue, DisplayValueLong Queries the display values of a complete collection row or a specific column of a collection row.
Format This function formats a string by entering a mask with wild cards and insert values.

Returns the configuration parameter value with the given path.

NOTE: To use the configuration parameter function, the session must be authenticated. This function cannot be used until the after the login page if the Web Portal is being used against an application server.

IsNull, IsNullOrEmpty Checking for undefined values or empty strings is allowed.
PrimaryKey This function queries the primary key value for a row from a collection.
Translate Translates a string.
SqlCompare, SqlAnd, SqlOr This function allows conditions to be written in database SQL.
Try This function allows alternative values, if an error occurs during evaluation of a Web SQL expression.

Loading collections

Web SQL is the SQL language in the Web Designer. This language is used when loading and populating collections with data from the database.

NOTE: A filter expression is used when loading collections. A filter expression is a Web SQL expression. This filter expression must be able to interpret the Web SQL expression for a string which is valid in the database SQL language.

When collections are loaded, the result must be a valid condition in the WHERE clause of a SELECT statement for the queried database table. The same Web SQL expression can be invalid for loading another table.


An example of an invalid Web SQL expression could be using the LastName column in the Department table. The LastName column does not exist in the Department table.

To create a "Define database collection" collection type

  1. Select the database table that the data is going to be loaded from.
  2. Use a filter expression.

      sqlcompare ("LastName", "Schm*", "string", "LIKE")

      This expression specifies which data is to be loaded.

      - OR -

      format(("LastName like '%{0}%'", FROM Var SELECT searchString)

      This expression bypasses the problem when loading an invalid Web SQL expression.

Generally, Web SQL functions are the prefixed by Sql. You can create an optional condition for the collection or Load collection node. For more information, see Web SQL functions.

To load data from a database table into a collection with the help of the "Load collection" action node

  • Specify the collection into which to load the data.

    NOTE: To limit the data to load, you can enter an optional condition for a WHERE clause. You can specify this on the Load collection node. A WHERE clause on the action takes precedence over a WHERE clause on the collection. The WHERE clause on the collection is only used if there is no WHERE clause on the action node.

    TIP: In the query window, you can query the WHERE clause used for the last loading with the Web SQL function WhereClause("CollectionName").

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating