Adding a People Query

ActiveVOS Designer BPEL for People User’s Guide

Adding a People Query

The most flexible way to specify actual users to work on tasks or to receive notifications is with a Logical People Group query. You can create a query that searches your Identity service for the users or groups that meet the search criteria.

For example, you can create a query performs the following search in an Identity service: “Select the manager of the task owner to receive an email notification for an overdue task.”

Note: You can add a People Query only if your enabled Identity service is based on a LDAP or JDBC provider. A People Query is not applicable for a file-based Identity service.

Loading the Identity Configuration

The query you write is based on the users and groups and their attributes that are configured in your LDAP or JDBC Identity service. The Identity service is configured in the ActiveVOS Server Administration Console, and then you must set up communication with the server from within Designer, as described in Setting up an Identity Service.

After the set up is complete, select Load Identity Configuration. A message informs you if the configuration was successfully loaded. If the configuration is updated on the server, the updates are automatically loaded into Designer.

Select either the Users or Groups radio button, and then select Query Builder to create an expression for retrieving users.

Using the People Query Builder

When the People Query opens, you see the following items:

The Expression Language is SPARQL, a language well-suited for retrieving identities from a data store. This is the required language for people queries.
The Attributes column lists the Identity service’s parameters that are currently available for queries. For example, users’ attributes always include userName and memberOf, and may include many other attributes configured in ActiveVOS Server.
The LPG Parameters column lists any parameters defined for the currently selected Logical People Group. For details on adding LPG parameters, see Creating a Logical People Group and Logical People Group Parameters and Arguments.
The Query text box contains the FILTER () keyword from a SPARQL query. The Filter clause is the only part of a SPARQL query that you need to complete. The fully qualified query is automatically generated by ActiveVOS.

To create a valid SPARQL query, you must complete the FILTER clause, as shown in the examples.

Examples of People Queries

FILTER($userName="Jani Mani")

Select the user Jani Mani.

FILTER (($memberOf = "NE_Reps") || ($memberOf="NW_Reps"))

Select users from either NE Reps or NW Reps.

FILTER ( (($memberOf = "NE_Reps") || ($memberOf="NW_Reps")) && BOUND(?email))

Select users from either NE Reps or NW Reps who have email addresses.

FILTER ($countryCode = "${country_code}")

Select users in a certain country, where the Logical People Group parameter is country_code and the Identity Service search attribute is countryCode.

For details on writing SPARQL queries, see http://www.w3.org/TR/rdf-sparql-query/.