DonationCoder.com Software > Clipboard Help+Spell

Virtual Folders

(1/2) > >>

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

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


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.
--- End quote ---

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?

Navigation

[0] Message Index

[#] Next page