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 !
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.
any another solution available?
because of we used so many function Alis and almost 15 properties available. without change any existing functionality
@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.
@Priyanka Boga
Hi priyanka ,
I tried this one I am facing same issue. In table level also I can put format as a number only.
@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.
@Priyanka Boga
Actually, I am using Table source is report definition only.
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
