Jump to content

Filtered Portal


MikeKD

This topic is 2395 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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
Link to comment
Share on other sites

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

 

Link to comment
Share on other sites

This topic is 2395 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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