Dynamic column sorting in SBWP

[mikko.maki-rahkola@accenture.com]

Thanks for the workaround tip Paul. I think I'll go your way as well, it could prove to be a little quicker than raising a note out of it..
 
Thanks again!
-Mikko

________________________________

From: sap-wug-bounces at mit.edu on behalf of Knuth, Paul
Sent: Wed 09/02/2005 17:05
To: SAP Workflow Users' Group
Subject: RE: Dynamic column sorting in SBWP



We had the same issue with dates sorting in SBWP.  What I did was extend
the object to have a second date field in the format that would sort
right (Century / Month / Day).  The method was changed to move the
original date field to the new field.  We then used the new date field
in SBWP.  Users loved it.

I did not want to change the existing date field format. 

Thanks,
Paul Knuth
Hershey Foods

-----Original Message-----
From: sap-wug-bounces at mit.edu [mailto:sap-wug-bounces at mit.edu] On Behalf
Of mikko.maki-rahkola at accenture.com
Sent: Wednesday, February 09, 2005 2:34 AM
To: sap-wug at mit.edu
Subject: Dynamic column sorting in SBWP

Hi everyone,

I received a question a while ago about how to sort dynamic columns
containing dates properly in SBWP but was unable to solve it. Hopefully
some of you could help me out..

As an example, we have a document approval task including document due
date (data type BKPF-BUDAT) as a container element which is assigned to
a dynamic column. The person who asked me the question is trying to sort
the work items in SBWP by the due date dynamic column, but runs into a
strange result. Instead of sorting the items in correct order
(02-Jan-2005 followed by 01-Feb-2005), the items are sorted
character-wise (01-Feb-2005 -> 02-Jan-2005).

Do you know if there's something that can be done to make the sort
function as required? I doubt it because my guess is that the BUDAT-type
date value is converted into a plain string somewhere in the process and
thus it can't be sorted by date any more in SBWP. But if any of you have
found a way to overcome this, please let me know about it.

Thanks for your help!
-Mikko


This message is for the designated recipient only and may contain
privileged, proprietary, or otherwise private information.  If you have
received it in error, please notify the sender immediately and delete
the original.  Any other use of the email by you is prohibited.

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug

_______________________________________________
SAP-WUG mailing list
SAP-WUG at mit.edu
http://mailman.mit.edu/mailman/listinfo/sap-wug




This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information.  If you have received it in error, please notify the sender immediately and delete the original.  Any other use of the email by you is prohibited.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/ms-tnef
Size: 5467 bytes
Desc: not available
Url : http://mailman.mit.edu/pipermail/sap-wug/attachments/20050209/b4d16651/attachment.bin