Joe, I had a similar problem a few years back with sorting values in some ITSM fields. Have you checked the Database search order (deep in the bowels of ITSM config)? It needs to be set consistently, especially with Oracle.
Rick Cook On Mon, Sep 8, 2014 at 11:29 AM, Joe D'Souza <[email protected]> wrote: > ** > > 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. > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
