How to construct a sorted CSV based on a column
Issue here is clipboard property order is getting change at runtime and it will impact on our export to excel functionality (since column order getting change)
We resided SR on this and they finally gave below comments
“I have discussed with our Product SME and below is the update.
Values retrieved on the clipboard and tracer internally uses HashMap. The HashMap class does not maintain the order of the elements. This means that It might not return the elements in the same order they were inserted into it.
While viewing on the clipboard it displays in an alphabetical order.
For your requirement to work you need to make changes while the CSV is constructed in step 4 of the pxConvertResultsToCSV activity. By default this cannot be sorted on any column. Hence modifications should be made in your own activity.”
As discussed this request falls outside the scope of work supported by GCS as your requirement cannot be achieved with existing OOTB functionality.
Question on how to construct a sorted CSV based on a column should be posted as a question to the Pega Collaboration Center.
- Clipboard property order
Issue here is clipboard property order is getting change at runtime and it will impact on our export to excel functionality (since column order getting change)
We resided SR on this and they finally gave below comments
“I have discussed with our Product SME and below is the update.
Values retrieved on the clipboard and tracer internally uses HashMap. The HashMap class does not maintain the order of the elements. This means that It might not return the elements in the same order they were inserted into it.
While viewing on the clipboard it displays in an alphabetical order.
For your requirement to work you need to make changes while the CSV is constructed in step 4 of the pxConvertResultsToCSV activity. By default this cannot be sorted on any column. Hence modifications should be made in your own activity.”
As discussed this request falls outside the scope of work supported by GCS as your requirement cannot be achieved with existing OOTB functionality.
Question on how to construct a sorted CSV based on a column should be posted as a question to the Pega Collaboration Center.
- Clipboard property order
- Property order at runtime
Maantic
IN
Not sure how you are importing this data into excel but you can always have a temporary repeating structure build on a user page based on the order you want. And generate excel from that temp data model.
CGI
SE
Hi Avikmitra,
Yes we did same way you have mentioned. But at the runtime order is getting changed and this is pega behavior and we don't have control over it.
Please check two images in my original post.
1).Clipboard property order
2).Property order at runtime
Regards
Chaminda