快速登录:  

Forum: VirtualDJ Technical Support

话题: Number of compatable

由于该帖子已年深日久,可能包含陈旧过时或描述错误的信息。

bogartPRO InfinityMember since 2004
Using the compatible filter folder is there a way to show
only a certain number of compatible tunes?
For example you only want to show 20 tunes that are compatible.
Any ideas please?

 

发表时间 Mon 04 Feb 19 @ 8:23 pm
How should the filter determine which 20 files to show ?
If 100 files are compatible and it should show 20, there should be another criteria to determine which 20 to show, no ?

So, let us know what you think and we may come back with a better filter query for your case! :)
 

发表时间 Mon 04 Feb 19 @ 10:44 pm
NicotuxHome userMember since 2014
If only the 20 first matching ones are needed you can add "top 20 " at start of the filter as shown on an example in the filter modification dialog
 

发表时间 Tue 05 Feb 19 @ 7:24 am
PachNPRO InfinityMember since 2009
The "Top" Keyword doesn't work in this case.

But since it's already there in should work in my opinion.
I don't know how VDJ fetches its results, I think it has to be some kind of SQL structure so it should be pretty simple to add the "top" keyword.

Another thing, wasn't there something like asc or desc with the "sort by" command?

I tried this, but didn't work:


top 20 Bpm Difference <2 and Key Difference <1 and exists = 1 sort by play count desc

top 20 Bpm Difference <2 and Key Difference <1 and exists = 1 sort by play count ascending
 

发表时间 Tue 05 Feb 19 @ 9:50 am
NicotuxHome userMember since 2014
top 20 exists and Bpm Difference <2 and Key Difference <1 sort by play count


desc / ascending are erroneous for me
 

发表时间 Tue 05 Feb 19 @ 10:35 am
bogartPRO InfinityMember since 2004
PhantomDeejay wrote :
How should the filter determine which 20 files to show ?
If 100 files are compatible and it should show 20, there should be another criteria to determine which 20 to show, no ?

So, let us know what you think and we may come back with a better filter query for your case! :)


Basically just as it shows the compatible now: just limit it to say 20 songs.

Also version 4742, does not have the Top 20.
 

发表时间 Tue 05 Feb 19 @ 6:26 pm
NicotuxHome userMember since 2014
?? version 4742 does not have the Top 20 ?? What do you mean ?

the full scrip is in short words :

. top 20 exists and bpmdiff <2 and keydiff <1 sort by nbplay invert

and it works like a charm with v4742

bpmdiff keydiff and nbplay are shortwords to respective long syntax
"invert" is the word for descending, sort is ascending by default

you may enhance this filter by adding Not already played:

. top 20 exists and bpmdiff <2 and keydiff <1 and alreadyplayed=0 sort by nbplay invert
 

发表时间 Tue 05 Feb 19 @ 7:12 pm
PachNPRO InfinityMember since 2009
Nicotux wrote :
top 20 exists and Bpm Difference <2 and Key Difference <1 sort by play count


desc / ascending are erroneous for me


I know that doesn't work, but it should work like this.
It's more common and more readable compared to inverting the result.
 

发表时间 Fri 08 Feb 19 @ 11:05 am
NicotuxHome userMember since 2014
In fact it look like does. we simply don't know enough about filters

top 20 nbplay&bpmdiff<2&keydiff<1

Top 20 Play Count and Bpm Difference < 2 and Key Difference < 1

it seems "Top" is forcing sort field
 

发表时间 Sat 09 Feb 19 @ 2:34 am


(陈旧帖子或论坛版块会自动关闭)