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.
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.
Would there be any SQL query that I can get all the fields for a status for that particular request type?
of course there is - you can build the SQL based on the information in the Data Model guide.