El 04/07/2006, a las 1:48, Gilmar Santos Jr escribió:

Hi,

Yes. First select the queue(s) and "add", then all custom fields related to those queues appear and you can adjust the query. "add" and search ;-)
3.6 has a shortcut button "add and search". great button!

This is a nice tip! I have a 3.4.1 instalation and everything works like a charm except the customfield searches. A CF.{value}='yes' has a time to display of 99.041657 sec. I supose that this is a mysql problem but I didn't find anything odd.

ObjectCustomFieldValues has 2057 rows and 5 indexes:

PRIMARY: id (cardinality 1802)
TicketCustomFieldValues1: CustomField ObjectId Content (cardinality 1802)
TicketCustomFieldValues2: CustomField ObjectId (cardinality 1802)
ObjectCustomFieldValues1: Content (cardinality 901)
ObjectCustomFieldValues2: CustomField ObjectType ObjectId (cardinality 1802)

Is this an innoDB problem? any suggestions?

--
Pau Montero Parés


Attachment: PGP.sig
Description: Mensaje firmado digitalmente

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


We're hiring! Come hack Perl for Best Practical: 
http://bestpractical.com/about/jobs.html

Reply via email to