Portal Filters multiple things Whaaaaaaaat?

[RyanTech Engineering]

Ok, just wondering... If one would like to filter a portal with multiple "Strings" would one use a "If" or a "case" 

 

I am trying to Filter on 3 items and using the "Case" statement I'm only able to achieve 2....... Help !

 

Here's what I have so far

 

 

Case(

InspectionWork::Sample Complete="Complete";"";

InspectionWork::Sample Complete="Revising"

)

 

if I put a 3rd in like (On-Site) ...... it doesn't do its JOB !!

 

 

 

why only 2?

 

[doughemi]

You haven't put a result in your second case, so FM is seeing the third case as the second result.

 

 

Case(

InspectionWork::Sample Complete="Complete";"";

InspectionWork::Sample Complete="Revising"; "SomeString";

InspectionWork::Sample Complete="On-Site"; "SomeOtherString";

)

[mr_vodka]

Portal filtering is based on boolean results. From what I have read it seems as though you may be looking to show records with a particular status.

 

To show records that only display records with a Sample Complete of "Revising" or "On-Site" then try something like:

 

Sample Complete="Revising" OR Sample Complete="On-Site"

[RyanTech Engineering]

Actually I'm needing all three Filters

 

"On-Site"

"Revision"

"Complete"

 

what would it look like?

[bruceR]

Case(

InspectionWork::Sample Complete="Complete";1;

InspectionWork::Sample Complete="Revision"; 1 ;

InspectionWork::Sample Complete="On-Site"; 1

)

[David Jondreau]

There's a bunch of ways to do this...this is another

 

not isEmpty ( FilterValues ( List ( "Revising" ; "On-Site" ; "Complete ) ; Sample Complete ) )

[RyanTech Engineering]

Like always, you guys are great! 

I hope someday I will understand this stuff, like all of you do

 

Filemaker is absolutely the Best !

 

Thanks Again

 -sr