Project and Portfolio Management Support and News Forum
Showing results for 
Search instead for 
Do you mean 

v 9.12 Configuring User Data

Trusted Contributor

v 9.12 Configuring User Data

Trying to implement User Data. I see Demand Mgmt Config.pdf section 10 Configuring User Data.

- I definitely want some global data shared between all requests.

- I created Request User Data (call it text field1 and text field2).

   I want  a multiselect validation but I cant find the DB table where this data is stored. Right now its simply a list.

   I am hoping that user(s) can somehow update and add to the user data.

- I added the field to my Request Type with the list validation for my User Data.

   I expected to see the Request Type UserData tab become available but not sure what I would see (but it did not)

 

Any idea which DB table stores User Data?

How do you get the Workbench Request Type UserData tab available?

5 REPLIES
Trusted Contributor

Re: v 9.12 Configuring User Data

The global user data is probably stored in every request. (If implemented correctly).

 

All I really want is a table of contacts (especially email addresses) of non PPM users, and I want a single user to be able to update this list of contacts.

Frequent Advisor

Re: v 9.12 Configuring User Data

When you add Text Field 1 and Text Field 2 to the Request User Data, you could use the OOTB Validation: CRT - Contact Name - All to get your all of your PPM Defined Contacts.  Also select the Multiselect Radio Button.

 

When you open any request, you should see a new section in your request at the bottom called: User Data, with the added Text Field 1 and Text Field 2.

 

 

Pretty straight forward.

 

Good luck!

Highlighted
Frequent Advisor

Re: v 9.12 Configuring User Data

Here's a screen shot of the Request User Data.

 

Good Luck!

 

example.png

Trusted Contributor

Re: v 9.12 Configuring User Data

Ok, but I do not need user data to display PPM contacts.

 

I really want a Global list of non PPM user contacts.

And the worst part is I want a non-admin user to be able to add a contact.

 

 

Valued Contributor

Re: v 9.12 Configuring User Data

You can use a table outside of PPM to store this information and just use SQL to pull the table into PPM.  We have a schema in the PPM DB called our_code that hold tables maintained outside of PPM.  Then the code below is used to pull the tables into PPM.  Hope it help.

 

select pk,description
from our_code.TURNOVER_application_bv_00
where UPPER(description) like UPPER('%?%')
and (description like '%' || upper(substr('?',1,1)) || '%'
or description like '%' || lower(substr('?',1,1)) || '%')
order by description