| Login

SQLNotes' main web site has been moved. Click here to go to the new home page. From there you can download the Portable SQLNotes Zip file or view the dowload page.

 

Note: This Forum is now closed. Please use the new community web site.

Note that browsing / searching is still be possible

 
  Forums  SQLNotes Beta01  Suggestions  named filters
Previous Previous
 
Next Next
New Post 5/16/2008 4:45 PM
User is offline reesd
54 posts


named filters 

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

 
New Post 5/16/2008 4:51 PM
User is offline PPL
2056 posts


Re: named filters 

Hi,

Named filters are planned for 0.9.26 according to Mantis. Plan is as follows

  1. 0.9.24: Offline mode
  2. 0.9.25: Calendar / alarms
  3. 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).
 
New Post 5/17/2008 2:41 AM
User is offline lucky_phil
77 posts


Re: named filters 

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.

 
New Post 5/17/2008 2:36 PM
User is offline Tom
443 posts


Re: named filters 

not sure what exactly named filters are, but if they make filtering easier they take number one spot on my list too

 
New Post 5/17/2008 2:57 PM
User is offline PPL
2056 posts


Re: named filters 

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).
 
New Post 7/30/2008 3:56 PM
User is offline CcTiger2
8 posts


Re: named filters 

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

 
New Post 7/30/2008 4:11 PM
User is offline PPL
2056 posts


Re: named filters 

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).
 
New Post 7/31/2008 3:45 PM
User is offline CcTiger2
8 posts


Re: named filters 

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

 
New Post 10/1/2008 3:54 PM
User is offline reesd
54 posts


Re: named filters 

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

 
New Post 10/1/2008 4:09 PM
User is offline PPL
2056 posts


Re: named filters 
Modified By PPL  on 10/1/2008 6:48:12 PM)

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,

  1. create a query to yield the items you want
  2. name the fields so that you have at least 2 fields: ItemID and YourFieldName.
  3. Copy the SQL code.
  4. 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).
 
Previous Previous
 
Next Next
  Forums  SQLNotes Beta01  Suggestions  named filters
Inspired by Nina