on 04-17-2014 10:05 PM
Hi Team,
I have a complex table which is working but the sort order i want in a different way. How can i change?
Regards,
Gupta
Gupta,
You would need to change the index you are using on the screen field, or alter the index sort order on the complex table itself. You can set up the index as ascending or descending.
Jason Latko - Senior Product Developer at SAP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Gupta,
Indexes are automatically sorted alphabetically. I guess I don't understand the problem then? You can sort a string index alpha either ascending or descending. If your index is a number, it will not sort alpha, but numerically. Set your index to a string and you will get an alpha sort based on the field tied to your index.
Jason Latko - Senior Product Developer at SAP
Gupta,
As per your question you want to sort the complex table field values which has a parent index right?
Please check below I have example:
1. Below are the indexes I defined. Here only BatchNo is having the parent index
2. Check in ATE. Here you can see my partners are populating in sorted order only and it is giving all values independent other fields.
3. I will define parent index for partner now.
4. Check in ATE.
Test 1:
Test 2:
I want you need this kind of output only. Please check your index def, parent index def, field types and field edit types.
Hope this helps a bit.
Thanks,
Swaroopa.
Hi Swaroopa,
Could you please show me the properties at screen field level, I am unable to understand your example.
In the first screen shot your dropdown is already sorted but after adding parent index as location with location Andhra paradesh values got disturbed but later after choosing Gujarat again your values looks sorted alphabetically.
Regards,
Gupta
Gupta,
My screen field definitions are as follows:
1. Location
2. Partner
--In my previous reply, the first screen shot is without any parent index. So it is giving all values in alphabetical order only.
--After that I created parent index for partner with location, So the partner values are depend on location chosen.
In my TEST1:
--I just selected "Andhra pradesh" as location, In partner field drop down it is showing "Ragava" "Suman" "Sunitha" only.
--Because these are only the values belong to "andhra pradesh" location and these are coming in alphabetical order only.
TEST2:
--Here I selected "Gujrat" as location, In partner field drop down it is showing "Avinash" "Mohan" "Suman" which are belong to "Gujrat" location, These are also in alphabetical order only.
Hope this clears now. Still any query please post.
Thanks,
Swaroopa.
Hi Swaroopa,
I did the same, as shown in the screenshots still the values are not sorted.
I have realized what was the issue now, during index creation the field is based on code instead of description of my drop down.
Is there a way with out creating a new index can we solve this issue?. If i change field to code with codedesc it worked for me.
Regards,
Gupta
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.