April 2006 - dev - OTRS mailing lists

Query for the Advanced Search Criteria
by vee na 06 Apr '06

06 Apr '06

Hi All, I have a problem in the advanced search query, there is no error but the query is taking a lot of time to run. i have given the query also, SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st, queue sq WHERE sq.id = st.queue_id AND sq.g roup_id IN (1, 7) AND LOWER(st.customer_id) IN (LOWER('10093822'), LOWER('10093822') ) ORDER BY st.create_time _unix DESC LIMIT 50; Any help will be welcome, Regards, Veena --------------------------------- Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

1 0

[Query] SendAgentNotification definition
by babu dasthagir 04 Apr '06

04 Apr '06

hi friends, I want to know where the SendAgentNotification definition was wrote. Reply ASAP, Regards, Babu.D --------------------------------- Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time.

2 1

New API Documentation online
by Martin Edenhofer 01 Apr '06

01 Apr '06

Hi, JFI, the online version of the "OTRS API documentation" is now reworked and available at: http://dev.otrs.org/ Have a lot of fun! .-) Martin ((otrs)) :: OTRS GmbH :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 1862 760 :: Fax: +49 (0) 9421 1862 769 http://www.otrs.com/ :: Communication with success!

1 0

Release date of 2.0.5/2.1.0
by Stefan Bedorf 01 Apr '06

01 Apr '06

Hi all, i'm planning to move our OTRS instances from 1.2.3 (heavily patched/extended) to a more recent version. Seeing the long list of updates and bugfixes that came after 2.0.4 i wonder is there a planned release date for 2.0.5 or even a 2.1.0 version? If it's not too long i will rather wait to have a clean version instead of getting 2.0.4 and getting all bugfixes from the cvs tree manually. Cheers Stefan Bedorf

2 1