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
  • December 11, 2016, 07:54:28 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: Virtual Folders  (Read 1958 times)

e731997

  • Participant
  • Joined in 2013
  • *
  • default avatar
  • Posts: 6
    • View Profile
    • Donate to Member
Virtual Folders
« on: April 05, 2013, 07:58:33 AM »
What is the Database Fieldname for Notes?
I have ((Lower(ClipText) LIKE '%string%') working but I want to also filter on the Notes field.

Is there a list of all Database Fieldnames?

Thanks.


mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,435
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Virtual Folders
« Reply #1 on: April 06, 2013, 12:51:40 PM »
Welcome to the site e731997. That's a hard name to pronounce!

The list of fields from the help file is:
  • Index
  • UserKeywords
  • ClipType
  • ParentId
  • ParentGroup
  • OtherGroups
  • Application
  • Title
  • Description <--- this is actually the NOTES field
  • ImageIndex
  • ExcerptText
  • ClipText
  • CreationDateTime
  • ModificationDateTime
  • ViewDateTime
  • MarkDateTime
  • DueDateTime
  • IsFavorite
  • UserFlag
  • UserCheckbox
  • UserRating
  • Protected

Let me know if you have any problem with the virtual folder filter.

e731997

  • Participant
  • Joined in 2013
  • *
  • default avatar
  • Posts: 6
    • View Profile
    • Donate to Member
Re: Virtual Folders
« Reply #2 on: April 06, 2013, 08:49:38 PM »
Thanks Mouser!

It worked perfectly.

1. Is there any documentation on all the fields the 22 fields that you quoted?

2. In Virtual Folders there is an option of leaving the SQL checkbox unchecked. What feature does that provide?

3. How is "My Notes" intended to be used? I see that the SQL checkbox is unchecked.

Thanks







mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,435
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Virtual Folders
« Reply #3 on: April 07, 2013, 12:16:10 AM »
Quote
1. Is there any documentation on all the fields the 22 fields that you quoted?

I'm afraid not.. I really should try to write up more documentation on them.. The most important trick is to know how to show those columns so that you can see what they contain.  To show/hide columns click on the tiny button at the far left of the column header in the grid:
040713_0014_ver001.png

Quote
2. In Virtual Folders there is an option of leaving the SQL checkbox unchecked. What feature does that provide?


If you uncheck the "SQL" checkbox, then you just have a normal (non-virtual) group which contains the items dropped into it.

Quote
3. How is "My Notes" intended to be used? I see that the SQL checkbox is unchecked.

What exactly are we talking about when we say "My Notes"?

e731997

  • Participant
  • Joined in 2013
  • *
  • default avatar
  • Posts: 6
    • View Profile
    • Donate to Member
Re: Virtual Folders
« Reply #4 on: April 07, 2013, 01:50:53 PM »
I see:

Clipboard
My Favorites
Quick Paste
Virtual Folders
My Notes  <---------------------
Recycle Bin

How is it used?

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,435
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Virtual Folders
« Reply #5 on: April 07, 2013, 02:12:54 PM »
ha, ok i don't have that group -- i must have added it in more recent version.  it's just a group you can put stuff in if you want.  it has no special use.

e731997

  • Participant
  • Joined in 2013
  • *
  • default avatar
  • Posts: 6
    • View Profile
    • Donate to Member
Re: Virtual Folders
« Reply #6 on: April 07, 2013, 08:10:53 PM »
How would I put stuff into it? All clipboard entries go into Clipboard old or new.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,435
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: Virtual Folders
« Reply #7 on: April 09, 2013, 09:15:35 PM »
You would just drag+drop into it, or select it and click the AddNote button, etc.
It's basically just a container available for you if you want to put clips into it.