which database table are updated when deployment is happen through PLC?

Hi Techie,

Which database tables gets update when we deploy content through PLC workflow?

I tried to debug but not find the answer.

Please reply .Thanks in advance :-)

Regards,

Rajesh

Find more posts tagged with

Comments

Faizi

Hi Techie,

Which database tables gets update when we deploy content through PLC workflow?

There are various tables, those are based on selected files in PLC workflow.
You can check iw* tables in databases on both SP & LS.
Based on defined metadata for various type of file, those information goes to those defined tables.

Rajesh117

Hi Faizi,

Extremely thanks for your valuable reply. now i found the tables which gets update.

Can you suggest me any OOTB java class where query is written to update these tables?

Actually i want know when Deploy Task of WF get executes which DB query gets trigered?

Regards,

Rajesh

Adam Stoller

Why do you need to know this?
What are you trying to accomplish?

The answers may foster more direct / complete information.

Rajesh117

Actually according to requirement we have to create 2 custom workflow:-

1) a custom workflow which deploy content to runtime(we have done)

let us say custom PLC which deploy content to runtime and delete expired content from there

2) next custom workflow which delete expired content from teamsite.

so to update all the table for deleted content we require to trigger query ,so that it can update all the table related to expire content.

Thanks,

Rajesh

sheikh1

2) next custom workflow which delete expired content from teamsite.

You can maintain the expiration/archived date as part of metadata for your files. You don't have to run any external query to update/delete rows from database, this is not recommended