[Music Lover]

Is there a easy and quick way to see which song have a MIDI command added and which one does not.  To open the hundreds and hundreds of song sheets one by one to check and see which one I missed adding a MIDI command is not that practical.

[Zubersoft]

At the moment, I do not support a filter for that. You can modify the song title formatting to list MIDI commands in the title or caption, and then you could scroll through and identify which songs don't have a MIDI command. There are other approaches you could use as well, such as specifically filtering for a MIDI command in the title and/or caption after making that change, then select all those songs, add a new piece of metadata, then filter on that metadata with the dropdown set to "Exclude", and it would only then display songs without a MIDI command. 

Alternatively, you can run queries against the database itself (which is more complex than it sounds) to identify which songs have MIDI commands and which do not.

Mike

[keithwjones]

I was looking at this from a another angle, but same issue. 

Whether I had set the reference number in Pa4X Songbook. 

I came to the conclusion that simplest way was modifying song title.

Keith

[Music Lover]

Thanks for the suggestions.  I guess I can add those songs that I have added a MIDI command to a specific Collections or Genre etc. to filter them out going forward but is there a way to find which ones I have done already.  Do you have an example SQL Query that I can try to run against my database using Microsoft Access to try and find the name of the songs that have a MIDI command added.

Thanks again for all your help.