Adding Field to Workflow Manager Table

Question

Hello,

Another question about workflow manager. Is it okay to add a field to one of Workflow Manager Tables (e.g. JTX_JOBS or JTX_JOB_TYPES table)? Is there any drawback will be happened either in the desktop version or in the server version?

Regards,
Naufal

MuhammadNaufalIhsan · Answer

Hi Michael,
I think the parent/child relationship will not solve the problem (I've tried before).

The goals is, i want to determine how many percentage does a job give to the whole work process. Since workflow manager only give the percentage for each job, my idea is to add new field to define the "weight" of a job to the whole work process (the whole percentage will be complete percentage of a job * the weight of the job).

So far, I've added a new field to the JTX_JOB_TYPES, and it is turned out to be fine. However, if you have any other way to reach the aforementioned goals, i'm open to any suggestions.

Regards,
Naufal

MuhammadNaufalIhsan · Answer

Hi Laurens.

Sadly, I am not really good with SQL Queries 
. But thanks for the advice, i will check the reporting functionality.

As for the pending days information, actually, i only want to determine the difference between the end date (when the job is closed) and the due date (the job's deadline). Although, yes, i have to run a field calculator every time a job is closed to get the number.

Anonymous User · Answer

Hi Naufal,

We don't encourage adding fields to the existing Workflow Manager tables as it can result in corruption and at the very least puts you in an unsupported state.

I think what you actually need to explore is the concept of the parent/child relationship. You need to make a parent job type (A) that you can associate all the jobs from this particular job type you're interested in (B). You can then report on B as a function of all the underlying A jobs, and even add the A jobs into a workflow for B as dependencies to help cement the relationships.

If this doesn't resonate I'd be interested in learning more about the particular use case you're trying to solve

Thanks,

Michael