Merged database queries

[mvallevand]

I want to be to able to filter out on specific channels in a sql call and I was wondering if the channel tables for merged channels repeats the name and channel number repeated for all the merged channels and just the channel.oid is different

As an example a query that works with unmerged data would be

Code:

select scheduled_recording.name, event_details, channel.number
from scheduled_recording, channel
where scheduled_recording.channel_oid = channel.oid
and channel.number  not in (3, 7)

Would this work the same with merged channels?

Martin

[sub]

Assuming that query works on normal channels, then it should also work on channels that have been merged. When you have merged channels, then still only have a single entry in the CHANNEL table. The only difference is they can have more than one entry per channel in the CHANNEL_MAPPING table.

[mvallevand]

So maybe I made a wrong assumption is

scheduled_recording.channel_oid = channel.oid or channel_mapping.channel_oid

Martin

[sub]

scheduled_recording.channel_oid = channel.oid. ie, you want to record a specific channel, for example CNN. This particular field doesnt relat to the device that'll do the recording.

scheduled_recording.capture_source_oid indirectly leads to a channel_mapping entry at recording time (when it looks for a channel mapping with that capture_source_oid and channel_oid). ie, looking for a channel mapping on that source that'll give the device the info it needs to record that particular channel.

[mvallevand]

Ok, thanks, I will give the code a try and see how it works in the wild.


Martin