More > Media Center 17

gappie: Data type of expression fields

(1/2) > >>

gappie:
that was the smoothest version upgrade so far.. picked up all my 16 settings. nice.

there seems to be a problem with the text under album thumbs when using an expression (or something has changed what i have not found yet).
i use an expression under my albums
--- Code: ---LP FormatNumber([Played Days Ago,0],1) days ago
--- End code ---
easy. where [played days ago] is a custom library field what does what it says, and that works. in 16 this expression would give me the average of [played days ago]. now i get values that do not make any sence when looking at [played days ago]...

 :)
gab

oh.. i see what it does now... when all the values are the same.. say 10, it gives 10. but when it says for instance 1, 100 , 100 ,3 (so the value is different for different songs of the album) it gives 0.

gappie:

--- Quote from: gappie on November 05, 2011, 08:00:37 am ---that was the smoothest version upgrade so far.. picked up all my 16 settings. nice.

there seems to be a problem with the text under album thumbs when using an expression (or something has changed what i have not found yet).
i use an expression under my albums
--- Code: ---LP FormatNumber([Played Days Ago,0],1) days ago
--- End code ---
easy. where [played days ago] is a custom library field what does what it says, and that works. in 16 this expression would give me the average of [played days ago]. now i get values that do not make any sence when looking at [played days ago]...

 :)
gab

oh.. i see what it does now... when all the values are the same.. say 10, it gives 10. but when it says for instance 1, 100 , 100 ,3 (so the value is different for different songs of the album) it gives 0.

--- End quote ---
to quote myself, and what has changed apparently..
in all the previous versions, when you wanted to use a custom calculated database field to behave as a list or as an integer, you first have to make the field and set the userdata to integer or list, close manage library fields>options and then open again and change it to calculated with the right expression. when i do that with mc 17 the user data is reset to string when i switch to calculated and behaves that way.

 :)
gab

Matt:

--- Quote from: gappie on November 05, 2011, 10:52:11 am ---to quote myself, and what has changed apparently..
in all the previous versions, when you wanted to use a custom calculated database field to behave as a list or as an integer, you first have to make the field and set the userdata to integer or list, close manage library fields>options and then open again and change it to calculated with the right expression. when i do that with mc 17 the user data is reset to string when i switch to calculated and behaves that way.

 :)
gab

--- End quote ---

You need to add a type to the expression if you want it to be something other than a string.

For example:
Math(1+2)&DataType=[Integer]

gappie:

--- Quote from: Matt on November 07, 2011, 11:47:07 am ---You need to add a type to the expression if you want it to be something other than a string.

For example:
Math(1+2)&DataType=[Integer]

--- End quote ---
thanks math,
up from 11 til 16 it worked. now it does not. and as far as i tested your solution is not only much more complicated, but does also not work. and i just checked, i did use math already in the lib field, but for the album thumb math wont do any good.. it stil is math([varies]).. and for mc that is 0.
ill make an separate thread later cause i think this will be a long discussion, and is really three steps back for the library..

 :)
gab

Matt:

--- Quote from: gappie on November 07, 2011, 01:52:05 pm ---your solution is not only much more complicated, but does also not work.
--- End quote ---

There was no solution for non-string expressions before.  You had found a backdoor to change the type, but that's not a less complicated solution.

Here are the supported types (the expression must end with exactly this including brackets around the type):
&DataType=[insert type here]

Where 'insert type here' is one of these
String
List
Integer
Number
Path
Month

Example:
--- Code: ---a;b;c&DataType=[List]

--- End code ---

Navigation

[0] Message Index

[#] Next page