Jump to content
MikeKD

Filtered Portal

Recommended Posts

MikeKD    7

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 by MikeKD

Share this post


Link to post
Share on other sites
MikeKD    7

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

Share this post


Link to post
Share on other sites
MikeKD    7

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 ))
)
)

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


×

Important Information

By using this site, you agree to our Terms of Use.