ITSM 76.04 SP2 (Stack Installer) Trying to understand how to handle setting the Locale field on records from the OOTB forms. It looks like the locale field is left blank when using the stack installer since you cannot select a default language. Because of this every time the application has produce a menu against a form with the locale field it makes 3-4 queries for the data:
1. First tries to find all locales matching "en_US". 2. Then looks for all locales matching "en". 3. Then looks for locale where locale is NULL. 4. And in some cases may run a fourth query looking for records. (As far as I know this is only done when producing menus) Depending on how the menu is configured this could happen every time a menu is selected or once when the form loads. This is causing a lot of extra SQL statements to be run and it would make sense to find all of the forms that use Locale and set the field to our default language. I am surprised this is not part of the installation and configuration of ARS and ITSM. Has anybody done this and have a list of forms that would need to be updated? Thank you Frank C. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"

