I am facing sorting issue on Text property type
Hi guys ,
Actually, I am used all properties as Text property type. In data base property type is Vachar.
I used same properties in report definition.
for example: property is amount and total amount both are text type.
amount value is 10,1,100,22,20. while click on ascending order come like this 1,10,100,20,22.
Same as like total Amount also.
Please tell me how to resolve.
Thanks in Advance !
Accepted Solution
Updated: 11 Jun 2024 6:51 EDT
TSPI
US
Hi,
In RD in column source select the function as "[Text Value] converted to an Integer value" and you will get the result as per your requirement.
Please find the below screenshots for your reference
Regards,
Poojitha Behara
Maantic Inc
IN
That is Pega's OOTB functionality to sort text properties like this. You can try to run the report from a data page where in the response data transform, perform a sorting on Primary.pxResults.
CI
IN
any another solution available?
because of we used so many function Alis and almost 15 properties available. without change any existing functionality
Pegasystems Inc.
IN
@kirti - Can apply formatting on the report definition at the column level by clicking on the gear icon. Add pxDisplayText and click on search icon and set the fields as number.
Thank you.
CI
IN
Hi priyanka ,
I tried this one I am facing same issue. In table level also I can put format as a number only.
Pegasystems Inc.
IN
@kirti - Can you please brief about the structure how your are accessing the records on the screen i.e. on a table sourced to pagelist and referred to data page... something in these lines.
Thank you.
CI
IN
Accepted Solution
Updated: 11 Jun 2024 6:51 EDT
TSPI
US
Hi,
In RD in column source select the function as "[Text Value] converted to an Integer value" and you will get the result as per your requirement.
Please find the below screenshots for your reference
Regards,
Poojitha Behara