Krewe of Bonaparte

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" %}
Returns:

zz_TEST MEMBERSHIP - DO NOT DELETE - Shannon & Kirk Tester (Dual)


Secondary Member: CRM Id is 43391

{% component source: "Membership", layout: "Test Layout", filterBy: "SecondaryMember", filterValue: "43391", object: "item", type: "module" %}
Returns:

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" %}
Returns:

zz_TEST MEMBERSHIP - DO NOT DELETE - Shannon & Kirk Tester (Dual)

Mardi Gras Countdown

Days
Hours
Minutes
Seconds