DonationCoder.com Software > Clipboard Help+Spell

How to order clips in menu of virtual folder?

<< < (3/3)

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; -- :P

tomos:
But "Ordering" isn't in there.
-Renegade (September 07, 2012, 04:24 AM)
--- End quote ---

"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?
--- End quote ---

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

Navigation

[0] Message Index

[*] Previous page