Does anyone know where the saved filters are stored?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2010 07:31 AM
Does anyone know where the saved filters are stored?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2010 10:04 AM
Well so I post this and then find it. Whey are stored in the sys_filter table, I thought it was a user preference.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-05-2010 06:53 PM
There's a field on sys_filter that specifies the user (it does not appear by default). If it is blank, it becomes a global filter (out-of-box global filters include Active, Active - Unassigned, etc. for Incidents and similar tables). There are also group and domain fields (again, not appearing by default) that do the same, so that if there's a filter that's useful for a group, they can all have access to it.
The "Edit personal filters" link takes you to a filtered view of the sys_filter table that specifies "User = [current user]". And then when you create a new filter from that view, it automatically applies the current user's name.
I hope that makes it more clear. We should document the saved filters better.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-08-2010 09:54 AM
Thanks for the info.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-01-2013 05:13 AM
The "Edit personal filters" link takes you to a filtered view of the sys_filter table that specifies "User = [current user]". And then when you create a new filter from that view, it automatically applies the current user's name.
I have a question in this case:
How the value in the User field is populated with the current user name?
Do we have any Global scripts to perform this?
Please let me know if you have any information on this.
Thanks,
Damodar