Skip to main content
N
nborrerojr.1-Visitor
1-Visitor
March 27, 2019
Solved

Report Recipe Filter

  • March 27, 2019
  • 1 reply
  • 2015 views

Is there a way to add a filter that can return only values where a relationship field is empty? I tried this but it doesn't seem to work.

 

<%filter%>((field[Category] = "My Category") and not (relationship.exists forwards using field["My Relationship Field"]))<%endfilter%>

I am able to achieve this by using <%beginrelationshipsdetailL2 My Relationship Field%> and  <%beginrelationshipsection none%> but I believe this is resulting in extra processing.

Best answer by nborrerojr.

Looks like you just do...

<%filter%>((field[Category] = "My Category") and (field["My Relationship Field"] = ))<%endfilter%>

It is a lot quicker than querying the relationship separately and using <%beginrelationshipsection none%>. Having nothing on the right of the equals sign seems kind of weird but it appears to be working.

 

1 reply

N
nborrerojr.1-VisitorAuthorAnswer
1-Visitor
March 27, 2019

Looks like you just do...

<%filter%>((field[Category] = "My Category") and (field["My Relationship Field"] = ))<%endfilter%>

It is a lot quicker than querying the relationship separately and using <%beginrelationshipsection none%>. Having nothing on the right of the equals sign seems kind of weird but it appears to be working.

 

Terms & ConditionsAccessibility statement