• Release History
  • Documentation
  • Back to www.mscrm-addons.com
  • Release History
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)/How to add or edit a filter in a relationship with DocumentsCorePack Template Designer

How to add or edit a filter in a relationship with DocumentsCorePack Template Designer

1404 views 0 Updated on July 27, 2022

This step-by-step-tutorial outlines how to add a filter to a relationship in DocumentsCorePack Template Designer. Usually, the simple creation of a relationship is enough, but sometimes, it can happen that you need to add a certain filter to a relationship.

For example, imagine you would like to create an overview that shows which products you have in stock.
So, you could create one template listing all products where the amount is greater than 0 and one template where the amount is exactly 0.
In order to refine your result, you could additionally create a template that lists all products with an amount greater than 500.

In this tutorial, we will show you how to create add a filter to a relationship, so that the result will only return products with an amount greater than 500.

Step 1: ​Create a new template
If you haven’t created a template yet, please have a look at this blog article.

Step 2: Create a relationship
If you haven’t added an relationship yet, please have a brief look at this post.

Step 3: Add a filter to a relationship
Once the relationship is created ❶, navigate to filters and click on the [Add]-button ❷.
Please Note: Any existing “QID-Filter” (Root-Record-Filter) is a reference to the base record and used to
Next, select which type of filter you would like to add (AND / OR) (here we use AND) ❸.
Then, click on the lower [Add]-button ❹. This behaviour opens a new window.
In the Condition-window ❺, select a matching attribute (here: Amount), an operator (here: greater than) and a value (here: 500) and click on the [OK]-button.​

Figure 1: Add a filter to a relationship

That’s all you have to do. Simply return to the Template Designer with a click on the [OK]-button in the Configure Fields and Datasource-window in order to proceed.

Additional Filter options that you have are the column comparison (external link) which is an extension of Microsoft to fetch queries (❶).

Or you also can use dynamic filters that which is an additional DocumentsCorePack feature. (❷)

Figure 2: Additional options for filtering (left: column comparison, right: dynamic filters)

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.

Was this helpful?

Yes  1 No
Related Articles
  • Office Theme Support of DocumentsCorePack
  • Dynamic Document Properties
  • Switch environments in the DocumentsCorePack Template Designer
  • Working with Field Service Inspection responses
  • Create an inspection report for a Work Order
  • Create an inspection report for a Work Order Service Task
Latest Articles
  • New DocumentsCorePack Connector features for Power Automate
  • Office Theme Support of DocumentsCorePack
  • AssureSign for DocumentsCorePack
  • Dynamic Document Properties
  • How to conditionally remove a watermark in DocumentsCorePack templates
Popular Articles
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • mscrm-addons.com Application Access for Dynamics 365 (App Access) – DocumentsCorePack
  • DocumentsCorePack Template Designer – Getting Started
  • DocumentsCorePack Online Service Configuration
  • Step-by-Step: How to configure a One-Click-Action
Top Rated Articles
  • IMPORTANT information for Dynamics 365 online customers using DocumentsCorePack and/or AttachmentExtractor
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • Step-by-Step: How to configure a One-Click-Action
  • Online Services: Required Application Permissions
  • Information on Security roles: Which roles are needed for which solution?
Categories
  • *News and General Infos* 51
  • Webinars 35
  • Template Designer(DCP 173
  • DocumentsCorePack(DCP 191
  • TelephoneIntegration (TI 65
  • AttachmentExtractor (AE 62
  • PowerSearch (PS 48
  • ActivityTools (AT 59
  • SmartBar (SB 53
  • GroupCalendar (GC 46
Our Vision

“We see it as our purpose to provide products that simplify and speed up our customers’ Microsoft Dynamics 365 experience.”

Knowledgebase
LogIn
mscrm-addons.com
  • Products
  • Online Shop
  • Downloads
  • My Account
About Us
  • About Us
  • Case Studies
  • Newsletter
  • Partner Program
  • Contact
Support
  • Support
  • Terms & Conditions
  • Documentation
  • Webinars
  • Legal Documents
  • Impressum
  • © 2022 www.mscrm-addons.com. All Rights Reserved.