DonationCoder.com Software > Clipboard Help+Spell

sql statements help?

<< < (2/2)

IainB:

I see I actually do provide a list of fields in the Advanced Features->Virtual Folders page of help, which in online here:
https://www.donationcoder.com/Software/Mouser/clipboardhelpandspell/help/virtual_folders.htm
...
-mouser (August 03, 2012, 04:35 AM)
--- End quote ---
Oh. I already had those 22...
I was kinda hoping that you might have been about to enable a one-to-one relationship with the ID Fields, maybe?  (hint, hint)     :)

RashidMalik:
How do you write a query to filter results by dates?
For example, suppose I want to find clips older than, say 60 days?
OR
Clips that were taken between two dates?

IainB:
@mouser: I figured I should post this to re-open this thread, since the title is appropriate, the comment I want to make follows on from the 2nd comment above, and it fits with the suggestion made here:
... Mouser ... How about you then starting a (sticky?) SQL Expressions thread, posting a few examples and inviting users to post theirs and/or suggestions of how and why they use them? ...
_______________________
-DonationCoderTransmit (July 19, 2011, 06:16 AM)
--- End quote ---

Having done some exploration/discovery in CHS lately, I needed to update the table showing the one-to-one relationship between Grid Field<-->SQL term.
Are you able to confirm whether the table image below is correct and what the 5 unattached SQL items at the bottom are? (The text from the image is in the spoiler below it.)
(Thanks in advance.)



SpoilerMenu Image of fields   Field name   ID Menu Text   Fields available to SQL statements
      Sorted A-->Z
   ID (Record ID#)   1. Application   Application
   Parent Id (Virtual Folder ID#)   2. ApplicationPath   N/A
   Imagelndex   3. ClipFormat   N/A
   Title (Note/clip Title)   4. Created   CreationDateTime
   Ordering   5. DataSize   N/A
   Application   6. DueDate   DueDateTime
   Favorite? (True/False)   7. Excerpt   ExcerptText
   Created   8. Favorite? (True/False)   IsFavorite
   Modified   9. FileCount   N/A
   Viewed   10. FileList   N/A
   Marked   11. Flag   UserFlag
   DueDate   12. HashText   N/A
   Excerpt   13. ID (Record ID#)   Index
   Type   14. Imagelndex   ImageIndex
   Keywords   15. Keywords   UserKeywords
   Flag   16. Marked   MarkDateTime
   Rating   17. Modified   ModificationDateTime
   Notes   18. Notes   Description
   DataSize   19. Ordering   N/A
   ApplicationPath   20. ParentId (Virtual Folder ID#)   ParentId
   ClipFormat   21. Rating   UserRating
   FileList   22. Title   Title
   FileCount   23. Type   ClipType
   HashText   24. Viewed   ViewDateTime
         =============
         1. ClipText (text in Memo pane)
         2. OtherGroups (?)
         3. ParentGroup (?)
         4. Protected (?)
         5. UserCheckbox (?)

IainB:
Refer: Creating a virtual clip group in CHS to show you all clips with URLs in them
...you could change


--- ---(Lower(ClipText) LIKE '%http%') OR (Lower(ClipText) LIKE '%www.%')
to


--- ---(Lower(ClipText) LIKE '%http://%')
that will probably reduce the false positives.
_________________________
-mouser (October 19, 2006, 11:33 PM)
--- End quote ---

IainB:
From: Re: CLIPBOARD HELP+SPELL LATEST VERSION INFO THREAD - v2.25.03 Beta - Oct 5, 2014

New feature automates the creation of SQL for a new Virtual Folder, using the Search string. This (see emboldened item below) is potentially a real timesaver and can avoid having to mess about with SQL:

I've added a couple of important features to the beta; i'd appreciate any bug reports.
New stuff:

* [Feature] New clip grid menu items for creating new groups based on selection (moves clips) or search (creates a virtual group).
* [Feature] Group tree drop target is now highlighting while dragging over it.
* [Feature] Quick search/filter now provides a drop-down of favorite searches; set favorites in the Misc. Options 2 tab.
* [Feature] Better statusbar info about selected group; reports total # clips in view and # selected._____________________
-mouser (October 05, 2014, 02:41 PM)
--- End quote ---

Navigation

[0] Message Index

[*] Previous page