Project and Portfolio Management Practitioners Forum
cancel

How to Populate Color using rule in a field

SOLVED
Go to solution
Highlighted
Phanishwar
Honored Contributor.

How to Populate Color using rule in a field

Hi,

I am trying to populate color like Red , green etc using rule to a field.For the same I am using HTML code in the Sql section of rule.It's working fine to show colors on field value change.However when I am clicking on SAVE it gives the HTML Code instead of color .Please see the screenshot attached.

Based on values selected in the two field i.e F1='RED' and F2='Yellow' rule fires and F3(field) shows color .But after saving it(F3) shows the HTML code.Why? what is the workaround to show color value based on rule.Our is PPM 7.1 version.

Thanks in advance!!
9 REPLIES
Mahen M
Acclaimed Contributor.

Re: How to Populate Color using rule in a field

Hi,
Can you give the whole rule Query? I will test from my environment.

Thanks.

Regards,
Mahendran M
Phanishwar
Honored Contributor.

Re: How to Populate Color using rule in a field

Hi Mahendran,

Please find the code used below :

Select 'RED','







' From dual.

Also see the screenshot of the rule section.

Thanks,
Phani
Mahen M
Acclaimed Contributor.

Re: How to Populate Color using rule in a field

Thanks, What is the validation type of 'US C Budget Status'

Is it text field?

Regards,
Mahendran M
Phanishwar
Honored Contributor.

Re: How to Populate Color using rule in a field

I am using ACL Validation Type.
Mahen M
Acclaimed Contributor.
Solution

Re: How to Populate Color using rule in a field

Phanishwar,
I tried from my end, The system works as told by you.

The HTML is correct and I suspect that it is the validation issue. The validation is not supporting in saving the color format.

Please raise a HP Support ticket, I hope they can tell whether this is possible or not.

Please advice if you succeed in this. Thank you.

Regards,
Mahendran M
Phanishwar
Honored Contributor.

Re: How to Populate Color using rule in a field

Thanks a Lot !!.

I remember that using 6.0 version it was possible using ACL valiadtion type.However it is not supported by Version 7.1 it seems.

Probably it seems it could be bug as it is supported at token level to display color however failed after saving..


Let me raise a support case with HP and let update you the same.

Thanks,
Phani
Prabha N
Trusted Contributor.

Re: How to Populate Color using rule in a field

Hi,

Can you please try the below code & let me know.

SELECT 'RED',
''
FROM DUAL

Thanks,
Prabha
Mahen M
Acclaimed Contributor.

Re: How to Populate Color using rule in a field

I hope it does work.....

Regards,
Mahendran M
Phanishwar
Honored Contributor.

Re: How to Populate Color using rule in a field

Thanks a lot to all!!.So fast response..thx!


It's working!....