Defining a Context Item

The following example creates a Query Definition Item for the Part ItemType as a Context Item. Create a new query definition and specify a unique Name and a Context Item Type.

Figure 4.

1. Click . The Show Editor icon appears in the ribbon.
2. Click the Show Editor icon on the left sidebar to go into Query-Editing Mode.
3. Right-click the Context Item and select Edit Query Element --> Selected Properties.

Figure 5.

Select the desired properties that the query should return. In this example they are: id, Part Number, Name, State, and managed_by_id.

Figure 6.

Extended properties enable you to add values such as cost to an object in the database.

4. Right-click on the Context Item again and select Edit Query Element --> Sort Order.

5. Choose the properties that should be used for the Order By command and specify whether they should be in ascending or descending order.

   

   

   Figure 7.

6. Save the Query.