Stump the Panel » SharePoint Workflow for All Users

Routing using Database Information

(3 posts)

  1. Sean
    Member

    Hi,

    I want to create a "single" workflow that can be assigned to many libraries and sites, such that the routing information is derived from a rather complex routing table.

    Tables are "ProcessesTable" with columns ProcessNo, ProcessName; and "ProcessRedirectionTable" with columns FromProcess, ToProcess.

    Thing being I might route OneToOne or OneToMany based on the database read of the
    ProcessRedirectionTable.

    Why do it this way - well I have in excess of 500 documents across 15 individuals of various reponsibility etc...

    Any thoughts, can SPD use a Database Routing Table for example, or s it simply a case of "use VS"...

    many thanks in advance,
    regards
    Sean

    Many thanks

    Posted 4 days ago #

  2. Toni
    Moderator

    Well I would suggest building a custom VS workflow and attaching it to a content type. This content type and workflow should be then used across your sites.

    SPD workflows cannot be attached to content types and do not support what you need OOTB.

    I do not know of 3rd party solution that works with content types.

    Posted 3 days ago #

  3. erugalatha
    Member

    Sean, I have done this but not using database tables - in a Custom VS solution I look up to a Configuration List in SharePoint to get my routing information. I use CAML queries to get that routing information. This way everything is managed within SharePoint. I guess you could do it in SQL table also if you wanted to.

    The workflow part is not easy but it is doable in Visual Studio. I didn't attempt to do it in SPD because SPD still has too many rough edges for me.

    As Toni mentions you will use Content Types (if you use VS way) ... more than one if you want custom Task editing pages.

    If you decide to go the VS route then check out the Headcount Request article on MSDN before you start. It will give you a fair idea of the amount of work involved. Here is the link: http://msdn.microsoft.com/en-us/library/cc811589.aspx

    This sample does not contain lookup for routing but if you're stuck with that part post back. All it entails is a custom class addition that queries a SharePoint list.

    Posted 3 days ago #

RSS feed for this topic

Reply

You must log in to post.