Portal Web template - Fetch XML add dynamic conditions

(0) Share

Report

Posted on by Jeevan Kumar Balija

425

Hi,

I have a web template with Fetchxml to retrieve records from Dynamics, i want to add dynamic conditions based on the parameters passed to that. Below is that code, i tried to add, but it is not working as expected.

Any thoughts please?

{% assign customerid = request.params['customerid'] %}
{% assign addressid = request.params['addressid'] %}
{% assign cacheString = request.params['cacheString'] %}
{% if customerid %}
{% assign conditionCustomer = " %}
    { { conditionCustomer } }
    {% endif %}
    {% if addressid %}
    {% assign conditionAddress = " %}
        { { conditionAddress } }
        {% endif %}
        {% fetchxml customerProperties_query %}
        
            
                
                
                
                
                
                
                    {{ conditionAddress }}
                    {{ conditionCustomer }}
                    
                    
                
            
        
        {% endfetchxml %}
        {
            "totalcount": { { customerProperties_query.results.total_record_count } },
            "customerProperties" :
            [
                {% for result in customerProperties_query.results.entities %}
        {
            "lace_customerpropertiesid" : "{{ result.lace_customerpropertiesid }}",
                "lace_address" : "{{ result.lace_name }}"
        }
        {% unless forloop.last %}, {% endunless %}
        {% endfor %}
  ]
    }

Categories:

Portals

All responses (2)

Answers (0)

rules 51 on at

Like (0)

Report

RE: Portal Web template - Fetch XML add dynamic conditions

Btw one very important thing, when u are reading request.params variables like this, always ensures that the data is html encoded (use liquid escape tag to encode it). If u don't do that, u will have a XSS vulnerability as anyone can pass in script as a parameter and u will execute it
Community Member Microsoft Employee on at

Like (0)

Report

RE: Portal Web template - Fetch XML add dynamic conditions

What do you mean by it's not working as expected -are you not seeing the expected records, or are you seeing an exception?

some things that might help -

I suggest you initialize the variables conditionCustomer and conditionAddress to empty strings. the Liquid processor behaves oddly with uninitialized variables.

assign does not look correct. i would use a capture instead.

and the evaluation of the lace_customerpropertiesid - assuming that is a lookup, i think you need to evaluate it differently.

something like this might work...

{% assign customerid = request.params['customerid'] %}

{% assign addressid = request.params['addressid'] %}

{% assign cacheString = request.params['cacheString'] %}

{% assign conditionCustomer = "" %}

{% assign conditionAddress = "" %}

{% if customerid %}

    {%- capture conditionCustomer -%}

        <condition attribute="lace_customer" operator="eq" value="{{customerid}}" />

    {%- endcapture -%}

{% endif %}

{% if addressid %}

    {%- capture conditionAddress -%}

        <condition attribute="lace_address" operator="eq" value="{{addressid}}" />

    {%- endcapture -%}

{% endif %}

{% fetchxml customerProperties_query %}

        <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" returntotalrecordcount="true">

            <entity name="lace_customerproperties">

                <attribute name="lace_customerpropertiesid" />

                <attribute name="lace_name" />

                <attribute name="createdon" />

                <attribute name="lace_address" />

                <order attribute="lace_name" descending="false" />

                <filter type="and">

                    {{ conditionAddress }}

                    {{ conditionCustomer }}

                    <condition attribute="lace_name" operator="ne" value="{{ cacheString }}" />

                    <condition attribute="statecode" operator="eq" value="0" />

                </filter>

            </entity>

        </fetch>

{% endfetchxml %}

{

    "totalcount": {{ customerProperties_query.results.total_record_count }},

    "customerProperties" :

    [{%- for result in customerProperties_query.results.entities -%}{

    "lace_customerpropertiesid" : "{{ result['lace_customerpropertiesid'].id }}",

        "lace_address" : "{{ result.lace_name }}"

}

{% unless forloop.last %}, {% endunless %}

{% endfor %}]

}

Community site session details

Portal Web template - Fetch XML add dynamic conditions

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Forum Structure Changes Coming on 11/8!

Dynamics 365 Community Platform update – Oct 28

Leaderboard

Featured topics

Product updates

Community site session details

Portal Web template - Fetch XML add dynamic conditions

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Forum Structure Changes Coming on 11/8!

Dynamics 365 Community Platform update – Oct 28

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates