Virtual Folders

[e731997]

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]

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]

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]

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:

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.

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]

I see:

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

How is it used?

[mouser]

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]

How would I put stuff into it? All clipboard entries go into Clipboard old or new.

[mouser]

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.