Changing Sort Order

 3 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
brihyn
Veteran Member Send Private Message
Posts: 95
Veteran Member
My user wants to change the search on the AM20.3 screen, Serial Numbers search. Currently in AM.sr, I have this: DEFINE SELECT "Serial Numbers" ID AM-ASI-S-0005 SCRFLD SERIAL-NBR-43 FILENAME AMASTITEM INDEX ASISET2 KEYRNG NXTKEY @CURSCRFLD DSPFLDS SERIAL-NUMBER:"Serial", ITEM-NBR:"Item", ASSET:"Asset", TAG:"Tag", ASSET-GRP:"Group" RETURNS SERIAL-NUMBER INTO SERIAL-NBR-43 The search orders the results by Asset number, and she would like the results sorted by Serial Numbers. Thoughts?
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
Check the other indexes - even if they seem to be the same fields they may have different sorts.
David Williams
brihyn
Veteran Member Send Private Message
Posts: 95
Veteran Member
Thanks. None of those worked as I'd hoped, but turns out I wasn't clear on her original request, so I'm now looking in an entirely different direction. Thanks again for the help.
brihyn
Veteran Member Send Private Message
Posts: 95
Veteran Member
ok, i'm now about to start pulling my own hair out, and I think it may be because of my own stupidity for possible lack of documenting... What the user wants: AM20.3 you click the search on Serial. You then click the Search in the Drill Around window. The default search is for Asset, but the pull down list includes Serial. She'd like Serial to be the default. Now the issue is, one of my product lines, the first that would have received the last service pack, has this as she wants it. I don't remember ever making this change, and my log of all customizations shows nothing about this, but that was a year ago...who knows...wondering if this change got missed. All of my product lines that I installed the last MSP on a few months later default to Asset. I can't find where this could possibly be changed at. As a test, I ran the MSP install in preview mode against the pdl that looks like it works as wanted, but it found no modifications, so I'm still stumped. Ideas on where to look? I've ran Windiff against several different areas and haven't found anything yet.