Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • June 26, 2017, 10:44:42 AM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: How to order clips in menu of virtual folder?  (Read 3781 times)

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,237
    • View Profile
    • Donate to Member
How to order clips in menu of virtual folder?
« on: September 06, 2012, 10:34:55 AM »
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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 37,137
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #1 on: September 06, 2012, 10:40:11 AM »
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

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,237
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #2 on: September 06, 2012, 11:02:19 AM »
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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 37,137
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #3 on: September 06, 2012, 11:04:38 AM »
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

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,237
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #4 on: September 06, 2012, 11:17:14 AM »
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

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,237
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #5 on: September 07, 2012, 12:27:25 AM »
I just noticed that I can use negative numbers even! Excellent! :D That makes it very easy to add new items to the bottom of the menu!  :up:

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 10,677
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #6 on: September 07, 2012, 02:48:51 AM »
I just noticed that I can use negative numbers even! Excellent! :D That makes it very easy to add new items to the bottom of the menu!  :up:

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

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,237
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #7 on: September 07, 2012, 03:14:55 AM »
Click the thingy there:

Screenshot - 2012-09-07 , 6_11_04 PM.png

Then check "Ordering":

Screenshot - 2012-09-07 , 6_11_21 PM.png

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

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 10,677
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #8 on: September 07, 2012, 03:22:47 AM »
Thanks Ren :up:

Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,237
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #9 on: September 07, 2012, 03:24:12 AM »
Oh, I should post this too:

Screenshot - 2012-09-07 , 6_17_19 PM.png

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

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 10,677
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #10 on: September 07, 2012, 03:46:57 AM »
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:  

Screenshot - 2012-09-07 , 10_37_17.png


Renegade

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 13,237
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #11 on: September 07, 2012, 04:24:34 AM »
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

« Last Edit: April 21, 2017, 07:49:53 AM by mouser »

tomos

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 10,677
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #12 on: September 07, 2012, 07:11:00 AM »
But "Ordering" isn't in there.

"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

  • Participant
  • Joined in 2017
  • *
  • Posts: 1
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #13 on: April 21, 2017, 05:35:56 AM »
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

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 37,137
    • View Profile
    • Donate to Member
Re: How to order clips in menu of virtual folder?
« Reply #14 on: April 21, 2017, 07:50:43 AM »
Quote
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.