Where are saved searches stored in the db

RT Users
1

Hi all,

I was expecting to find a database table called “SavedSearches” but
there isn’t one. I have a saved search that contains the string
‘_CurrentUser’ but if i dump the DB and grep for that, i don’t find it.

Anyone know where saved searches are?

thanks

Woody.

Richard Wood (Woody)
Managing Director
Wild Thing Safaris Ltd.

UK: 2B Habbo St, Greenwich, London
Dar es Salaam: 5 Ethan St, Mbezi beach
Arusha: 3 Ebeneezer Rd, Njiro
PO BOX 34514 DSM
Office: +255 (0) 222 617 166
Office Mobile: +255 (0) 773 503 502
Direct: +255 742 373 327
Skype: woody1tz

2

Hi Woody,

What are you trying to achieve? IMO you are better off using the RT API
rather than hacking the database.

Best Regards

MartinOn 2017-01-10 11:53, Woody - Wild Thing Safaris wrote:

Hi all,

I was expecting to find a database table called “SavedSearches” but
there isn’t one. I have a saved search that contains the string
‘_CurrentUser’ but if i dump the DB and grep for that, i don’t find
it.

Anyone know where saved searches are?

thanks

Woody.

–

Richard Wood (Woody)
Managing Director
Wild Thing Safaris Ltd.

UK: 2B Habbo St, Greenwich, London
Dar es Salaam: 5 Ethan St, Mbezi beach
Arusha: 3 Ebeneezer Rd, Njiro
PO BOX 34514 DSM
Office: +255 (0) 222 617 166
Office Mobile: +255 (0) 773 503 502
Direct: +255 742 373 327
Skype: woody1tz
http://wildthingsafaris.com

3

Hi all,

I was expecting to find a database table called “SavedSearches” but
there isn’t one. I have a saved search that contains the string
‘_CurrentUser’ but if i dump the DB and grep for that, i don’t find it.

Anyone know where saved searches are?

In table “Attributes”.

Easter-eggs Spécialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

4

Thanks Emmanuel,

I see the “Content” is encoded, which is why it didn’t come up with my
grep.

How do i decode/encode it?

w.On 10/01/17 15:19, Emmanuel Lacour wrote:

Le 10/01/2017 à 12:53, Woody - Wild Thing Safaris a écrit :

Hi all,

I was expecting to find a database table called “SavedSearches” but
there isn’t one. I have a saved search that contains the string
‘_CurrentUser’ but if i dump the DB and grep for that, i don’t find it.

Anyone know where saved searches are?
In table “Attributes”.

Richard Wood (Woody)
Managing Director
Wild Thing Safaris Ltd.

UK: 2B Habbo St, Greenwich, London
Dar es Salaam: 5 Ethan St, Mbezi beach
Arusha: 3 Ebeneezer Rd, Njiro
PO BOX 34514 DSM
Office: +255 (0) 222 617 166
Office Mobile: +255 (0) 773 503 502
Direct: +255 742 373 327
Skype: woody1tz

5

Hi Woody,

Check out the following tools:
rt-attributes-viewer
rt-attributes-editor

Both of these read/write attribute information.

Best Regards

MartinOn 2017-01-10 13:51, Woody - Wild Thing Safaris wrote:

Thanks Emmanuel,

I see the “Content” is encoded, which is why it didn’t come up with my
grep.

How do i decode/encode it?

w.

On 10/01/17 15:19, Emmanuel Lacour wrote:

Le 10/01/2017 à 12:53, Woody - Wild Thing Safaris a écrit :

Hi all,

I was expecting to find a database table called “SavedSearches” but
there isn’t one. I have a saved search that contains the string
‘_CurrentUser’ but if i dump the DB and grep for that, i don’t find
it.

Anyone know where saved searches are?
In table “Attributes”.

–

Richard Wood (Woody)
Managing Director
Wild Thing Safaris Ltd.

UK: 2B Habbo St, Greenwich, London
Dar es Salaam: 5 Ethan St, Mbezi beach
Arusha: 3 Ebeneezer Rd, Njiro
PO BOX 34514 DSM
Office: +255 (0) 222 617 166
Office Mobile: +255 (0) 773 503 502
Direct: +255 742 373 327
Skype: woody1tz
http://wildthingsafaris.com

6

Thanks Emmanuel,

I see the “Content” is encoded, which is why it didn’t come up with my
grep.

How do i decode/encode it?

as far as I remember (no time to check now), it’s base64 encoded. You
have a script in RT to see attributes by id: rt/sbin/rt-attribute-viewer.

1 Like