I'm new to this component,so i'm maybe asking a stupid question,but here it is:
I wanted to make a query that sorts the files from the media library by their rating,now rating is not a tag
in my case,but calculated based on other tags,so i craeted a query:
format:$puts(decreaserange,15)
$puts(sysmonth,$num($substr(%systemdate%,6,7),2))
$puts(sysday,$num($substr(%systemdate%,9,10),2))
$puts(sysyear,$num($substr(%systemdate%,1,4),4))
$puts(month,$mul(30,$get(sysmonth)))
$puts(day,$get(sysday))
$puts(year,$mul(365,$get(sysyear)))
$puts(date,$add($get(month),$get(day),$get(year)))
$puts(symbol,$char(9608))
$puts(fmonth,$mul(30,$num($substr(%first_played%,6,7),2)))
$puts(fday,$num($substr(%first_played%,9,10),2))
$puts(fyear,$mul(365,$num($substr(%first_played%,1,4),4)))
$puts(fdate,$add($get(fmonth),$get(fday),$get(fyear)))
$if($stricmp($get(fdate),0),$puts(fdate,$get(date)))
$puts(daterange,$sub($get(date),$get(fdate)))
$puts(fix,$div($get(daterange),$get(decreaserange)))
$if(%play_count%,$puts(rating,%play_count%),$puts(rating,0))
$if($greater(%play_count%,5),$puts(rating,$sub(5,$get(fix))),
$puts(rating,$sub($get(rating),$get(fix))))
$if($greater(-5,$get(rating)),$puts(rating,-5))
$if($greater($get(rating),5),$puts(rating,5))
$get(rating)
That calculates the rating of the tracks,but i don't know how to get it displayed in the decreasing order
(the rating value is between -5 and 5 and it getting mixed up,@default doesn't help much)
Any help appreciated