Question
IN
Last activity: 20 Mar 2017 2:36 EDT
Sorting after first character
Hi ,
I have a scenario. RD is called in Repeat Grid Layout. PFA's below
On the Screen It is Displaying Q1,Q10,Q11,Q12,Q2,Q20 instead of Ascending order Q1, Q2,Q3, (after giving sorting order to respective property)
How to achieve this.
Pegasystems Inc.
IN
Hi,
I believe it as an expected behavour. can you utilize function aliaz with a control in the report definition, to achieve your requirement ?
IN
Hi haritha,
thank you I got correct output
regards,
Bhargav
Cognizant
NL
Hi Bhargav,
I have used the function alias in RD and was able to achieve it
Use Convert Text to Integer function in which for text input parameter give another function Replace
(Replace your question property and text "Q" with any positive integer)
Check the attachments once
Thanks
Venkat
Pegasystems Inc.
US
Hi Venkat,
Can you please provide the complete function alias syntax used to sort the column correctly. And also please provide RD screenshot with this change.This helps me.
IN
Hi Venkat,
Kindly can you provide code with images. It is kind of urgent.
Regards,
Bhargav
Accepted Solution
IN
Hi,
I got correct output. I followed same solution Haritha and venkatreddy mentioned.
you need to add same property again (two same columns) at edit columns.
1 for adding function and hide it with gear symbol option.
2nd on for exposing (PS-solution1)
Then it worked fine
regards,
Bhargav P