Dollar Symbol in Custom Portlet

[Adersh Ram]

Hi Team,

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

Thanks,

Adersh Ram

[Legacy User]

Hi Adersh,

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.

-Gurjeet

 

[Deactivated User]

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.

 

Martti K.

[Adersh Ram]

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.

 

Thanks,

Adersh

 

[Deactivated User]

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.

 

Martti K.

[Adersh Ram]

Thanks Martti.. I will check that.

[Georgy]

Hi Adersh,

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.

SELECT  @SELECT:DIM:USER_DEF:IMPLIED:PROJECT:I.ID:id@,
         @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:'USD':curr@,
         @SELECT:DIM_PROP:USER_DEF:MONEY(curr):PROJECT:I.labor_etcsum/3600:ETCSUM@
FROM     INV_INVESTMENTS I
WHERE    I.CREATED_DATE>'10-MAR-14'
and @FILTER@

Hope this helps.

Georgy

[Adersh Ram]

Thanks a lot Georgy, it is worked.