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.
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
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 ?
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.
IN
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.
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