The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED
Go to solution
Highlighted
Pachi
Collector

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
Regular Collector
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
Collector

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
Regular Collector

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

 

 

//Add this to "OnDomLoad" event