• Archive
  • Back to www.mscrm-addons.com
  • Archive
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)

How to add a filter to a relationship in DocumentsCorePack Template Designer

197 views 0

Written by Administrator
February 16, 2017

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 ❷.
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 behavior 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.

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

Was this helpful?

Yes  No
Related Articles
  • How to setup editable sections in your template (Dynamics 365)
  • Concatenate Syntax
  • How to use product translations in DoumentsCorePack templates
  • Document Name (Dynamics 365)
  • How to change TemplateDesigner-Connection via DataProvider
  • How to restart the DocumentsCorePack dataprovider
Latest Articles
  • IMPORTANT information for Dynamics 365 Online customers using ActivityTools, AttachmentExtractor, PowerSearch or SmartBar
  • How to check the existence or the value of a SettingsKey in MS Dynamics 365
  • Error message during Dynamics 365 Connection setup with Ws-Trust endpoint authentication
  • Step-by-Step: How to configure a One-Click-Action
  • DocumentsCorePack Editable Sections Feature (Dynamics 365)
Popular Articles
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • How licenses are counted
  • How to work with the new DocumentsCorePack custom connector for PowerAutomate (Microsoft Flow)
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • DocumentsCorePack Charts Feature (Dynamics 365)
Top Rated Articles
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • Can you save data capacity by moving email content?
  • DocumentsCorePack Online Scheme
  • Recap of the first virtual eXtreme365 & Community Summit event
  • Step-by-Step: How to configure a One-Click-Action
Categories
  • *News and General Infos* 42
  • Template Designer(DCP 147
  • DocumentsCorePack(DCP 144
  • TelephoneIntegration (TI 62
  • AttachmentExtractor (AE 47
  • PowerSearch (PS 43
  • ActivityTools (AT 55
  • SmartBar (SB 50
  • GroupCalendar (GC 43
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
  • © 2020 www.mscrm-addons.com. All Rights Reserved.