Well, now that I'm going to commit to SQLNotes, I'm going to have lots of suggestions for it. Here's my first one.
Searching should be an essential feature of the program. Other notetaking software like EverNote and Zoot have awesome searching capabilities. If SQLNotes is used like I'm thinking it's going to be used, it's going to have a ton of information, and it should be easy to find what you're looking for, especially if you don't remember where you put it. RIght now, SQLNote's search doesn't work at all for me, but I think it's because I deleted the Search grid that came default. For some reason, it doesn't work in the default database for me, I don't know why. Anyway, I'm sure PPL will beef up the search, it's pretty important.
It is a good idea to dedicate a grid for search results. If the original is deleted, create a new grid and check "detault grid for search results" in the grid properties
To search, simply hit CTRL-F. type what you want to find
- for text: enter the text, use the comma to separate text blocks
- for dates: enter the date to search
- for number: enter the number you're looking for
You can specify what field to search for, or leave blank to search all fields
You can specify a source grid to limit the search to items in that grid
You can choose where to put the results. Leave blank to show it in the default search grid
If the search results are not quite what you want, you can edit the filter box which was generated by the search
You can specify a source to the search results grid. This will be taken into account. i.e. you want to exclude old stuff, you can put ItemCreated > now - 365 to search in the last year
History is coming soon (browse back, forward) to quickly go back to a previous grid state.