Count how many items that has the same title in Sharepoint Designer 2010 Workflow Editor

全部回复

• 2012年6月15日 19:33

   

   
  

  0

  Hi

  my question is

  you need to see if an item in issue tracking list, item's status go to "active" more than 4 times?

  In this case, Another approach

  Add a new column, hidden, let's name it  COL_STATUS_ACTIVE, numeric type, initial value =0.

  In the workflow , each time that the item go to status = ACTIVE, then change

  COL_STATUS_ACTIVE= COL_STATUS_ACTIVE+1

  Next also in the workflow analyze

  IF

  COL_STATUS_ACTIVE=4, then

  email as you need

  ---

  Romeo Donca, Orange Romania (MCSE, MCTS, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

  
  

  • 已编辑 romeo donca 2012年6月15日 19:34
  •  
  • 回复
  • 引用

   
• 2012年6月15日 19:54

   

   
  

  0
  Not exactly. I dont want to track if an item goes active more than 4 times, I want to track if 4 items for the same issue (same title) are active.
  • 回复
  • 引用

   
• 2012年6月16日 7:19

   

   
  

  1

  Hi

  this case

  keep in a separate list ( FIRST_LIST) the issue title. In this list insert also a new column, COL_issue_ACTIVE

  in the basic list, insert a lookup up filed as issue_title from FIRST_LIST

  Aslo attacha workflow when an item is added or changed, which based on item's status will add (+)  or substratc(-) 1 value to column COL_issue_ACTIVE  from FIRST_LIST for item = current ISSUE_TITLE

  Also in FIRST_LIST add a workflow when an item is changed , and put a condition

  COL_ISSU_ACTIVE = 4

  send your email

  ---

  Romeo Donca, Orange Romania (MCSE, MCTS, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

  • 已标记为答案 Craf7yCris 2012年6月18日 15:12
  •  
  • 回复
  • 引用

   
• 2012年6月18日 15:13

   

   
  

  0

  Yes, I think that should do it. It seems a bit of a workarround but that works for me.

  Thank you very much.

  • 回复
  • 引用