Filtering Portal Record Does Not Produce Expected Result
See attached screenshot.
I inserted a one-row portal (red border) filtered for "Acute Serum DEN":
Human_Testing::cIllnessPhaseSampleTypeTestPerformed = "Acute Serum DEN".
The 8-row portal above the one-row portal shows all of the records (not filtered). The expected result of the filtered portal is the record highlighted with a green oval: SampleType = "Serum", IllnessPhase = "Acute", and TestPerformed = "DEN" (i.e., "Acute Serum DEN".
Instead, the portal filters out the record highlighted with a red oval: SampleType = "Serum", IllnessPhase = "Convalescent", and TestPerformed = "WEE IgM" (i.e., "Convalescent Serum WEE IgM).
Why is the filter not working?
I created a script to filter out records with "Acute Serum DEN", but it also filters out "Convalescent Serum WEE IgM":
S1OtherMethodDENV = If ( not IsEmpty ( Filter ( List (Human_Testing::cIllnessPhaseSampleType ) ; "Acute Serum DEN" ) ) ; Human_Testing::cIllnessPhaseSampleType ; " " )
My goal is to make this script work. I just created the one-row portal to troubleshoot the script. How do I get this script to work?