Project and Portfolio Management Practitioners Forum
cancel

Can we put OR in between Project Manager name given by OOTB Project Manager Token

SOLVED
Go to solution
Highlighted
Phanishwar
Honored Contributor.

Can we put OR in between Project Manager name given by OOTB Project Manager Token

HI ,

I am getting multiple Project Manager name by [REQ.VP.KNTA_PROJECT_MANAGER] Token in the notification template. Our requirement is to ADD "OR" In betweenn Project Managers name.is that Possible.

Thanks in advance!!
5 REPLIES
Mahen M
Acclaimed Contributor.
Solution

Re: Can we put OR in between Project Manager name given by OOTB Project Manager Token

Please create a Text area and when ever there is a name change in Project Manager field, This text area should get automatically populated by means of field change Rule.

Use 'Replace' in your SQL.

Select replace('[REQ.VP.KNTA_PROJECT_MANAGER]', '#@#', 'OR'),
replace('[REQ.VP.KNTA_PROJECT_MANAGER]', '#@#', 'OR')
from dual

Try to use this text area in your notification.

Regards,
Mahendran M
Phanishwar
Honored Contributor.

Re: Can we put OR in between Project Manager name given by OOTB Project Manager Token

I AM USING BELOW TEMPLATE FOR NOTIFICATION.



BC Planned occurred on [REQD.VP.BC_ACTUAL] for [REQ.P.KNTA_PROJECT_NAME].

As required, please reference the "Executive Summary" or contact the Project Manager [REQ.P.KNTA_PROJECT_MANAGER] for more information.






Now for "[REQ.P.KNTA_PROJECT_NAME]" if it is mulliple value then i want to insert "OR" in betweenn name . This is bein used at Wrok flow steo to send notification in this format.

How can SQL be used in HTML. I do not have any idea.

Pls put ur inputs
Greg_Shrout
Super Contributor.

Re: Can we put OR in between Project Manager name given by OOTB Project Manager Token

SQL can be referenced in the jsp file throught a file reference.
For example, in CreateProject.jsp, these lines:
styleId="projectManager"
validationID="1065"
...
it has given the validation_id for the validation it is running.
You can run this SQL to see the validation_id:
select *
from KNTA_VALIDATIONS
where validation_id = 1065
Phanishwar
Honored Contributor.

Re: Can we put OR in between Project Manager name given by OOTB Project Manager Token

Thanks!!..


I am still not clear if This can be supported by the notification template used at workflow step.In the above HTML, how can I put this sql : Example.

select replace(prj_project_manager_username,'#@#',' OR ') from ai.KCRT_FG_PFM_PROJECT where request_id=214506--this contains the project project managers name.It is out of box fied so there is not validation. it is stored in this table :

Phanishwar
Honored Contributor.

Re: Can we put OR in between Project Manager name given by OOTB Project Manager Token

Using Replace() funtion at Rule level, would make it possible.

I was trying to put OR using [REQ.VP.KNTA_PROJECT_MANAGER] at HTML Code level. For that I am not able to do it still.

Any ways the purpose could be solved by writing a rule.