locked
Access and work with columns in Sharepoint Document Library and Workflow Task List RRS feed

  • Question

  • How do we access and change the data types and value displayed in columns contained in document library and columns contained in workflow task list?

    Is there a code-free solution?

    If not, where do we make the code changes?

    Would greatly appreciate any help!

    Tuesday, October 18, 2011 7:11 AM

Answers

  • If I understand this correctly then you can solve your problem by simply creating a additional column to store the status (Approved, Rejected etc)

    Modify the workflow running on base library to change status on this new column also.

    Now display this calumn to all users and your hyperlink column to the managers.

     


    Shubham Goyal
    Wednesday, October 19, 2011 2:16 PM

All replies

  • Tell us what excatly you need to do.

    You want to change the data types of the columns or the values of those columns?

    For changing the values you can create a SharePoint Designer workflows

    For columns in task list, SharePoint Designer task related actions would handle it for you.

    Tell us your requirement properly so that we can help


    Shubham Goyal
    Tuesday, October 18, 2011 2:10 PM
  • Thanks for the reply.

    We have 2 views created from same document library. One is for displaying "All Orders", one is for displaying "Orders Waiting for Approval".

    The "All Orders" view is enabled for anyone logging into the system. But the "Orders Waiting For Approval" view is made available only to manager group who will need to approve/reject orders.

    The base document library we have has a workflow status column (which is hyperlink type) called Order Status. This column gets updated internally by the workflow whenever a task gets completed (approve/reject) - this column displays text like "Prod Mgr Review", "Gen Mgr Review" etc. Users can click this hyperlink column to go to the approval page.

    For the "Orders Waiting For Approval" view (visible only to managers), we need the Order Status hyperlink/clickable column to let users go to approval page.

    However, in the "All Orders" view (visible to everyone), we wish to only display the status - we do not want (unauthorized) users to click the Order Status hyperlink and go into approval page

    So we are trying to either (i) make the Order Status column a non-hyperlink/label type on "All Orders" view - but which we cannot do, since it is a workflow driven column...or (ii) try to add a new label column to the "All Orders" view and pull the value of Order Status column into it....second option is also difficult bcoz we are unable to understand where the workflow column gets set with the status in code...we are tracing the features, workflow class everything but cannot pinpoint place where the value gets set in this workflow column - breakpoints in debug mode are also not going into all detailed steps....we are certainly lost...!!

    Would appreciate any help!

     

     

    Wednesday, October 19, 2011 10:06 AM
  • If I understand this correctly then you can solve your problem by simply creating a additional column to store the status (Approved, Rejected etc)

    Modify the workflow running on base library to change status on this new column also.

    Now display this calumn to all users and your hyperlink column to the managers.

     


    Shubham Goyal
    Wednesday, October 19, 2011 2:16 PM