Workflow missing from wf_workflow table

[Michael Gedzelm]

Hi all.  I went to "Workflow editor"  and also to "workflow versions", and in both places I found some published active workflows on the sc_req_item table that were created about 8 years ago.  I made some temporary changes, published them, and now I want to go back to the original versions.  Everything I search, tells me to go to the wf_workflow  table, open the record, find the version I want (under related lists) and then revert back to that version.  Problem is these records don't exist in the wf_workflow table; only in the wf_workflow_version table.  What does this mean?  How can you have versions of workflow without having the workflow itself?  Does this possibly mean the workflow isn't really firing off at all? Thanks.  Much appreciated!

[Elijah Aromola]

That is correct. The process to rolling back a workflow is to go to wf_workflow_version find a previous version and set "Published" to true. The different versions are not on the wf_workflow table, only the workflows themselves.

[Michael Gedzelm]

Thanks.  To your first comment,  "find a previous version and set "Published" to true. ", I cannot do this.  Nothing is editable despite the fact that I have admin role. 

To your second comment "The different versions are not on the wf_workflow table, only the workflows themselves.", this is a misunderstanding.  I wasn't saying that the versions should be in wf_workflow table.  I said that that the workflow itself does not exist at all in the wf_workflow table, and then I asked what this could mean.  See my original post.  

[Elijah Aromola]

You can write a script to update it.

var wf_version = new GlideRecord("wf_workflow_version");
if (wf_version.get("sys_id_of_version")) {
    wf_version.published = true;
    wf_version.update();
}

I haven't seen a workflow not exist on that table personally. Does the catalog item submission work and flow properly? 

[Michael Gedzelm]

Thanks.  Forgive me, I'm a little new to workflows and service now.  What I'm really trying to figure out is:  If a workflow exists in the wf_workflow_version table but missing from wf_workflow table, is it really active and firing?   I just looked at the workflow log table,  and after submitting a catalog item request, there are no log records being generated for the above mentioned workflows.  However, there are log records being generated for a another workflow associated with the sc_request table that is in the wf_workflow table.  So, I believe that the answer to my question is "no", if a workflow exists in the wf_workflow_version table but not in the wf_workflow table, the workflow will not actually work.