We need some help on we Livereport sorted by workfllow

Frans_Akkermans_(shell-fakkermans_-_(deleted))

Hi,We have several types of workflows within our Livelink installation. Examples a workflow for engineering request and another for costs savings. Each type of workflow is used often. We want to make a livereport of only engineering request workflows. We have some difficulties to find in Oracle where the type of workflow is stored (if at all). Can somebody give us a hint.

eLink User

Message from David Slimmon via eLinkHi there,As far as the current version of Livelink is concerned, there isn't really a 'type'of workflow that gets stored in the database. In other words, Livelink doesn't knowwhich of your workflows are engineering workflows and which are cost savingsworkflows. Having said that, it does store information about which workflow wasinitiated to begin the process. So, in theory, if you have your workflows logicallyarranged in certain locations, you might be able to come up with some LiveReportsthat *could* indicate where the workflow is coming from. In fact, you can also dothis if you know the names of your workflow maps to begin with.Certainly the *easiest* scenario would be if you had your engineering requestworkflows in one folder and your cost savings workflows in another. But even if youdidn't all you'd really need to do is query the wwork table.For example, the following query should describe all of the workflow work (steps,etc.) that exists in your Livelink database for a Workflow that has been initiated asSampleWorkflow1:SELECT * FROM WWorkWHERE Work_Title='SampleWorkflow1'The problem with this is that it is possible for your users to initiate the workflowunder a different name than the name of the Workflow map itself. In the exampleabove, my workflow was initiated as SampleWorkflow1 which is the Livelink default.(Livelink will initiate the workflow as the name of the workflow map itself). If youcan be sure that this is what your users are doing, then the query above is probablyenough to list all of the workflows that have been initiated as a certain type.For example, if your Engineering Request workflow map is called,"Engineering_Request", the following SQL statement would find all of the work in theLivelink database for workflows that were initiated based on that map:SELECT * FROM WWorkWHERE Work_Title=''Engineering_Request'But, as mentioned, this won't find those that were initiated using another title inthe "Initiate As" field. Now, I believe that you can alter your workflows such thatusers aren't given the option of altering the Initiate As step. Either way, you werecorrect in stating in a previous posting that much of this may change in the upcomingreleases of workflows. In the meantime, this might provide you with a handy littleworkaround.Regards,Dave-----Original Message-----We need some help on we Livereport sorted by workfllowPosted by shell-fakkermans on 04/11/2000 01:12 PMHi,We have several types of workflows within our Livelink installation.Examples a workflow for engineering request and another for costs savings.Each type of workflow is used often. We want to make a livereport of onlyengineering request workflows. We have some difficulties to find in Oraclewhere the type of workflow is stored (if at all). Can somebody give us a hint.