Creating a work area based on a query

This article describes how to create and save a work area from a query in the Query Editor.

Creating work areas

Work areas can be created in different ways. The benefit of creating a work area based on a query is that the work area will be populated dynamically based on the search criteria, i.e. the number of entities in the work area will grow and decrease as entities are added or modified.

Note that there's a magnifying glass with a + sign on query-based work areas, to single them out and these work areas are called dynamic work areas. 

Using the query editor

The Query Editor is a powerful tool to search for the entities you need. There are many different types of conditions you can use to specify which types of entities you are looking for. 

To open the Query Editor, go to the inriver Enrich Dashboard and click Query Editor in the top tool bar.

Examples

To find all entities of type Product that are tools:

1. Click select value and select Product. 
   
   
2. Click Add condition.
   
   
3. Select FieldSet as a condition.
   
   
4. Click Equals and select Jackets.
   
   
5. Click the Add Relation condition
   
   

To find all entities that have been modified during the last week:

1. Click Entity Type to see the other conditions that are available.
   
   
2. Select Last Modified.
   
   
3. Click Equals to see the other options. 
   
   
4. Select After or After or Equals.
   
   
5. Click enter a value and select the wanted date and time. 
   
   

To save a query

When you are happy with a query: 

1. Click Save. A new window opens, with the option Save query. 
   
   
2. Do you want the work area to be shared by all users?
   
   
   • If yes, click the folder Common Shared and enter the work area name in the empty field.
     
     
   • If no, click the folder with your user name and enter the work area name in the empty field. The work area will now only be available to you.
     
     
     
     
3. Click Save.
   
   
4. The Query Editor window closes and the entities that match the conditions are shown in the work area. Above the entities, the name of the work area and the number of entities included in the work area is shown.  
   
   

Further reading

Sorting the order of saved query results within a work area

Creating and saving work areas

Query