Filtered Portal

[MikeKD]

Hi Folks,

I can't quite get my head around this one..

I have a portal that contains basic info about pieces of music. Each piece is either a work or a movement. (pieces are either self contained or consist of movements).

I'm using 2 globals and 1 local field to filter down the list of pieces:

1. Composer

2. Title

3. Work ID

This works almost as I'd like:

(
(
IsEmpty ( Resources::gSearchPieceTitle )
or
PatternCount ( Piece_forResourcesMenu::Piece Title ; Resources::gSearchPieceTitle )
)

and

(
IsEmpty ( Resources::gSearchPieceComposer )
 or 
PatternCount ( Piece_forResourcesMenu::cComposers ; Piece_forResourcesMenu::gComposerSelect )
)
)
OR
Resources::PickWork = Piece_forResourcesMenu::pkPieceID

The issue is that, if the last field (Resources::PickWork) finds matches, I don't want to see any of the others. I suspect that it's possible, but can't work out how to do it...

Best wishes,

Mike

Edited September 5, 2017 by MikeKD

[MikeKD]

Ah, I think I've got it - I'll use Case, testing for PickWork being empty or not. Will have a go when I get the chance...

Cheers!

Mike

[MikeKD]

Well this works, pretty much I think..

If anyone can see some improvements, I'd be glad to hear them!

Case ( 
not IsEmpty (Resources::PickWork) ; Resources::PickWork = Piece_forResourcesMenu::WorkID 
;
IsEmpty (Resources::PickWork) ;
(
(IsEmpty ( Resources::gSearchPieceTitle )
or
PatternCount ( Piece_forResourcesMenu::Piece Title ; Resources::gSearchPieceTitle ))
and
(IsEmpty ( Resources::gSearchPieceComposer )
or
PatternCount ( Piece_forResourcesMenu::cComposers ; Piece_forResourcesMenu::gComposerSelect ))
)
)