How to handle fetchxml when result is empty

Like (0) Share

Report

Posted on 30 Jan 2024 00:03:34 by JanGenese09

Hello,
I have a fetch xml query via liquid.

Issue:

{% if colfetchxml.results.entities.size == 0 %}

{% assign myvar = false %}

{% else %}

{% assign myvar = true %}

{% endif %}

I keep getting this:
Liquid error: Exception has been thrown by the target of an invocation.

So far I have narrowed down to the me trying to acess these properties even at the first level .results .entities .size

I've tried comparing colfetchxml to null, nil, "" and the result is always that it is not empty/null since i can do colfetchxml.xml | h to return the xml query.

My assumption is that since the the result is empty, the additional properties are not available.

How can I evaluate this?

I have checked permissions.
I have many other fetches written this way and they are working. Partly because all of them has a minimum 1 record requirement or must exist.

For this one case, it is optional.

All responses (1)

Answers (1)

Verified answer

JanGenese09 on 30 Jan 2024 at 02:35:07

Like (0)

Report

Re: How to handle fetchxml when result is empty

I figured it out:

instead of checking the size which is not accessible. you can instead evaluated if a property exist.

{% if colfetchxml contains 'results'%}
//the property result exist
{% else%}
//
{% endif %}