condition of FetchXml query not taken account of
up vote
0
down vote
favorite
We are currently installing blogs on our Dynamics 365 Portal.
Wanting to modify the layout of the posts we recreacted a template based on this structure : https://community.adxstudio.com/products/adxstudio-portals/documentation/configuration-guide/liquid-templates/objects/blogs/
Because the adx "post" object doesn't contain tags, we had to use a fetchxml query to get them.
The problem is the query retrieve all the tags :
Only the Général tag should be showing on the first post only.
Full code :
% assign blog = blogs['Actualités et annonces'] %
% assign posts = blog.posts %
<div class="col-md-8">
<div class="content-panel panel panel-default">
<div class="panel-heading">
% assign sitemarker = sitemarkers["Blog Home"] %
% assign snippet = snippets["Home Blog Activity Heading"] %
<a class="pull-right" href="sitemarker.url"> All Blogs </a>
<h4>
<a class="feed-icon fa fa-rss-square" href=" blogs.feedpath ">
snippet.adx_value
</a><div class="grid-container">
% for post in posts.all %
<div class="grid-item">
<a class="image-header" href=" post.url ">
% if post.new_category %
% assign category = entities.new_vignette[post.new_category.id] %
% assign imgpath = category.new_path %
% elsif post.new_vignette %
% assign imgpath = post.new_vignette %
% else %
% assign imgpath = "../pocfabien/avarap-entete" %
% endif %
<img class="img-responsive img-post" src="imgpath">
</a>
<div class="content-header">
<h4 class="list-group-item-heading">
<a href=" post.url "> post.title </a>
</h4>
<br />
<abbr> post.publish_date </abbr>
</div>
<div class="content-preview">
post.adx_summary
</div>
<div>
% fetchxml tags %
<fetch>
<entity name="adx_tag">
<attribute name="adx_name" />
<attribute name="adx_tagid" />
<link-entity name="adx_blogpost_tag" from="adx_tagid" to="adx_tagid" intersect="true">
<filter>
<condition attribute="adx_blogpostid" operator="eq" value=" post.adx_blogpostid " />
</filter>
</link-entity>
</entity>
</fetch>
% endfetchxml %
% for tag in tags.results.entities %
tag.adx_name
% unless forloop.last % | % endunless %
% endfor %
</div>
<img class="plusign" src="plusign.png">
</div>
% endfor %
</div>
</h4>
</div>
</div>
</div>
PS : if you have a solution to retrieve n:n relationship entities without a fetchXml query I am all ears.
dynamics-crm crm dynamics-crm-online dotliquid adxstudio-portals
add a comment |
up vote
0
down vote
favorite
We are currently installing blogs on our Dynamics 365 Portal.
Wanting to modify the layout of the posts we recreacted a template based on this structure : https://community.adxstudio.com/products/adxstudio-portals/documentation/configuration-guide/liquid-templates/objects/blogs/
Because the adx "post" object doesn't contain tags, we had to use a fetchxml query to get them.
The problem is the query retrieve all the tags :
Only the Général tag should be showing on the first post only.
Full code :
% assign blog = blogs['Actualités et annonces'] %
% assign posts = blog.posts %
<div class="col-md-8">
<div class="content-panel panel panel-default">
<div class="panel-heading">
% assign sitemarker = sitemarkers["Blog Home"] %
% assign snippet = snippets["Home Blog Activity Heading"] %
<a class="pull-right" href="sitemarker.url"> All Blogs </a>
<h4>
<a class="feed-icon fa fa-rss-square" href=" blogs.feedpath ">
snippet.adx_value
</a><div class="grid-container">
% for post in posts.all %
<div class="grid-item">
<a class="image-header" href=" post.url ">
% if post.new_category %
% assign category = entities.new_vignette[post.new_category.id] %
% assign imgpath = category.new_path %
% elsif post.new_vignette %
% assign imgpath = post.new_vignette %
% else %
% assign imgpath = "../pocfabien/avarap-entete" %
% endif %
<img class="img-responsive img-post" src="imgpath">
</a>
<div class="content-header">
<h4 class="list-group-item-heading">
<a href=" post.url "> post.title </a>
</h4>
<br />
<abbr> post.publish_date </abbr>
</div>
<div class="content-preview">
post.adx_summary
</div>
<div>
% fetchxml tags %
<fetch>
<entity name="adx_tag">
<attribute name="adx_name" />
<attribute name="adx_tagid" />
<link-entity name="adx_blogpost_tag" from="adx_tagid" to="adx_tagid" intersect="true">
<filter>
<condition attribute="adx_blogpostid" operator="eq" value=" post.adx_blogpostid " />
</filter>
</link-entity>
</entity>
</fetch>
% endfetchxml %
% for tag in tags.results.entities %
tag.adx_name
% unless forloop.last % | % endunless %
% endfor %
</div>
<img class="plusign" src="plusign.png">
</div>
% endfor %
</div>
</h4>
</div>
</div>
</div>
PS : if you have a solution to retrieve n:n relationship entities without a fetchXml query I am all ears.
dynamics-crm crm dynamics-crm-online dotliquid adxstudio-portals
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
We are currently installing blogs on our Dynamics 365 Portal.
Wanting to modify the layout of the posts we recreacted a template based on this structure : https://community.adxstudio.com/products/adxstudio-portals/documentation/configuration-guide/liquid-templates/objects/blogs/
Because the adx "post" object doesn't contain tags, we had to use a fetchxml query to get them.
The problem is the query retrieve all the tags :
Only the Général tag should be showing on the first post only.
Full code :
% assign blog = blogs['Actualités et annonces'] %
% assign posts = blog.posts %
<div class="col-md-8">
<div class="content-panel panel panel-default">
<div class="panel-heading">
% assign sitemarker = sitemarkers["Blog Home"] %
% assign snippet = snippets["Home Blog Activity Heading"] %
<a class="pull-right" href="sitemarker.url"> All Blogs </a>
<h4>
<a class="feed-icon fa fa-rss-square" href=" blogs.feedpath ">
snippet.adx_value
</a><div class="grid-container">
% for post in posts.all %
<div class="grid-item">
<a class="image-header" href=" post.url ">
% if post.new_category %
% assign category = entities.new_vignette[post.new_category.id] %
% assign imgpath = category.new_path %
% elsif post.new_vignette %
% assign imgpath = post.new_vignette %
% else %
% assign imgpath = "../pocfabien/avarap-entete" %
% endif %
<img class="img-responsive img-post" src="imgpath">
</a>
<div class="content-header">
<h4 class="list-group-item-heading">
<a href=" post.url "> post.title </a>
</h4>
<br />
<abbr> post.publish_date </abbr>
</div>
<div class="content-preview">
post.adx_summary
</div>
<div>
% fetchxml tags %
<fetch>
<entity name="adx_tag">
<attribute name="adx_name" />
<attribute name="adx_tagid" />
<link-entity name="adx_blogpost_tag" from="adx_tagid" to="adx_tagid" intersect="true">
<filter>
<condition attribute="adx_blogpostid" operator="eq" value=" post.adx_blogpostid " />
</filter>
</link-entity>
</entity>
</fetch>
% endfetchxml %
% for tag in tags.results.entities %
tag.adx_name
% unless forloop.last % | % endunless %
% endfor %
</div>
<img class="plusign" src="plusign.png">
</div>
% endfor %
</div>
</h4>
</div>
</div>
</div>
PS : if you have a solution to retrieve n:n relationship entities without a fetchXml query I am all ears.
dynamics-crm crm dynamics-crm-online dotliquid adxstudio-portals
We are currently installing blogs on our Dynamics 365 Portal.
Wanting to modify the layout of the posts we recreacted a template based on this structure : https://community.adxstudio.com/products/adxstudio-portals/documentation/configuration-guide/liquid-templates/objects/blogs/
Because the adx "post" object doesn't contain tags, we had to use a fetchxml query to get them.
The problem is the query retrieve all the tags :
Only the Général tag should be showing on the first post only.
Full code :
% assign blog = blogs['Actualités et annonces'] %
% assign posts = blog.posts %
<div class="col-md-8">
<div class="content-panel panel panel-default">
<div class="panel-heading">
% assign sitemarker = sitemarkers["Blog Home"] %
% assign snippet = snippets["Home Blog Activity Heading"] %
<a class="pull-right" href="sitemarker.url"> All Blogs </a>
<h4>
<a class="feed-icon fa fa-rss-square" href=" blogs.feedpath ">
snippet.adx_value
</a><div class="grid-container">
% for post in posts.all %
<div class="grid-item">
<a class="image-header" href=" post.url ">
% if post.new_category %
% assign category = entities.new_vignette[post.new_category.id] %
% assign imgpath = category.new_path %
% elsif post.new_vignette %
% assign imgpath = post.new_vignette %
% else %
% assign imgpath = "../pocfabien/avarap-entete" %
% endif %
<img class="img-responsive img-post" src="imgpath">
</a>
<div class="content-header">
<h4 class="list-group-item-heading">
<a href=" post.url "> post.title </a>
</h4>
<br />
<abbr> post.publish_date </abbr>
</div>
<div class="content-preview">
post.adx_summary
</div>
<div>
% fetchxml tags %
<fetch>
<entity name="adx_tag">
<attribute name="adx_name" />
<attribute name="adx_tagid" />
<link-entity name="adx_blogpost_tag" from="adx_tagid" to="adx_tagid" intersect="true">
<filter>
<condition attribute="adx_blogpostid" operator="eq" value=" post.adx_blogpostid " />
</filter>
</link-entity>
</entity>
</fetch>
% endfetchxml %
% for tag in tags.results.entities %
tag.adx_name
% unless forloop.last % | % endunless %
% endfor %
</div>
<img class="plusign" src="plusign.png">
</div>
% endfor %
</div>
</h4>
</div>
</div>
</div>
PS : if you have a solution to retrieve n:n relationship entities without a fetchXml query I am all ears.
dynamics-crm crm dynamics-crm-online dotliquid adxstudio-portals
dynamics-crm crm dynamics-crm-online dotliquid adxstudio-portals
edited Nov 9 at 16:47
David Jacquel
36.3k273103
36.3k273103
asked Nov 9 at 16:19
Florent
243
243
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53229505%2fcondition-of-fetchxml-query-not-taken-account-of%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown