 |
|
|
|
When did named filters slip? I just checked Mantis based on the latest release and based on the version and release frequency it seems to now be months away. Personally, that is my number one requirement.
d |
|
|
|
 |  |
|
|
|
Hi,
Named filters are planned for 0.9.26 according to Mantis. Plan is as follows
- 0.9.24: Offline mode
- 0.9.25: Calendar / alarms
- 0.9.26: Numerous smaller issues
If you so desire, I can move it up, to be part of 0.9.24 ...
In the meantime, perhaps you can share why it is so crutial for you, many users are doing just fine without it... Can you give examples? Pierre (Win XP Pro SP2, Admin, Auto-updates ON, Firefox, Acer TravelMate 660 graphics). |
|
|
|
 |  |
|
|
|
If I can chime in, this is also my number one at this time. Offline is low, low, low, because can use Win Offline files. Calendar is 2. But named filters would save a lot of time & add utility by not having to type custom filters often. I noted your spec was to allow them to be incrementally built by shift clicking, which would be fantastic.
The date & alpha filter bars do help a lot, but adding custom options (named filters) to this practice would be fantastic. I often want entries allocated to a person or team (applicable in various grids), combinations of status' & categories.
BTW, I have a current workaround that goes towards this. I edit the alpha filter toolbar letters to be the entries in a list (people's initials for allocated tasks), then I can just click on the entries in the toolbar to get the filter I want. I'm hoping named filters would let me do this universally, and for different datatypes. |
|
|
|
 |  |
|
|
|
not sure what exactly named filters are, but if they make filtering easier they take number one spot on my list too |
|
|
|
 |  |
|
|
|
OK, you win. I'll do it first thing on monday and will put it in an interim build. Pierre (Win XP Pro SP2, Admin, Auto-updates ON, Firefox, Acer TravelMate 660 graphics). |
|
|
|
 |  |
|
|
|
Please forgive me if I missed something...
But did named filters get implemented? Are they in the program somewhere and I'm unable to find them?
It could be that named filters would solve what I'm asking for, but what I would really like is a "global filter". I have everything in my database taged as either "home" or "work". What I would like to be able to do is set a global filter so that when I'm at work only work stuff shows in my grids and when I'm at home only home stuff shows.
I was recently playing with Ecco (I'd heard much talk of it, but had never acctualy looked at it before) and the ability to set a global filter (and add it as a toolbar button!) was awesome to me. I'd love to see SQL ntoes have something similar.
And if it's already there - I'm sure someone will straighten me out! :)
Thanks!
Laura |
|
|
|
 |  |
|
|
|
Named filters are coming. I've been busy fixing bugs...
In the meantime, you can use the AlphaFilter (Grid > Alpha-numeric filter) as a quick filter Pierre (Win XP Pro SP2, Admin, Auto-updates ON, Firefox, Acer TravelMate 660 graphics). |
|
|
|
 |  |
|
|
|
No problem! I'm sure you've been plenty busy. I just wanted to make sure I hadn't missed something. Thanks so much!
Smiles
Laura |
|
|
|
 |  |
|
|
|
Hmmm, it looks like named filters slipped again? They were in 0.9.23.X, but on 9/25 it looks like they got moved to 0.9.25 (after calendar unfortunately)? Did they turn out to be harder than expected?
On a related note, I noticed in http://www.sqlnotes.net/Forums/tabid/54/forumid/2/threadid/4836/scope/posts/Default.aspx that you implement these as queries in Access. It would be interesting addition to be able to create named filters at the Access layer using the more powerful Access tools and language. Strictly a power user thing, but perhaps those access queries could be used by name in SqlNotes.
Thanks,
d |
|
|
|
 |  |
|
|
|
Actually, they aren't terribly difficult to do. They slipped as other stuff was done, namely the portable version. And as many many users are waiting for the Calendar and as I finally found the "perfect" way to implement it (supports both Ecco's and Outlook's way of doing), it has been moved up.
FYI, fields can be made to look like named filters. If you have Access,
- create a query to yield the items you want
- name the fields so that you have at least 2 fields: ItemID and YourFieldName.
- Copy the SQL code.
- In the definition of YourFieldName, select yes/no data type and in Options, enter <source>YourSQLCode</source>
Try it out and if you need more help, ask more questions  Pierre (Win XP Pro SP2, Admin, Auto-updates ON, Firefox, Acer TravelMate 660 graphics). |
|
|
|
|  |