Queries

Retrieve products matching a set of predefined criteria

The Queries section of the Products-area is where you create and configure product queries to e.g. retrieve All active products or All products with no Spanish translation, etc. Queries are flexible and can be used for many purposes – you can create as many personal and shared queries as you like to find products you need to look at, but some queries are also used to e.g. retrieve products to include in a dynamic workspace structure.

Queries in PIM are based on repositories – specifically a Product-index – and consist of the same basic components; a source index, some parameters and expressions, etc. We’re not going to go into details about all of these index-related subjects here – but you can read about them in the linked repositories documentation.

Creating a query

To create a query:

1. In the Query-section of the tree, use the + or context menu to create a new query
2. Specify a name and a source index
3. In the New expression slideover:
   • Select a field to query on
   • Select an operator to use
   • Select a type of test value - and provide a value
4. Save

You've now created a (basic) query which returns a subset of products matching your expression definition.

The intricacies of queries and expressions are beyond the scope of this article – you can read much more about that subject in the queries documentation – but once you’ve created a set of expressions and saved you should see fewer products returned by the query. In this manner you can create personal and shared queries for a variety of purposes.

Configure Queries

Using the context menu you can open the query configuration screen - it contains two tabs, where you can tweak query behavior:

• General
• Visible fields

The General-tab is used for two things:

• Controlling if products in this query opens on Edit-mode or not
• To add a context for completeness calculations

When you add completeness rules & languages to this configuration, products returned by this query will show a completeness percentage calculated based on your selection. This context is also applied if you use the query elsewhere, e.g. in dynamic workspaces.