Re: [rt-users] Where are saved searches stored in the db
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.
Re: [rt-users] Where are saved searches stored in the db
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: [rt-users] Where are saved searches stored in the db
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: [rt-users] Where are saved searches stored in the db
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:elac...@easter-eggs.com - http://www.easter-eggs.com
Re: [rt-users] Where are saved searches stored in the db
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
