I have a Custom Module called "Membership".
It has 2 properties with a field type of CRM record
When I try to filter by the Primary Member, my search works. However, when I search by the Seconday member, I get the following error:
Sec:Liquid Error: 22P02: invalid input syntax for type integer: ""
Primary Member: CRM ID is 1792
{% component source: "Membership", layout: "Test Layout", filterBy: "PrimaryMember", filterValue: "1792", object: "item", type: "module" %}Secondary Member: CRM Id is 43391
{% component source: "Membership", layout: "Test Layout", filterBy: "SecondaryMember", filterValue: "43391", object: "item", type: "module" %}Liquid Error: 22P02: invalid input syntax for type integer: ""
If I change to regular text field - using SecondaryMemberId instead of SecondaryMember:
Secondary Member: CRM Id is 43391
{% component source: "Membership", layout: "Test Layout", filterBy: "SecondaryMemberId", filterValue: "43391", object: "item", type: "module" %}