Using Policies to Manage Requests › How to Create a Condition › Conditions Based on the Attributes of the Location

Conditions Based on the Attributes of the Location

You can specify conditions based on the attributes of the location, as follows:

• Conditions based on the attributes of the location of the assignee

  The assignee is the logged in user attempting to complete the pending action triggered by the policy condition being met. Typically, the assignee performs an approval or fulfillment task.

• Conditions based on the attributes of the location of the business unit of the assignee

In both of these types of conditions, you can use the following attributes:

The following parameters may require explanation:

City

Specifies the code for the city (such as New York City, Tokyo, Beijing, and so forth) for the business unit of the assignee. Users enter their own values, rather than run a database query. This data is user-defined, and the MDB does not store this data.

County

Is the user-specified value, such as a name or code, for a county. Examples include a county in a state of the United States or in another country that uses counties as a geographical unit.

The values for this attribute are user-specified and are not validated or maintained by CA Service Catalog or the MDB.

Country

Specifies the country code for the business unit.

Enter the code for the country you want from the ca_country table.

For example, to list the code of a specific country (here, India) in that table, run the following query on the MDB from your database client:

Select id from ca_country where name="India"

The results show that the country code for India is 114.

To list all country codes for CA Service Catalog, run the following query on the MDB from your database client:

select id from ca_country

State

Applies to the 50 states in the United States, to some but not all of the United States territories (such as American Samoa), and to all provinces in Canada. This attribute is null for other countries and territories.

This attribute specifies the ID for the applicable state, territory, or province (such as 7404 for California, 7434 for New York, and so forth) for the business unit of the assigner.

Enter the ID you want from the ca_state_province table.

To list the IDs for all applicable states, territories, and provinces, run the following query on the MDB from your database client:

select id from ca_state_province

If you know the 2-letter symbol for the state, territory, or province from the United States Postal Service (www.usps.com), you can use it to find the ID. For example, the symbol for the state of New York is NY. Therefore, to list the ID for New York, run the following query on the MDB from your database client

select id from ca_state_province where symbol='NY'

This query returns a value of 7434, which you use in your condition to assign the pending action based on the user's location being the state of New York. For details, see the example for the state attribute in the conditions based on the attributes of the location of the business unit of the assignee.

To list the IDs, symbols, and names for all applicable states, territories, and provinces, run the following query:

Select id,symbol,description from ca_state_province

The results appear similar to the following:

7400 AK  Alaska
7401 AL  Alabama
...