Mailing List Archive: Where are saved searches stored in the db

Where are saved searches stored in the db

woody at wildthingsafaris

Jan 10, 2017, 3:53 AM

Post #1 of 6 (1360 views)

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

Re: Where are saved searches stored in the db [ In reply to ]

martin.wheldon at greenhills-it

Jan 10, 2017, 4:06 AM

Post #2 of 6 (1360 views)

Hi Woody,

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

Best Regards

Martin

On 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

Re: Where are saved searches stored in the db [ In reply to ]

elacour at easter-eggs

Jan 10, 2017, 4:19 AM

Post #3 of 6 (1360 views)

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".

--
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

Re: Where are saved searches stored in the db [ In reply to ]

woody at wildthingsafaris

Jan 10, 2017, 5:51 AM

Post #4 of 6 (1360 views)

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

Re: Where are saved searches stored in the db [ In reply to ]

martin.wheldon at greenhills-it

Jan 10, 2017, 6:02 AM

Post #5 of 6 (1360 views)

Hi Woody,

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

Both of these read/write attribute information.

Best Regards

Martin

On 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

Re: Where are saved searches stored in the db [ In reply to ]

elacour at easter-eggs

Jan 10, 2017, 6:04 AM

Post #6 of 6 (1360 views)

Le 10/01/2017 Ã 14:51, Woody - Wild Thing Safaris a Ã©crit :
> 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.