Microsoft Dynamics CRM (Archived)

Using a filter for multi entity list on a web Page

(0) Share

Report

Posted on by Community Member

Hi everybody,

I have created a Web Page for my client using Portal Dynamics.

On this Web Page i'm using a Web Model with 6 blocks, each one refering to a different entity list.

Every entity list is a view of articles (knowledgearticles) and on each one of the field is a city.

I want to use the menu or a dropdown button to select a city to filter all the entity list of my web page.

Do you have any idea how I can do that ? to be honest i'm in front of a wall. I'm thinking about using Fetchtxml but i don't know how.

Thank for your help.

Natsirt.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

ChangeFrenzoId 465 on at

Like (0)

Report
Hi Natsirt,

You can use FetchXml, refer: https://msdn.microsoft.com/en-in/library/gg328117.aspx

Add condition like below in your fetchxml"

<condition attribute='city' operator='eq' value='<selected city from drop down>' />

It is always easy to create FetchXml using AdvanceFind.

Just open advance find, select entity, apply filters, and after execution - download the "FetchXml" refer: http://www.crmcs.co.uk/content/dynamics-crm-and-fetch-xml.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank i will try that.

I have to put it on top of my web page, isn'it ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

How i can use it in my web template where i use html and Liquid ?

Was this reply helpful? Yes No
ChangeFrenzoId 465 on at

Like (0)

Report

Refer the below url, it having a configuration process:

https://community.adxstudio.com/products/adxstudio-portals/documentation/configuration-guide/entity-list/entity-list-filter-configuration/

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Thank I finally manage to find a solution with your help.

Using Fetchxml

{% assign city = "id of my city" %}

{% fetchxml knowledgearticlesomething_query %}

<filter type="and"> <condition attribute="cap_name" value="{{ city }}" operator="eq"/> </filter>

my fetchxml query from advanced find

{% endfetchxml %}

{% assign articles = knowledgearticlesomething_query.results.entities %}

<ul class="list-group unstyled">

{% for item in articles %}

{% assign valeur = item.rating | integer %}

<li class="list-group-item">

<div> {% include 'BM - Evaluation par étoile' %}</div>

<a href="{{ item.url | escape }}" class="title">{{ item.title | escape }}</a>

<div class="text-muted small"> {{ item.cap_datedepromotion | date: 'd MMM, yyyy' | escape }}</div> <div class="text-muted small"> {{ item.description | escape }}</div>

</li>

{% endfor %}

</ul>

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for sharing the reference, Piyush. Will look further into it.

Was this reply helpful? Yes No

Community site session details

Using a filter for multi entity list on a web Page

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Using a filter for multi entity list on a web Page

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates