We are on ARS / ITSM 7.6.04 SP5 all round on Linux using Oracle 11.x as a backend DB. I am working on a system, which when deployed will have a fairly large set of Companies (2500 or there about and growing). One of my co-developer (Mark Brittain - member of this forum), picked up on a peculiar problem.
The sort order of the companies is as expected starting from 0 to 9, followed by A to Z, followed by a to z. At first look it looked normal until Mark scrolled right down. The list restarted its sort order at some point (which from the numbers we are dealing with, we assume must be at 1000. This is happening only on the Mid-Tier, as the user tool displays it correctly - only difference being that the menus appears as a list on the thick client as that is the client setting for large menus. My believe is that the Mid-Tier is chunking the results into chunks of 1000 and arranging each chunk into its own sort order. There is no customization on the menu nor the Company field on the COM:Company form. The menu displays this peculiar behavior on every place that the Company menu is used in ITSM. Has anyone else faced this and have resolved it? We believe there must be some backend setting either in the CSS or one of the Mid-Tier jar files that could correct this issue. I'll be raising a ticket with BMC Support shortly - but thought I would run this by you people to see if anyone else has faced this issue, and how you'll have dealt with it. Joe PS: I have toyed with the idea of leveraging the Tiered menu approach to reduce the number of items on each menu, but that solution will require user acceptance as users are used to the menus as is now. SO as of now, leveraging that tiered menu option is not an option. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
