Main Area and Open Discussion > General Software Discussion
SQLNotes...what is it exactly?
PPLandry:
1. You're not too far. In your filter, you must say which field to filter:
MusicItem="Gene harris". You can also use the Alpha toolbar: MusicItem and click the G or type Gene in the associated text box
2. You can use the Check field (or another). Simply check the items you want and set the source (or filter) to Check
superboyac:
1. You're not too far. In your filter, you must say which field to filter:
MusicItem="Gene harris". You can also use the Alpha toolbar: MusicItem and click the G or type Gene in the associated text box
2. You can use the Check field (or another). Simply check the items you want and set the source (or filter) to Check
-PPLandry (December 04, 2007, 10:33 AM)
--- End quote ---
1) It still doesn't work for me. There are 3 places to type in the bar, and none of them worked. I opened up the alpha toolbar and type "gene", but you see how my top-level item is "Gene Harris"? It only filtered the sub items and only the albums that had the words "gene harris" in the album title, which is only a few of them. How come it doesn't show everything under Gene Harris since the top level matches the filter?
2) Here's the problem with the check. The check box would just be another field right? What if I have thousands of artists and I want to have several grids showing a different collection of artists. Do I have to make a separate check box field for each grid? Because, if I understand correctly, the check box field (and it's state of checked/unchecked) will be stored with the item itself. So, for one grid, it will be checked, and for another it needs to be unchecked.
Is there any plans to have a more "manual" way of showing what appears in the grid? I mean, it's very powerful to have the filters there for situations where your selection can be defined by logical means (all albums which this artist appears on, all albums made after 1995, etc.). But what if you want to make some grids based on purely arbitrary and random choices? I understand that all the items are stored in the database and the grids only display what you want to see from that database. Is there a way (now or planned for the future) to be able to pick and choose individual, random items from the database pool and stick it inside a grid?
PPLandry:
>Is there any plans to have a more "manual" way of showing what appears in the grid?
Search has been expanded. Simply type in the list of items (or parts of), or list of IDItem and it will display them.
>Is there a way (now or planned for the future) to be able to pick and choose individual, random items from the database pool and stick it inside a grid?
Yes, simply create a new grid, name it Set1. Open your main grid and have them side-by-side (right-click on tab and choose move to...). Now drag-drop items from one to the other (Press CTRL to not remove it from the first grid). There is some fine-tuning to do on my part ot make it work smoothly, but this is another way.
PPLandry:
2 pages were added to the wikispace:
1- How to use SQLNotes fields
2- How to import data from other programs (in particular Outlook) into SQLNotes
http://sqlnotes.wikispaces.com/
superboyac:
PPL, how do I copy multiple items within SQL? What if I want to copy some items from one column into another colomn, and I also want to retain the tree structure? Look at my screenshot below, I want to copy all the musicitem data into the Item column and also retain the tree structure. It doesn't work if I select them all and do a copy/paste.
I don't know if SN already has the ability, but there should be several ways to copy/paste within the program, kind of like Excel's "paste special". For example, copying an item including all children item, copying an item without children item, copying only the formatting of an item, etc.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version