SharePoint - Content Query Web Part and Custom List Workflow

Asked By Jan
11-Sep-08 04:03 AM
Hi all,

We have created a Custom List. Nothing fancy, it simply shows a subject and
some RTF text. For this list, we created a new Approval Workflow. It is to be
started whenever someone creates or edits a record in this list. Works fine.

Now, we would like to use the CQWP on the front page to show all items in
this list. Sounds simple, and so far that part works fine. But if we only
wanted to show entries in the Custom List that have been approved in the
Workflow? How do we do that? Yes, there is a possibility to limit the items
shown using Approval Status, but that refers to the status of the element in
the list, and *not* the status of the associated workflow.

How do we refer to the Workflow? We simply want to only show items from the
custom list that have been approved in the approval workflow associated with
the list.

Best regards, JanK
JanKSolved
(1)
CQWP
(1)
RTF
(1)
Workflow
(1)
Custom
(1)
Approval
(1)
Status
(1)
Items
(1)
  Jan replied...
11-Sep-08 07:56 AM
Solved it myself. Posting it here in case someone else's hair ends up turning
grey after battling with this:

http://support.microsoft.com/kb/925425/en-us

Jeez, this was far out ...
Create New Account
help
sharepoint workflow stops SharePoint I have users that create a workflow simply using the built in Request Approval workflow. They set it to run in serial and put two names on the approvers line and their task changes to complete. However, the 2nd person never gets a task. The workflow sits at status "in progress" forever. The history shows the workflow initiated and the first persons task being created. That's it. This seems to happen on a single site collection in the farm. Other site collections with the same workflow do not have this problem. They do in fact create the 2nd task once the Type: text / plain Content-Transfer-Encoding: 7bit Hi Superbrown1, There is a known issue the workflow trapped in infinite loop if both "Start this workflow when an item is changed" and "Update the approval status (use this workflow to control
Access denied on starting workflow programmatically SharePoint Hello, I have a event handler that basically starts a workflow programmatically that is associated with a content type and the option "Require Manage Lists Permission" for starting the workflow manually to disallow non-admin users to start the workflow manually. Here is the code: / / start specified workflow that is associated with the item SPWorkflowManager manager = listItem.Web.Site.WorkflowManager; / / get list item content type SPContentType contentType = listItem.ContentType; / / get list item workflow associations SPWorkflowAssociationCollection associationCollection = contentType.WorkflowAssociations; / / iterate all item workflow associations foreach (SPWorkflowAssociation association in associationCollection) { Guid workflowGuid = new Guid(workflowId); / / check if current workflow association matches the specified workflow if (association.BaseId = = workflowGuid) { string data = association.AssociationData; listItem.Web
Workflow scenario from a newbie. Best approach? SharePoint Hello, all I am new to workflow am looking to see what the best solution is for my company's tracking / auditing to see what is the best way of going about this, and even if sharepoint workflow is / is not the best way to proceed. Our scenarios is that there are 33 The problem is that someone needs to individually start all 33 tasks for the entire workflow to be active. This won't fly with the end users who will be kicking something to think on. You don't need 33 workflows here, you need a single workflow which contains all the relevant tasks. Your workflow will probably have an initiation form which collects information and then starts the main workflow. When the workflow starts it will do set up, and initial task creation and assignment. It would seem
Start Workflow SharePoint I have sharepoint 3.0, and i made a workflow that is manually started. Now the company wants to make it start automatic. Is there away to switch the way a workflow starts without rewritting the whole thing? SharePoint Discussions Visual Studio (1) SharePoint (1) SPD (1 Galant (1) Xoml.wfconfig.xml (1) Workflows (1) Doule (1) How did you make the workflow? Is this an out of the box workflow you configured settings for? Is this a workflow you created in SharePoint Designer? Is it a workflow you created in Visual Studio? If it is an OOB workflow then simply go to the library, list or content type the workflow is attached to
WSS 3.0 Service Pack 3.0 MOSS 2007 Service Pack 2.0 Behaviour: A Workflow we are developing has tempremental problems that appear to be based around the OnTaskCreated event. Sometimes during the workflows life the workflow stops working and never recovers. This appears to be happening around the OnTaskCreated event. Randomly the workflow will run and debug at other times the workflow seems to stop working. If I need to supply more information please let me know. I would like assistance how to progress with this workflow, with particular attention to how I can resolve this problem. Example During debug {"Event \ "OnTaskCreated on interface type \ "Microsoft.SharePoint.Workflow.ITaskService \ " for instance id \ "ccf4e8d0-e59b-4526-88ca-b30e633e85a6 \ " cannot be delivered."} Example ULS: 10 / 30 / 2009 14:00:47.26 w3wp.exe (0x1508) 0x117C Windows SharePoint Services Workflow Infrastructure 936l High Engine RunWorkflow: System.Workflow.Activities.EventDeliveryFailedException: Event on interface type "Microsoft.SharePoint.Workflow.ITaskService" for instance id "ccf4e8d0-e59b