Add a (blank or not present) Attribute value selection in Hourly Templates

I think that in Hourly Templates in mAirListDB, it would be helpful to allow the user to select by the absence of an Attribute: that is, the item does not have that Attribute present, or its value is either null or all spaces.

This way, one could set up an Attribute and only mark SOME items with values. To take a simple example, if you had a Tempo attribute, with some items having the value Fast or Slow in that attribute, you would not then need to make every OTHER item have a value (which in this example would be Medium).

To acheive this, it would be necessary to add a ‘dummy’ value of something like (blank or not present) as the FIRST item in the dropdown selection list of the Attribute column of the Edit Hourly Template dialog; the underlying SQL query WHERE clause would then need to be something like:

WHERE ATTRIBUTE(blah) IS NULL OR TRIM(ATTRIBUTE(blah))=’’

BFN
CAD

No-one has any interest in this idea, then? OK. :-[

BFN
CAD

Low priority, huh?

:slight_smile:

BFN
CAD

Sounds good to me. Now that makes two of us ;D

Regards, Alec