How to order clips in menu of virtual folder?

[Renegade]

Is there any way that I can specify the order that clips are in for a virtual folder?

e.g. Say I have 4 clips:

2 - blah
3 - blah blah
4 - blah bloo
1 - blah blee

But I want them ordered like this:

1 - blah blee
2 - blah
3 - blah blah
4 - blah bloo

So when I press '1', instead of "2 - blah" I get "1 - blah blee".

[mouser]

You do this by setting the Ordering column value for the clips.  If you don't see this column in the grid, click on the tiny button on left hand of header to enable it.

[Renegade]

Thanks. I see that there now.

But it's in the exact opposite order that I put it in. i.e. For the 6 clips I have, the one that I specify as 1 comes out as 6 in the popup context menu.

Is that by design?

[mouser]

hmm i suppose that is confusing, but it is by design.. you dont control the actual numbering, just the ordering, and smaller numbers bubble up to the top.

[Renegade]

Ah... I see... It's a priority for placement at the top of the list, and not an "order". So, the largest number that I use gets #1 placement in the context menu.

[Renegade]

I just noticed that I can use negative numbers even! Excellent! That makes it very easy to add new items to the bottom of the menu! 

[tomos]

I just noticed that I can use negative numbers even! Excellent! That makes it very easy to add new items to the bottom of the menu! 

-Renegade (September 07, 2012, 12:27 AM)

I'll have to revisit options - any tips how all this is done?

[Renegade]

Click the thingy there:



Then check "Ordering":



Then type the PRIORITY in the "Ordering" column (shown in first screenshot above). That is, the priority towards the top of the context menu, i.e. higher numbers go at the top, while lower (or negative) numbers go at the bottom.

[tomos]

Thanks Ren

[Renegade]

Oh, I should post this too:



There you can see that my "-2" priority is there at position #8 at the bottom. It's the same entry as you see in the screenshot above.

[tomos]

Sorted here, thanks Ren

For the record (still on-topic)

I believe (but not 100% sure) that the default sort in the pop-up list involves moving a pasted clip to the top of the list (i.e. sort by last use). This is dictated by:

In the CHS window, right-click on the folder and click Edit this group.
Down the bottom are the sorting criteria:  

[Renegade]

I find the SQL stuff all very confusing. There's nothing in the help file to explain it.

Looking at the "Custom Menu Sorting SQL" field, I have this:

Ordering,ModificationDateTime

And I guess that it is supposed to be a WHERE clause, but I don't know what fields are available. The help file lists these:


Fields available for sql statements:

· Index
· UserKeywords
· ClipType
· ParentId
· ParentGroup
· OtherGroups
· Application
· Title
· Description
· ImageIndex
· ExcerptText
· ClipText
· CreationDateTime
· ModificationDateTime
· ViewDateTime
· MarkDateTime
· DueDateTime
· Image
· Thumbnail
· Blob
· IsFavorite
· UserFlag
· UserCheckbox
· UserRating
· Protected

But "Ordering" isn't in there. So, I'm not exactly certain how to use any of it.

For example, can I do this?

Ordering DESC, ModificationDateTime ASC

Or can we try some SQL injection?

Ordering; DROP TABL; --

[tomos]

But "Ordering" isn't in there.

-Renegade (September 07, 2012, 04:24 AM)

"Ordering" is realtively new so probably help file not up to date.
Just tried ASC and DESC - dont seem to make any difference (? need a restart maybe) but havent otherwise experimented

Related thread - can I add new favourite to "end" of list? but nothing else new there really

[Pez]

I'm running v2.41.0
Just modified the 'Custom Menu Sorting SQL' option at the bottom of the 'My Favorites' Group to this:
"Ordering DESC,ModificationDateTime"
and it works; records with a smaller 'Ordering' value appear first with higher values appearing next

[mouser]

Or can we try some SQL injection?

Yep, you will be able to do sql injection on your own clip database and delete it if you try hard.