Project and Portfolio Management Practitioners Forum
cancel

How to change Request Status Prompt fields in a Request?

Highlighted
TurboMan
Honored Contributor.

How to change Request Status Prompt fields in a Request?

Hi,

 

If I use WorkBench, it takes a while to change the field attributes for different request statuses , beacuse WB is a bit slugish and awkward.

Instead, I wish to use my own custom program, if I know where the attributes are located in th DB Field Visibility/Editibility values?

 

 

Any help is appreciated.

 

Regards

TM

3 REPLIES
AlexSavencu
Acclaimed Contributor.

Re: How to change Request Status Prompt fields in a Request?

Hi,

 

although this is highly un-recommended: the information is stored in the KNTA_PARAMETER_SET_FIELDS table.

 

Please check the Data Model Guide, it is pretty much self-explanatory.

 

if the WB is sluggish, you should check the client JRE version, as well as the connectivity to the PPM server.

 

cheers

alex


--remember to kudos people who helped solve your problem
TurboMan
Honored Contributor.

Re: How to change Request Status Prompt fields in a Request?

Thanks Alex,

 

Would there be any SQL query that I can get all the fields for a status  for that particular request type?

 

Regards

TM

AlexSavencu
Acclaimed Contributor.

Re: How to change Request Status Prompt fields in a Request?

Hi, TurboMan,

 

of course there is - you can build the SQL based on the information in the Data Model guide.

 

cheers

alex


--remember to kudos people who helped solve your problem