Using Clarity 13.3
I have custom portlet which list all the Project and budget information, i need to know is there any way to show '$' symbol in Amount column.
Please share your thoughts
Use concatenation in the Portlet query to show the '$' Symbol in particular Column.
simple example; Select code || '$' from inv_investments -> in Oracle and use + in SQL Server.
If $ is interpreted as a code instead of a character you could ecperiment with using the htlm escape code for the dollar sign $
which is ambersand hash 36 and semicolon in case it is not displayed properly here.
Hi Martin and Gurjeet,
Thanks for your reply.
But there is also a Total amount column in the bottom of the Portlet, if i retrive the Budget column as a string type, we cannot show sum of the Budget column in the Portlet.
That is a known challenge.
You could try to but the dollar sign in a separate column or see if the MONEY construct still works and provide what you need.
Thanks Martti.. I will check that.
If your custom porlet is an object based one, creating the required attribute as a MONEY datatype will automatically show the currency column alongside the amount.
If your custom portlet is a query based one, you can use the MONEY datatype in NSQL queries. Just make sure to include the needed currency also in your select statement. This will still allow all the aggregation options. A sample code is given below.
FROM INV_INVESTMENTS I
Hope this helps.
Thanks a lot Georgy, it is worked.