mscrm-addons.com - Blog

IMPORTANT INFORMATION

This blog is deprecated since July 2020.The articles below are no longer maintained and might contain outdated information. 
You can find the most acutal and relevenat information in our Knowledge Base at support.mscrm-addons.com

News.mscrm-addons.com Blog

rss

Hello and welcome to our blog! What can we do for you? Are you looking for further technical information or step-by-step instructions to our products? Or would you like to read the latest news on mscrm-addons? Please feel free to browse our blog for detailed information and to share our posts!


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

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




Comments are closed.