• 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

294 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 create a design/custom QR by the example of the SWISS QR-Code
  • Insert QR-Code (Dynamics 365)
  • How to insert an entity image in Dynamics 365
  • Add a Hyperlink to an existing “Picture-Link-Field”
  • How to create label templates with DocumentsCorePack TemplateDesigner
  • How to rename a relationship table
Latest Articles
  • How to create a design/custom QR by the example of the SWISS QR-Code
  • Insert QR-Code (Dynamics 365)
  • How to trigger actions from the [Create Document]-dialog
  • How to insert an entity image in Dynamics 365
  • Add a Hyperlink to an existing “Picture-Link-Field”
Popular Articles
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • How licenses are counted
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • DocumentsCorePack Server Based Load Balancing Services
  • How to work with the new DocumentsCorePack custom connector for PowerAutomate (Microsoft Flow)
Top Rated Articles
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • How to work with the new DocumentsCorePack custom connector for PowerAutomate (Microsoft Flow)
  • Can you save data capacity by moving email content?
  • Master Template
  • DocumentsCorePack Online Scheme
Categories
  • *News and General Infos* 44
  • Template Designer(DCP 152
  • DocumentsCorePack(DCP 150
  • TelephoneIntegration (TI 62
  • AttachmentExtractor (AE 47
  • PowerSearch (PS 42
  • ActivityTools (AT 54
  • SmartBar (SB 49
  • 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.