Power Platform Community Forum Thread Details

Filter operation "like" throws Liquid error when using value="%value%"

Hi All,

I'm trying to create a custom component to display data from a virtual table. Following a tutorial I found, I created a filter in FetchXML to filter data that contains a substring in a string column. However, I'm seeing "Liquid error: Exception has been thrown by the target of an invocation." This is the FetchXML I'm trying to run:

{% fetchxml postsQuery %}
      <fetch version="1.0" mapping="logical" distinct="true">
        <entity name="cr6a3_projectlist">
          <attribute name="cr6a3_projectx0020name"></attribute>
		  ...
          <attribute name="cr6a3_modified"></attribute>
          <order attribute="cr6a3_projectx0020name" descending="false" />
          <filter type="and">
            <condition attribute="cr6a3_isactive" operator="eq" value="1" />
            <condition attribute="cr6a3_location" operator="like" value="%value%" ></condition>
          </filter>
        </entity>
      </fetch>
{% endfetchxml %}

I have tested this FetchXML without the 'location' condition, so I can confirm that the attributes and 'isactive' condition are working fine. Interestingly, when I changed value="%value%" to value="value%", it returned some results, though I need both wildcards due to the nature of my data. Not sure if this is relevant, I've read here that it is not recommended to use "%value", and I received the same error when I tested it out myself.

I'm new to Liquid and Power Pages, so I'd appreciate any help or workaround for this. Thanks in advance.

Categories:

Customize & extend

Quick Links