Sample Query with xProperties

This section describes using Query Builder to create a query using a Part item containing an xProperty.

The first level of the query contains a Part item that has the xp-cost property associated with it. Click the Part Properties button to view this xProperty.

You can create a Where condition using the xp-cost property by clicking the Show Condition button. The Where Condition box appears.

1. Enter [xp-cost] > 50 in the Where Condition dialog to return the number of items where the cost is greater than 50.



2. Click Save.
3. Right-click Part and click Start Execution.



4. The Query Result dialog appears.

As you can see, this query only contains one part item where the cost is greater than 50. You can modify the Where condition so xp-cost > 100. This returns two parts in the result.

Both parts contain the xp-cost xProperty.