Multiple filters to a VFS view

[Gustovier]

All,

I seem to have a problem when creating a view multiple filters setup. For some reason phoenix doesn't like it. I'm trying to use the following 2 filters. But I see this happen whenever I use more than 1 filter no mater what type of filter it is.

<filter by="mediatype" scope="exclude" value="TV"/>

<filter by="missingmetadata" scope="exclude"/>

[bialio]

Two filters are not supported. You need to use a filter group instead. Look up in the filters sections for examples.

btl.

[stuckless]

The reason for not allowing multiple filters at the root level is really an issue of how do you interpret them.

<filter by="channel " value="1234"/>
<filter by="mediatype value="Movie"/>

Is that filter by channel = 1234 AND mediatype = Movie or is that filter by channel = 1234 OR mediatype = 'Movie'?

The reason for PQL was to solve this issue and to also offer other types of filtering. Currently PQL only support filtering on metadata fields, but it will be extended to support the existing filters as well.

I could add a new tag to <view> for <item-group> and then allow you to define filter groups inline in the view, but you can do that now in the <filters> section, so i haven't really put much effort into do that, since it'll be one more thing I need to parse/store about the view

[Gustovier]

well did try some pql cause at the time i couldnt figure out a solution.But its not working how i thought. Im trying to filter out unmatched and TV content. this didnt seem to filter out the tv content

<filter by="pql" value="MediaType is null or MediaTitle is null or MediaType = 'TV'"/>

[stuckless]

Originally Posted by Gustovier

well did try some pql cause at the time i couldnt figure out a solution.But its not working how i thought. Im trying to filter out unmatched and TV content. this didnt seem to filter out the tv content

<filter by="pql" value="MediaType is null or MediaTitle is null or MediaType = 'TV'"/>

I'm not quite sure what you mean by filter out unmatched content, but your querry will return all videos where the media type is TV or null or where the media title is null. (ie, if either mediatype or mediatitle is null or if mediatype is TV). I'm not sure that's what you want.

I think you might want

<filter by="pql" value="MediaType is null or (MediaTitle is null and MediaType = 'TV')"/>

This will return all files if the mediatype has not been set, or all files where the mediatitle is null and the media type is TV. Maybe if you could explain what it is that you are trying to return, then I can try to help you write a query.

[Gustovier]

I'm trying to filter out all unmatched(aka missing metadata) videos and media that's been tagged as TV

[stuckless]

Originally Posted by Gustovier

I'm trying to filter out all unmatched(aka missing metadata) videos and media that's been tagged as TV

This is pretty tricky (with or without pql). Files are not tagged as TV until they have metadata, so to find files that are tagged as TV but missing metadata can be a little tricky.

The following

MediaType = 'TV' and EpisodeNumber = 0

will return a list of tagged TV file that is missing the EpisodeNumber field, which is an indication the the file is missing metadata. Not sure this would return much, since again, BMT typically doesn't tag a file as being TV until it can get metadata.

A better approach would be to create a view of all recordings, and TV files (we probalby have that view already), and then just use the PQL

EpisodeNumber = 0

Since the view's source has already fetched all TV files, then this will now filter all those that have no episode number, which is probably what you want.

I hope this helps.

[wrems]

I created a multi-filtered view by creating a view with one filter then creating another view bringing in the original view and adding my second filter worked great!

I'd share what I did, but on vacation in sunny california!

[stuckless]

Originally Posted by wrems

I created a multi-filtered view by creating a view with one filter then creating another view bringing in the original view and adding my second filter worked great!

I'd share what I did, but on vacation in sunny california!

I'm hoping to be there in 2 weeks