751
General Software Discussion / Re: SQLNotes...what is it exactly?
« Last post by Armando on November 12, 2008, 09:59 AM »Tom's advice is good.
J-Mac :
Like I said, there's stuff missing in the documentation, and yes, it might not be enough to understand why items appear and disappear. Obviously... if you don't know why some of your items disappeared.
This will get fixed in time. I will contribute, etc. And the UI will improve.
In the mean time :
Here are the areas/options that have a direct effect on what appears on a given grid.
1- the source box (main filter)
2a- the filter box (secondary filter)
2b- the date filter (This is just a convenient way of creating quick date filters without having to no any SQL syntax)
2c- the alpha numeric filter (This is just a convenient way of creating quick text/number filters without having to no any SQL syntax)
2d- filter applies to sub-items (will apply the filters -- not the source though -- to subitems)
3- context parents (will show the item's main parent in blue, if not meeting the grid's source/filter)
4- The various column filters (but these, right now, disappear after a refresh ; they're temporary)
Then there's also the Sort filter (+ sorting applies to sub-items) and the hierarchy mode, but these really, can't "remove" items from a grid. There really only for display.
Now, if any of your items don't show up in the grid, it might not be because you touched the filters, but it could also be because you've modified the items so that they don't match the filters anymore. This is very easy to do.
Otherwise, I don't see what could've happen. Like I said, it functions a bit like X1 or any searching software with filters : remove key words from a document, and it won't show up in the result area (the grid). Change the filters : displayed documents will change in the result area. That,s the basic idea.
------------
What I suggest is follow the steps I described earlier to find back your items (or you can also try to deactivate all previous options for a given grid : filter, alphanumeric, filter applies to sub-items, etc.) and then tick the field corresponding to the source of a given grid. And see what happens.
Then if you still don't see the item, deactivate all filters (there are buttons for that on the source bar... but the filter applies to sub-items is on an separate toolbar -- yes, this is a UI problem that will get fixed... it should just be an extension/"sub-button" of the other button).
The source bar was described (by Keith I think... Thanks Keith!) on the getting started page :
http://sqlnotes.wiki....com/Getting+started
The problem you describe (with sub-items showing at top-level) is still occurring, but it will get fixed... I've had a long conversation with Pierre yesterday, and a slightly new way of managing sources to have all sub-items meeting the source might also be created. But I'll let Pierre comment on that himself...
J-Mac :
Like I said, there's stuff missing in the documentation, and yes, it might not be enough to understand why items appear and disappear. Obviously... if you don't know why some of your items disappeared.
This will get fixed in time. I will contribute, etc. And the UI will improve.In the mean time :
Here are the areas/options that have a direct effect on what appears on a given grid.
1- the source box (main filter)
2a- the filter box (secondary filter)
2b- the date filter (This is just a convenient way of creating quick date filters without having to no any SQL syntax)
2c- the alpha numeric filter (This is just a convenient way of creating quick text/number filters without having to no any SQL syntax)
2d- filter applies to sub-items (will apply the filters -- not the source though -- to subitems)
3- context parents (will show the item's main parent in blue, if not meeting the grid's source/filter)
4- The various column filters (but these, right now, disappear after a refresh ; they're temporary)
Then there's also the Sort filter (+ sorting applies to sub-items) and the hierarchy mode, but these really, can't "remove" items from a grid. There really only for display.
Now, if any of your items don't show up in the grid, it might not be because you touched the filters, but it could also be because you've modified the items so that they don't match the filters anymore. This is very easy to do.
Otherwise, I don't see what could've happen. Like I said, it functions a bit like X1 or any searching software with filters : remove key words from a document, and it won't show up in the result area (the grid). Change the filters : displayed documents will change in the result area. That,s the basic idea.
------------
What I suggest is follow the steps I described earlier to find back your items (or you can also try to deactivate all previous options for a given grid : filter, alphanumeric, filter applies to sub-items, etc.) and then tick the field corresponding to the source of a given grid. And see what happens.
Then if you still don't see the item, deactivate all filters (there are buttons for that on the source bar... but the filter applies to sub-items is on an separate toolbar -- yes, this is a UI problem that will get fixed... it should just be an extension/"sub-button" of the other button).
The source bar was described (by Keith I think... Thanks Keith!) on the getting started page :
http://sqlnotes.wiki....com/Getting+started
RE all items meeting source or not -
I was happy with current situation (only top-level items meeting source) because it meant I could display hierarchy in an expected way
As far as I know if I use hierarchy display mode and some sub-items also meet source they are displayed twice (once as sub-item, once at top-level) which disturbed my sense of "order"
Correct me if I'm wrong there - I havent checked this in a long time so situation may have changed - will test it later
If I could get the display to ensure that an item only shows once (presuming it's only in grid once) I would be happy to have some sub-items meeting grid-source -as Pierre says sometimes it would be appropriate, sometimes not.-tomos (November 11, 2008, 03:00 AM)
The problem you describe (with sub-items showing at top-level) is still occurring, but it will get fixed... I've had a long conversation with Pierre yesterday, and a slightly new way of managing sources to have all sub-items meeting the source might also be created. But I'll let Pierre comment on that himself...


Recent Posts


- just goes to show how different we are, as people. I might wanted to say the exact opposite: FARR for everyday used programs, because those names I can remember, and LBC for the seldom used ones, because these names I most likely have forgotten. Anyway, as it happens I can't remember any names at all ~ I am not a 'keyboard maniac' ~ therefore: Congratulations to mouser on the major update of LauncBar Commander.
Smaller than a lot of modern laptops, but with a 3.25 MHz CPU, and and 1 KB of RAM -- although I thing we had 64 at the time...
