I have this XML code that I sued to create a Custom Filter on a List
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="cr7d0_newtable">
<link-entity name="contact" from="contactid" to="cr7d0_contributor_1" alias="contributor1">
<filter type="and">
<condition attribute="contactid" operator="eq" value="{{ user.contactid }}" />
</filter>
</link-entity>
</entity>
</fetch>
The main purpose of this is to filter the list based on the Contact Logged
The list has up to 5 Columns called Contributor_1 to Contributor_5 these columns are type Lookup to the Contacts table
So when a user submit a record they can add contributors to the record and when it is done, the user can see the records created by them but also the records where they are listed as contributors.
but when I apply this filter I got no records filtered just an error