Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Automatically adding a row to a table with in a request.

Highlighted
PPMNewbie
Occasional Advisor

Automatically adding a row to a table with in a request.

Hi Everyone,

 

Does anyone know of a way to automatically add a row to a table within a request?  I would prefer to have the row added while the request transitions, but it can also be UI rule.

 

Here's my setup for PPM 7.5.  I have a table that contains two columns; a "Name" column and a "Date" column.  Whenever the request gets reassigned I want a new line added to the table where the new "Assigned To:" user's full name gets added to the "Name" column and the system date gets added to the "Date' Column.

 

Is this possible?

 

Thanks a lot.

PPM Newbie

10 REPLIES
AlexSavencu
Honored Contributor

Re: Automatically adding a row to a table with in a request.

Hi and welcome to the PPM World!

 

you can implement this requirement using a custom Oracle function (which inserts the values in your table) called by an automatic execution step within the workflow.

 

cheers

alex


--remember to kudos people who helped solve your problem
PPMNewbie
Occasional Advisor

Re: Automatically adding a row to a table with in a request.

How would you setup the execution step?

Celil
Esteemed Contributor

Re: Automatically adding a row to a table with in a request.

Hi Newbie,

I suggest you that use a rule.

First of all create a DB function which insert a line to your table.

Second at PPM side create a rule with "On Change" event on Assigned To field. In SQL section you can call the function like "SELECT func123 FROM dual".

In addition to that execution step solution (Alex said) can also work too.



PS:Please keep alive our forum via Kudos the professionals
Celil

IT Governance Professional
& PPM Solution Architect
bzdafro
Collector

Re: Automatically adding a row to a table with in a request.

Hi,

 

Just curious if your updating a custom table or one of the built in tables.   

 

Thanks

Utkarsh_Mishra
Honored Contributor

Re: Automatically adding a row to a table with in a request.

You need to inser the row in out of the box provided table - KCRT_TABLE_ENTRIES

 

For more details you can refer the data model guide provided by HP for version 7.5.

Cheers..
Utkarsh Mishra

-- Remember to give Kudos to answers! (click the KUDOS star)
AlexSavencu
Honored Contributor

Re: Automatically adding a row to a table with in a request.

Hi, Utkarsh,

 

I think NewBie is trying to insert a row in a custom table - if this is true, then my solution works; if not, your suggestion is the proper one, but I would suggest to do it in an automatic step AND to refresh the Table Entries cache - otherwise the new records will not be shown in the form until the server is restarted.

 

We have created an ER to HP for the KCRT_TABLE_ENTRIES to be treated be jBoss in the same manner as KCRT_REQUESTS, that is to refresh the records when a specific column is updated (LAST_UPDATE_DATE).

 

cheers

alex


--remember to kudos people who helped solve your problem
PPMNewbie
Occasional Advisor

Re: Automatically adding a row to a table with in a request.

Thank you everyone for your suggestions.  I will give them a try and will post my results.  Your assistance is appreciated.

Eldellas
Acclaimed Contributor

Re: Automatically adding a row to a table with in a request.

Hi Alex,

 

I was able to insert a row in a custom table but I'm not able to see the values..

 

Please could you explain me how to refresh the Table Entries cache?

 

Thanks in advance,

Paolo

AlexSavencu
Honored Contributor

Re: Automatically adding a row to a table with in a request.

Hi,

You need to execute the kRunCacheManager script with the appropriate parameter for refreshing the table entries cache.

Cheers
Alex

--remember to kudos people who helped solve your problem
Kushalch
Super Collector

Re: Automatically adding a row to a table with in a request.

hi Alex/Utkarsh,

 

related to the updation, we have a requiremnent where we want to add a new row in a table in 1 request from a table in request 2. the rows are added fine when we add a row in the last but not when we add somewhre in the table ie in middle.

 

please let me know how to compare the rows and handle this.

 

for eg. in 1st request we added 2 rows so the seq are 1 and 2. now we add a row in between 1 and 2. ie seq 2 becomes 3 and the new row 2 and so on...

//Add this to "OnDomLoad" event