INTERACT FORUM
More => Old Versions => Media Center 17 => Topic started by: rossp on April 27, 2012, 08:53:08 am
-
Hi all, Can someone help me with a library view that will list movies by date imported and grouped by month.
Ross
-
Which type of view? Panes, Categories?
-
Panes
-
Something like this (see attached)?
I haven't addressed the file list grouping, sorting; I'm not entirely clear how you want the view.
[edit: screenshot updated w/correct expression.]
-
Interesting Mr C, The only months that show up in my view are Dec and Jan. But I imported movies this month?
Ross
-
A morning, single-cup of coffee, MrC error.
FormatDate([Date Imported,0], MMMM)
-
Brilliant, Can we change the first pane to be year imported.
-
Sure, you can do that. See the FormatDate() expression (http://wiki.jriver.com/index.php/Media_Center_expression_language#FormatDate.28....29:_Formats_a_date_value_in_a_specified_manner). It shows the formatting templates that you can use from any date field. Just replace the Date Imported library field in the view's first column with an expression field instead (like Month).
Once you like this, if you're interested, you can get the years/months to nest in a single pane.
-
Got it Mr C
FormatDate([Date Imported,0], Year)
-
Mr C you are a star thanks.
-
Thanks. And now back to my coffee and peach greek yogurt.
-
One last thing - in the Month pane the months are listed alphabetically. Can we list them in month order?
April
February
January
March
should be
Jan
Feb
Mar
Apr
Ross
-
FormatDate([Date Imported,0], MMMM)&datatype=[month]
See also: Specify data types for expression based fields (http://wiki.jriver.com/index.php/Media_Center_expression_language#Specify_data_types_for_expression_based_fields).
-
Holy sh*$ Mr C. I knew you were good but this is ridiculous........
-
It's the Chobani. :D
-
Enjoy you have earned your Chobani ;D
-
OK you've got me interested now. How do you can get the years/months to nest in a single pane.
Ross
-
Add this as the expression for a pane column:
FormatDate([Date Imported,0], Year)\/
FormatDate([Date Imported,0], Month)/
&datatype=[list]
The backslash is the list hierarchy separator for levels in a pane column (e.g. B will be indented when A\B is presented). It is enabled by forcing the datatype to list: &datatype=[list]. Unfortunately, only one datatype can be specified, so you'll lose the alphabetical month sorting. You could use numeric sorting.
Edit: You can set the field's Sort order to be Date Imported. This should sort nicely.
-
Nice ;D
-
See edit above.
-
How can you do to show?
Genre>Styles
Where styles field is a (semicolon delimited) where is only take the first line and the rest no.
[Genre,0]\/
[Styles]/
&datatype=[ list ] (edit don't let me write the correct line :) )
-
You have to perform a little magic to turn this:
[Genre] G
[Style] S1; S2; S3
into:
G\S1; G\S2; G\S3
You use Replace() to replace the semicolon with the entire [Genre] string with a preceding semicolon:
Replace(;/ [Style], ;/ , ;[Genre]\)&datatype=[list]
By appending a semicolon-space to the beginning of Style, we're working on:
; S1; S2; S3
and by replacing the semicolon/space with ;[Genre]\, we get:
;[Genre]\S1;[Genre]\S2;[Genre]\S3
And when interpreted as a list, this is exactly the list:
[Genre]\S1
[Genre]\S2
[Genre]\S3
btw. use [nobbc] [/nobbc] BBCodes around the [list] portion of your code to have it appear correctly here on the forum.
-
You have my bow mate :)
Ty for the code
And i have another if you can help there
Want to set a decades (grouped) let say 2000-2009>year, but so far i just fail reproducing the right code. So i sticked with [year] and grouped on 10. But if i want that i can't integrate year as you do there.
Can be possible?
I have a field called [decade] ListCombine([1950s], [1960s], [1970s], [1980s], [1990s], [2000s], [2010s], ), but it doesn't help me at all.
-
if(
isempty([year]),
Unassigned,
FormatDate([Date, 0], Decade)\[Year]
)&DataType=[list]
-
if(
isempty([year]),
Unassigned,
FormatDate([Date, 0], Decade)\[Year]
)&DataType=[list]
Copy/pasted that, but I only get this:
-
Works here.
Try adding a sequence of expression columns to test. Add these values, one per column:
[year]
isempty([year])
[Date, 0]
FormatDate([Date, 0], Decade)
Also, look at the values you see under the U-Z section.
-
Copy/pasted that, but I only get this:
It looks like you have grouping activated. Try to deselect grouping in Customize view.
-
Ah, that's it.
Grouping should be disabled by default once an expression is entered. This is a nasty hidden gotcha. I think I now recall you've helped someone else with this problem recently.
-
Yes, the grouping was activated, but I never did this. Good to know, what the default is.
Thanks for prompt response, I like the speed here ;D
-
Nice detective work figuring this out.
Next build:
Fixed: It was possible to set a category as 'Grouped', then switch it to an expression (which doesn't support grouping), and then have a broken pane or view.
-
Next build:
Fixed: It was possible to set a category as 'Grouped', then switch it to an expression (which doesn't support grouping), and then have a broken pane or view.
Are you sure about this? I kind of liked the workaround to get grouping in an expression category/pane. (I do not think the pane/view is "broken" when you intentionally use grouping.) Would it be possible to instead enable grouping for expression categories/views?
-
Are you sure about this? I kind of liked the workaround to get grouping in an expression category/pane. (I do not think the pane/view is "broken" when you intentionally use grouping.) Would it be possible to instead enable grouping for expression categories/views?
I tried to group an expression in one of my theater view views the other day and found I couldn't, so I'd support this request.
R.