You will find a detailed description of node types in the One Identity Manager Web Designer Object Model Documentation.
You will find a detailed description of node types in the One Identity Manager Web Designer Object Model Documentation.
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.
You want to view the employees in your department in a grid.
To view data
FROM Colleages SELECT CURRENT LastName
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.
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. |
GetConfigParm |
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. |
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
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 by-passes the problem of 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").
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center