[rt-users] RT database table relations
Greetings, I was exploring some integration with the RT database from an external web framework and realized that there don't seem to be any key relations established between tables I'm looking at in the DB. Is this purposeful or something that just never made it in? E.g. tickets.queue as foreign key to queues.id tickets.owner as foreign key to users.id (etc.) Everything works fine without this of course; I'm just thinking that certain queries are likely to be simpler in some use cases. Would utilizing key relations be generally beneficial (referential integrity/etc.) or harmful in the ~current RT DB design? RT 3.8.8 with Postgresql 8.4.4. -- Darren Spruell phatbuck...@gmail.com
[rt-users] Save seaarch with type='Reminder' not possible ?
Hi, I try to save my over-due-reminder search (configured in the 'advance search page'): Owner = '__CurrentUser__' AND Due = 'now' AND Due 0 AND type = 'Reminder' AND ( Status = 'new' OR Status = 'open' OR Status = 'stalled' ) but it's not possible, because I cannot jump back to the Edit-Search for saving. If I remove the AND type = 'Reminder' part, it's possible to jump back the editpage, where Save-button is available. How can I save my query ? We use RT3.8.8. kind regards Danny
Re: [rt-users] Save seaarch with type='Reminder' not possible ?
Change type = 'Reminder' to Type = 'reminder' and everything is fine. Chris Am 15.05.2011 10:11, schrieb Daniel Schwager: Hi, I try to save my over-due-reminder search (configured in the 'advance search page'): Owner = '__CurrentUser__' AND Due = 'now' AND Due 0 AND type = 'Reminder' AND ( Status = 'new' OR Status = 'open' OR Status = 'stalled' ) but it's not possible, because I cannot jump back to the Edit-Search for saving. If I remove the AND type = 'Reminder' part, it's possible to jump back the editpage, where Save-button is available. How can I save my query ? We use RT3.8.8. kind regards Danny