MikeKD Posted September 5, 2017 Share Posted September 5, 2017 (edited) 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 Link to comment Share on other sites More sharing options...
MikeKD Posted September 6, 2017 Author Share Posted September 6, 2017 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 Link to comment Share on other sites More sharing options...
MikeKD Posted September 6, 2017 Author Share Posted September 6, 2017 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now