Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Dana Kisor]

I’m working in Business Central 18.3 (On Prem) and having trouble filtering a drop down list (field) completely. This is the code I have that works:

                field(FilteredSSPARTField; Rec.SSPART)

                {

                    ApplicationArea = Basic, Suite;

                    Caption = ‘SSPART(s)’;

                    LookupPageID = “Shared Option List”;

                    TableRelation = “Shared Option Lists”.“Option Description”

                    where(“List ID” = filter(‘SSPart’));

but it only filters on the List ID field. I want to filter on two fields: “List ID” and “Contract Price Bin”
If I hard code the value I want for Contract Price Bin, it works without issue:

                    where(“List ID” = filter(‘SSPart’), “Contract Price Bin” = filter(‘abc123’));

But I don’t want to hard code the value, I want to use the value of a field on the page. The page is populated by a record and has a populated field called “Contract Price Bin”.
But when I try to use that, I get an error:

Any Ideas how to make this work dynamicallly?

Thanks

——————————
Dana Kisor
Lead Programmer
Government Acquisitions, Inc
Cincinnati OH
——————————

[Dana Kisor]

Found the solution, thanks to a friend. Turns out my syntax was wrong. Instead of using the FILTER, I needed to use FIELD.
The corrected line of code looks like this.

                    where(“List ID” = filter(‘SSPart’), “Contract Price Bin” = field(“Contract Price Bin”));

——————————
Dana Kisor
Lead Programmer
Government Acquisitions, Inc
Cincinnati OH
——————————
——————————————-