Anyone else notice sorting issues within Inventory Transaction History per Part?
Scenario: Attempting to sort records in a chronological order by Creation Date and Time. Randomly there are anomalies as per the below screenshot:
Date Format for reference is: MM/DD/YYYY
Environments: 22 SUPD 5 and 22 SUPD 4 (different environments). No recent changes.
Hi. Can you provide a print screen that shows your search criteria? This will help. Please review and advise when you can. Thanks! Jane
Thanks for the reply,
I queried for only the part number. No other search parameters were used. I omitted the actual search value as it is unique to a customer’s environment.
Please let me know if you have any suggestions or a ticket must be created.
+4
Hi
I faced the same issue. However the following steps worked for me.
Then sort the created date column descending.
Thanks for the feedback. Although, this seems strange. Is freezing the column a requirement based on how the software was developed or is this just a workaround?
Freezing the column isn’t the key to the proper sort, however the order of doing the sort is. You must sort by time first then by date in order to get the records aligned as you want. The randomness of the records just doing date can’t be relied on to get the records ordered as desired.
This is actually true of most databases, the order of records in the table can’t be guaranteed to follow a time pattern, rather it is the primary key of the table that dictates that. In the case of transaction history, unless there is only one site involved and only one time zone for the sites, it is very possible that the transactions look out of order by date when they are in fact sequenced by the transaction history ID.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
