Hey Rick,
Thanks for your response.. Where do you check that? Mind you the messed up sort order is only on the Mid-Tier, not on the fat client. If I run a SQL that the menu should be using based on the search criteria of the character menu, the sorting comes up fine on SQL as well. Which is why I suspect some sort of chunking at the Mid-Tier level and each chunk returning its own sorted list layered one on top of the other.. That is my theory anyway of why this is happening. Another colleague of ours used fiddler to check what's happening behind the scene and suspects the back channel call from the Mid-Tier. Joe _____ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Monday, September 08, 2014 2:38 PM To: [email protected] Subject: Re: Peculiar sort order of character menus returning *LARGE* number of menu items.. ** 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_ _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"
