Re: v 9.12 Configuring User Data (304 Views)
Reply
Trusted Contributor
kwood55
Posts: 131
Registered: ‎04-09-2012
Message 1 of 6 (334 Views)

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?

Trusted Contributor
kwood55
Posts: 131
Registered: ‎04-09-2012
Message 2 of 6 (313 Views)

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
kintanadan
Posts: 45
Registered: ‎05-23-2011
Message 3 of 6 (304 Views)

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!

Frequent Advisor
kintanadan
Posts: 45
Registered: ‎05-23-2011
Message 4 of 6 (302 Views)

Re: v 9.12 Configuring User Data

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

 

Good Luck!

 

example.png

Trusted Contributor
kwood55
Posts: 131
Registered: ‎04-09-2012
Message 5 of 6 (300 Views)

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.

 

 

Frequent Advisor
Rich Y_1
Posts: 45
Registered: ‎06-11-2008
Message 6 of 6 (285 Views)

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

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.