Project and Portfolio Management Practitioners Forum
cancel

Auto fill Table Component from Workflow

Highlighted
Reinier de Koni
Regular Contributor.

Auto fill Table Component from Workflow

Hi,

Does anyone has a suggestion on how to add lines in a table component via the workflow?

We are trying to automate 5 lines a table for progress reporting.

Currently I am trying to add these via a Workflows Step Command:
ksc_store REQD.P.TABEL.TE="1".VP.HALLOVELD = "A","A"

but it throws errors...

4 REPLIES
Andrea Loi
Super Contributor.

Re: Auto fill Table Component from Workflow

You can run a database function that adds rows to KCRT_TABLE_ENTRIES table.
See "Data Model Guide" for more details.

Have a good day
Andrea

Reinier de Koni
Regular Contributor.

Re: Auto fill Table Component from Workflow

Hi Andrea,

Thanks for your response.
Are you sure that filling this kcrt_table_entries is the only table to fill for this?

We would like to avoid any insert solutions on database level.

Anyone realized such a solution somewhere? Are there special items to concentrate on?

Regards,
Reinier
Andrea Loi
Super Contributor.

Re: Auto fill Table Component from Workflow

We used it in PPM7 and I remember that it was OK.

Another solution could be to use the Open Interface: fill the KCRT_TABLE_ENTRIES_INT table and run the Open Interface report for Requests (or the commands that you find in it).
See "Data Model Guide" and "Open Interface Guide and Reference".
But I never experienced it.

Have a good afternoon
Andrea

VarunS
Trusted Contributor.

Re: Auto fill Table Component from Workflow

There is a way to insert new lines through a function from workflow execution step.
But this way is not very clean and you have to add 2 workflow steps.

In one step need to insert rows in table KCRT_TABLE_ENTRIES using a function.


INSERT INTO KCRT_TABLE_ENTRIES(TABLE_ENTRY_ID, CREATED_BY, CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,REQUEST_ID,PARAMETER_SET_FIELD_ID,SEQ,PARAMETER_SET_CONTEXT_ID,VISIBLE_PARAMETER1,PARAMETER1,VISIBLE_PARAMETER2,PARAMETER2)
VALUES (KCRT_TABLE_ENTRIES_S.nextVal ,1,SYSDATE, 1,SYSDATE,P_REQUEST_ID,47802,l_SEQ,35236,user_rec.username ,user_rec.username,l_current_status,l_current_status);

After that you have to run kRunCacheManager script in other execution step to refresh the request.