Project and Portfolio Management Practitioners Forum
cancel

new user to be added to this drop down list,"Contact Name" in front End PPM

SOLVED
Go to solution
Highlighted
Pachi
Super Contributor.

new user to be added to this drop down list,"Contact Name" in front End PPM

Hi

 

We have a field"Contact Name" in front End PPM, we want a new user to be added to this drop down list.

From workbench i see,  the below query, How can i add a new user to this list?

 

select contact_id, full_name, contact_id, phone_number, contact_id, email_address from KCRT_CONTACTS where UPPER(full_name) like UPPER('?' || '%') and enabled_flag = 'Y' and (full_name like upper(substr('?',1,1)) || '%'   or   full_name  like lower(substr('?',1,1)) || '%') order by 2

Regards,
Pachi
3 REPLIES
SureshR
Super Contributor.
Solution

Re: new user to be added to this drop down list,"Contact Name" in front End PPM

Hi Pachi,

 

Go to the Demand Mgmt and select Contacts tab in the Workbench. Here you can add the new values.

 

Regards,

Suresh

Pachi
Super Contributor.

Re: new user to be added to this drop down list,"Contact Name" in front End PPM

I ahve done tht, It stil does not appear.

Any suggestions?

Regards,
Pachi
SureshR
Super Contributor.

Re: new user to be added to this drop down list,"Contact Name" in front End PPM

Hi Pachi,

 

Please run the below mentioned query for newly created user and let me know the outcome.

 

select * from KCRT_CONTACTS where full_name like '%<last name>%'

 

Also send me the screenshot for the validation for Contact Name.

 

Regards,

Suresh