01-22-2014 06:17 AM
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?
01-22-2014 07:52 AM
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.
01-22-2014 08:27 AM
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.
01-22-2014 08:33 AM
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.
01-22-2014 10:44 AM
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.
where UPPER(description) like UPPER('%?%')
and (description like '%' || upper(substr('?',1,1)) || '%'
or description like '%' || lower(substr('?',1,1)) || '%')
order by description