• Square Box CatDV

  Non searchable metadata

  Posted by John Heagy on December 1, 2015 at 7:01 pm

  Unless I’m doing something wrong it seems there’s lots of field that are not searchable in a Query. The field I’m trying to search on is “Data Rate” but it’s not available in the selection list. Is there a way to add these omitted fields in a Query?

  Rolf Howarth replied 10 years, 5 months ago 3 Members · 2 Replies
• 2 Replies

• 

  Dougal Matthews

  December 2, 2015 at 12:08 pm

  Hi John

  I’m afraid not all metadata fields are searchable as they’re not actually stored as values but calculated for display data rate is one of these calculated values so not searchable.

  At the moment there is no easy way to “Add” them we would need to calculate the values then store them in the DB as fixed results I’ve asked for this to be considered for future development on server 7

  thank you Dougal

  Improvise Adapt and Overcome
• 

  Rolf Howarth

  December 3, 2015 at 8:10 pm

  Yes, unfortunately Data Rate is a good example of a “calculated field”. The database stores the file size and the clip duration so the data rate is calculated for display on the client but isn’t directly stored in the database, so isn’t available for searches.

  Certain hacks like writing a worker script to copy the data rate to a particular user field and then searching that might be possible but are unlikely to be perfect I’m afraid.

  -Rolf

Reply to this Discussion! Login or Sign Up