| Author |
Message
|
| ucbus1 |
 Posted: Wed Mar 09, 2005 10:15 am Post subject: worklist sort criteria |
 |
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
As per the programming guide the sort criteria is pretty simple. But if I would like to sort the work list as per the following ans show them on the out-of-box client
| Quote: |
| concat(substr(NAME,1,5), substr(DESCRIPTION,1,2)),NAME |
What are my options? |
|
| Back to top |
|
 |
| jmac |
| Posted: Wed Mar 09, 2005 11:13 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
I am not sure exactly what you are saying?
Do you want to sort based on the first 5 characters of the Name and the first 2 characters of the Description? I.E 2 sort control fields
Or do you want to sort on a "new string" that consists of the first 5 characters of the Name and first 2 characters of Description? I.E 1 sort control field.
In either case I don't believe there is a direct way to do what you wish "out of the box".
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| ucbus1 |
| Posted: Wed Mar 09, 2005 11:27 am Post subject: |
|
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
Thanks JMac
| Quote: |
| Do you want to sort based on the first 5 characters of the Name and the first 2 characters of the Description? I.E 2 sort control fields |
Yes it is sorting on 2 control fields. however one is also fine.
But you mentioned that either case it would be not possible.
Are there any other options? |
|
| Back to top |
|
|
| jmac |
| Posted: Wed Mar 09, 2005 11:46 am Post subject: |
|
|
Jedi Knight
Joined: 27 Jun 2001
Posts: 3081
Location: EmeriCon, LLC
|
Is there some reson you cant do NAME ascending, DESCRIPTION ascending?
_________________
John McDonald
RETIRED |
|
| Back to top |
|
|
| ucbus1 |
| Posted: Wed Mar 09, 2005 12:05 pm Post subject: |
|
|
Knight
Joined: 30 Jan 2002
Posts: 560
|
| The combined key is the way work is pushed currenly. however in the absence of it I may have to use the fileds separately |
|
| Back to top |
|
|
|
|
