AnsweredAssumed Answered

Filtering Portal Record Does Not Produce Expected Result

Question asked by evanscl on Apr 4, 2014
Latest reply on Apr 10, 2014 by philmodjunk

Title

Filtering Portal Record Does Not Produce Expected Result

Post

     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?

      

Filtering_Portal_Record.jpg

Outcomes