Will UncleJohnsBand WebAdmin Searches work in v5 the same as in v4?

[mvallevand]

Padding is not guaranteed, but not sure what the priority is when there is prepadding in the postpadding area. Perphaps postpadding should have priority.

Regardless if there is an improvement in the logic it will be in v5 so you might as well upgrade.

Martin

[jksmurf]

Hi sub,

I have some requests/suggestions for how to make the Advanced option more user friendly, based on my UJB experience.

I appreciate the %XXX% is a way to do it, but I really found the select text boxes for various options, like Day of Week, Discrete Channels (not just 1 or ALL), Hours,  etc. very easy to use; and I really used them as shown in the examples below. Hours not shown as not enough attachment space.

Cheers,

k.

                   

[UncT]

Please do not forget my alphabetized "Manage Recordings" request. I have a lot of duplicates on the list right now.
Thanks in advance.

[daneo]

Hi Sub and Team,

any option to setup an advanced recording which would apply to only one Channel Group?

Thanks,
Dane

[mvallevand]

Yes if you can do it with sqlite, but really not related to this thread.

Martin

[daneo]

Hi Martin,

It remains related, as before you could search for a number of specific channels on a single query. This is no longer possible in the GUI, and it would be helpful if the Advanced search could do it with a specific query, however I see that the channel_oid and not the grouping. Maybe you would have to use a query like this?

(genres like '%Movie%' and channel_oid in ('7133', '7242', '7418')) -> only these channels, not sure if quotes needed

or

(genres like '%Movie%' and channel_oid not in ('7133', '7242', '7418')) -> any channel but these

SQLITE would be an option, but then I would have to replicate Sub's collision avoidance and tuner juggling multirec code - and it's not worth it.

Regards,
Dane

[mvallevand]

I meant if you can create a query in sqlite you could plug the where clause into an advanced query. NEWA didn't have that and if you continue to use this thread then people who actually want to used Advanced queries might not find it.

Code:

genres like '%Movie%' and channel_oid in
(select channel_oid from channel_group
where group_oid = 1)

Martin

[daneo]

I meant if you can create a query in sqlite you could plug the where clause into an advanced query.  NEWA didn't have that and if you continue to use this thread then people who actually want to used Advanced queries might not find it.

Code:

genres like '%Movie'% and channel_oid in
(select channel_oid from channel_group
where group_oid = 1)

Martin

Wow - this works like a dream - I am warming up to SQL lately.

[mvallevand]

Not perfect because originally I had a typo with the '% but you get the idea of how useful an advance query can be.

Martin