Quick bite: Using the Query Builder tool

So far we’ve covered:

• Logging into Erudus for the first time
• How to reset your password
• Adding a product
• Adding a local code to a product
• Amending or editing a product
• Managing your Erudus email subscriptions
• Removing a product
• Confirming your product data
• Manufacturer Product Tour
• Interpreting CSV downloads
• Uploading or adding an accreditation or certificates

• Updating your Supplier profile details
• Creating a Product Visibility Report
• Uploading a Range List to Match Local Codes to Products
• Adding an Internal or Customer User to Your Wholesaler Account
• Copying a Product Specification
• Uploading images to Image Hub
• Managing uploaded images
• Downloading all of your product specifications as a CSV file

This time we're turning our attention to “Using the Query Builder”.

The Query Builder tool allows you to conduct specific searches using Erudus. This could be anything from searching for a particular Manufacturer to finding foods suitable for a specific allergy group (Gluten-free for example), or even searching for a vegan, halal or kosher range.

The below guide shows you how to select specific search parameters using the Query Builder.

Overview

1. Query Builder: In this section, you state the criteria to search against.
2. Include: In this section, you state the attributes you’d like to display in the results.
3. Run Query: Once you have selected your search criteria, selected your includes and output method, click this button to run the query. Depending on the complexity of your query it may take up to 15 mins for the results to load.
4. Attribute: You can select which data attribute to search using this drop-down option.
5. Attribute rule: Select the rule for the attribute i.e Nuts = No, Fat = Less than etc.
6. Specify the rule value i.e Fat = Less than 3g.
7. Add rule / Add Group. Add additional rules/groups to your query
8. Delete: Deletes the attribute from the query builder.

Query Options (Criteria)

In this example, we have added 2 attributes to the search criteria along with various attribute rules and values.

Data Sets to Include

In this example, we have added a number of ‘Includes’ so the results return information for General, Inner Pack, Outer Case, Allergens and Accreditations (1). We now run the query (2) by clicking on the "run query" button.

Results

1. Back: Clicking this button will take you back to the query builder page.
2. Once run you can save your query for future use.
3. Changes the number of results shown per page.
4. Pagination.

To view all the information on screen scroll the page to the right if necessary to see all the additional includes information.

See the Knowledge Base page on “Using the Query Builder” here.

Explore Knowledge Base here.